Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between NO DATA FOUND and %NOTFOUND?
- 1 Answers
- 4401 Views
- I also Faced
- E-Mail Answers
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 |
Can a primary key contain more than one columns?
What is sequence?
How to connect ms access to oracle servers?
How can we delete duplicate rows in a table?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
What is a dynamic performance view in oracle?
What is the quickest way to fetch the data from a table?
what is exact difference between drop and truncate table.
Please explain drop constraint oracle?
How to do clean up if create database failed?
What is a package in oracle?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
Oracle General 
