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 |
how to find the n'th highest salary from emp ?
How would you design a database for an e-commerce website?
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
Describe Referential Integrity ?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
What do database buffers contain?
What are the uses of Database Trigger ?
What are various joins used while writing SUBQUERIES?
What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
How can we force the database to use the user specified rollback segment?
How to use an explicit cursor without open statements?
What is Network Database link ?