plsql tutorial#17 What is record datatype in oracle pl/sql database

in this plsql oracle database tutorial, I am going explain PLSQL record datatype, definition: PL/SQL record is a composite data structure that is a group of related data stored in fields. Each field in the PL/SQL record has its own name and data type

PLSQL Complete series :

Oracle SQL Complete Tutorial/Training/Course for the beginner:

follow me on:
Facebook Page:

[ArvindSingh-mjrb]

hI SIR, why cursor, record or any collection does not return data into table format directly as return into sql server. it always do we need to print into dbms.ouptut_put.line statement.?

[tirumalasettyvamsikrishna]

create procedure myrowtype
is
emprec emp%rowtype;

begin
select * into emprec
from emp;


end;/


begin
myrowtype();
end;/

sir getting error can you solve it
the error displays is
ORA-01422: exact fetch returns more than requested number of rows

[genesmith]

Stop saying, "nothing but."