| |
GeekInterview.com > Interview Questions > Oracle > SQL
| Print | |
| Question: Difference between NO DATA FOUND and %NOTFOUND
Answer:
NO DATA FOUND is an exception raised only for the SELECT....INTO statements when the where clause of the querydoes not match any rows. When the where clause of the explicit cursor does not match any rows the %NOTFOUND attribute is set to TRUE instead. |
| July 07, 2006 00:03:22 |
#1 |
| Ayan Mahalanabish |
Member Since: Visitor Total Comments: N/A |
RE: Difference between NO DATA FOUND and %NOTFOUND
|
| NO DATA FOUND is an Exception whereas %NOTFOUND is a cursor attribute |
| |
Back To Question | |
