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 |
i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash
What are the types of partitions in oracle?
What is an oracle database table?
What does ROLLBACK do ?
1.display list of all users from ur data base.what is the query?
How to divide query output into groups in oracle?
Explain the function of optimizer in oracle?
Is primary key indexed by default in oracle?
what is the difference between substr and instr function in oracle?
How to connect ms access to oracle servers?
5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.
How to export your connection information to a file?