| |
GeekInterview.com > Interview Questions > Oracle > PL/SQL
| Print | |
Question: In PL/SQL if we write select statement with INTO clause it may return two exceptions NO_DATA_FOUND or TOO_MANY_ROW . To do you avoid these execeptions. How do you write SQL statement in alternative way?
|
| March 03, 2007 06:55:55 |
#1 |
| Nikhil_4_Oracle |
Member Since: Visitor Total Comments: N/A |
RE: In PL/SQL if we write select statement with INTO c...
|
hi all,
there is no other way for NO_DATA_FOUND and TOO_MANY_ROWS
Exception. Just handle them by using Oracle Exception Handler
i.e
-------------
------------
----------
Exception
when NO_DATA_FOUND then
Dbms_output.put_line('No Record');
---------
-----------
-------------
Regards,
Nikhil. |
| |
Back To Question | |
