| |
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 16:24:45 |
#3 |
| mala |
Member Since: Visitor Total Comments: N/A |
RE: In PL/SQL if we write select statement with INTO c...
|
Hi All,
Yes you can handle Too_Many_Rows exception when you are writing into a PL/SQL block SELECT...INTO statement.
Just write the SELECT...INTO statement in a CURSOR.
Regards.
Mala |
| |
Back To Question | |
