Why no_data_found exception is not raised
prakashJul 7 2011 — edited Jul 7 2011Hi all,
Why no_data_found exception is not raised when ever we use min or max in select statement.
Kindly take a look at below plsql block.
declare
v_date date;
begin
select min(hiredate) into v_date from emp11 WHERE EMPNO=736900;
dbms_output.put_line(v_date);
exception
when others
then
dbms_output.put_line(sqlcode);
dbms_output.put_line(sqlerrm);
end;
/
Thanks,
P Prakash