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

Sir..can u start dba course..

Mast Video hai ;)

create procedure myrowtype
is
emprec emp%rowtype;

begin
select * into emprec
from emp;

dbms_output.put_line(emprec.sal||emprec.ename);
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

The best explaination

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.?

So nice equalConnect Coach.👍

Stop saying, "nothing but."