INTERVIEW QUESTIONS ORACLE SQL IN ORACLE DETAILS

Question: Difference between NO DATA FOUND and %NOTFOUND

Answer: NO DATA FOUND is an exception raised only for the SELECT....INTO statements when the where clause of the query does not match any rows. When the where clause of the explicit cursor does not match any rows the %NOTFOUND attribute is set to TRUE instead.

NO DATA FOUND is an exception raised only for the SELECT....INTO statements when the where clause of the query does not match any rows. When the where clause of the explicit cursor does not match any rows the %NOTFOUND attribute is set to TRUE instead. Source: CoolInterview.com

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.
Source: CoolInterview.com

NO_DATA_FOUND as a predefined oracle exception which is raised by oracle when a select statement doesn't find a record.
Ex:

Declare
strEName Varchar(100);
Begin
Select EName Into strEName Where EmpID = 1357;
DBMS_OUTPUT.Put_Line(strEName);
Exception
When No_Data_Found Then
DBMS_OUTPUT.Put_Line('Record Not Found');
End;

This statement will raise "No_Data_Found" exception if a record for empid 1357 doesn't exist in the EMP table.

%NotFound is a cursor attribute which return true if last statement doesn't find any data. If works with both implicit and explicit cursor.
Implicit Cursor : SQL%NotFound
Implicit Cursor : CurName%NotFound Source: CoolInterview.com

what is the main use of gl inbound interface? Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question