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
SQL*Loader can be used to load data from Delimiter separated files and
fixed............
Define Exceptions in PL/SQL, Explain how to define and raise exceptions in
PL/SQL............
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..............
|
