Example of “TOO_MANY_ROWS” Exception - DBMS (Exception)

declare

add1 student.address %type;

sname student.name %type;

begin

sname:='&sname';

select address into add1 from student;

dbms_output.put_line('Address of the student is '||add1);

exception when Too_many_rows then

dbms_output.put_line('There are too many rows');

end;