Oracle Select into clause

          

Oracle Select into clause

<<Previous  Next>>

Describe the SQL attributes of Select into clause, i.e. SQL % Not found, SQL % found, SQL % Isopen, SQL %Rowcount.

Oracle Select into clause - Dec 03, 2008 at 15:00 PM by Rajmeet Ghai

Describe the SQL attributes of Select into clause, i.e. SQL % Not found, SQL % found, SQL % Isopen, SQL %Rowcount.

% Not found: True if no rows returned
E.g. If SQL%NOTFOUND then return some_value

% found: True if at least one or more rows returned
E.g. If SQL%FOUND then return some_value

%Isopen: True if the SQL cursor is open. Will always be false, because the database opens and closes the implicit cursor used to retrieve the data

%Rowcount: Number of rows returned. Equals 0 if no rows were found (but the exception is raised) and a 1, if one or more rows are found (if more than one an exception is raised).


Also read
What is the difference between the SQL*Loader and IMPORT utilities?

SQL*Loader can be used to load data from Delimiter separated files and fixed............

Oracle Exceptions

Define Exceptions in PL/SQL, Explain how to define and raise exceptions in PL/SQL............

Oracle cursors interview questions

What a SELECT FOR UPDATE cursor represent?, What WHERE CURRENT OF clause does in a cursor?, Can you pass a parameter to a cursor?, Explain the functioning of CURSOR FOR LOOP with example., Define Simple/Explicit , Parametric and Internal/Implicit cursor..............

<<Previous  Next>>



Write your comment - Share Knowledge and Experience


 

 
Interview questions
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring