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 retrieve daily sal from emp table in oracle 10g
What is the difference between Delete, Truncate and Drop in Oracle?
What is difference between a formal and an actual parameter?
How to assign values to data fields in record variables?
State and explain about oracle instance?
How to start instance with a minimal initialization parameter file?
25. Display the client number and the value of the highest value order placed by that client.
How to create a table interactively?
There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees who doesn't belong to any dep
In oracle there is column command, how will you explain that?
can u call user defined functions in select statements
Who developed oracle & when?