Oracle Select into clause

Send request to get interview tips in PDF format Personal Interview - Answers to frequently asked questions Tips to earn promotions and perks You can also get your answers published How to write a good CV? How to write a good Cover Letter? Tips to become boss's favorite CareerRide is hiring

---

<<Previous  Next>>

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).

<<Previous  Next>>