Difference between NO DATA FOUND and %NOTFOUND?
Answer / nishi
NO_DATA_FOUND is pre defind exception of oracle. when we can't get any data from the table for any query. In that case we will get error.
%NOT FOUND is one of the attribute of explicit cursor. when can't get any data from explicit cursor in that case
%NOT FOUND will returns true otherwise it returns false.
Is This Answer Correct ? | 9 Yes | 0 No |
Difference between an implicit & an explicit cursor.?
How to define an anonymous procedure with variables?
What is an oracle cursor variable?
Explain the use of file option in exp command.
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
What is ADDM Advisor in Oracle?
What is the diff between Oracle and SQL Server
How to start an oracle instance?
without using count(*) and rownum how can we count total record in a table
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
How to drop an existing table in oracle?
The join defined by the default data link is an outer join yes or no ?