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 assign values to data fields in record variables?
what is port in oracle? how is it related to database application.
What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?
How to pass parameters to procedures in oracle?
what is primary key and foreign key when and where have to use
7. Repeat query (7) but also display all clients who have never ordered anything.
What is the use of oracle?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What do you mean by merge in oracle and how can you merge two tables?
what are stored procedures?
what is difference between DBMS and RDBMS?
How do you bind variables in oracle?