No_data_found exception in insert into ... select statement
681567Mar 18 2010 — edited Mar 18 2010Hai,
I have an doubt in plsql exceptions. In the below mentioned plsql program,
begin
insert into abc select * from xyz a, cdf b where a.c1 = b.c2;
exception
when no_data_found then
do some operations
end;
In the above pl/sql block, if the select statement returns zero rows, whether the exception will be raised or not? If not, how to acheive the same. Any alternative available.
Thanks in advance.
Regards
Sridhar