Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

EXCEPTION When no_data_found THEN

526410Nov 27 2006 — edited Nov 27 2006
Hello all,

Can i quickly ask in the exception for no_data_found is it possible to have an ELSE after the THEN part of the exception.

For example;

SELECT CustID FROM Customers
Where CustID = 'CUS00011'
EXCEPTION
WHEN no_data_Found THEN
<Do This>
ELSE
<Do this instead>


Thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 25 2006
Added on Nov 27 2006
13 comments
699 views