Implicit Cursor Attributes

The Implicit cursor attributes returns the information about the execution of an INSERT, DELETE, UPDATE, or SELECT INTO statement. The cursor attribute values always refer to the most recently executed SQL statement. Before the Oracle opens SQL cursor, the implicit cursor attributes yields NULL.

Posted Date: 10/4/2012 4:46:03 AM | Location : United States

Ask an Expert

Related Discussions:- Implicit cursor attributes, Assignment Help, Ask Question on Implicit cursor attributes, Get Answer, Expert's Help, Implicit cursor attributes Discussions

Write discussion on Implicit cursor attributes
Your posts are moderated

Write your message here..

Related Questions

Iterative control: loop statement, Iterative Control: LOOP  Statements T... Iterative Control: LOOP  Statements The LOOP statement executes a series of statements multiple times. There are 3 forms of LOOP statements: LOOP, WHILE-LOOP, & FOR-LOOP. LOOP

Dynamic ranges- iterative control, Dynamic Ranges The PL/SQL lets you det... Dynamic Ranges The PL/SQL lets you determine the loop range dynamically at run time, as the example below shows: SELECT COUNT(empno) INTO emp_count FROM emp; FOR i IN 1..emp_cou

Effects of null in table literal, Effects of NULL in Table Literal Whe... Effects of NULL in Table Literal When a VALUES expression appears as the source value for an SQL INSERT statement, the key word NULL can appear as a field value, such that for

Theory of panspermia - origin of life, THEO R Y OF PANSPERMIA - Arrh... THEO R Y OF PANSPERMIA - Arrhenius (1908) postulated the cosmic panspermia theory that claims that organisms existed throughout the universe, and their spores, etc., could

Pragma restrict_references in pl sql, Using Pragma RESTRICT_REFERENCES: ... Using Pragma RESTRICT_REFERENCES: The function called from the SQL statements should obey certain rules meant to control the side effects. To check for violation of the rules,

Package standard, Package STANDARD The package named STANDARD defines t... Package STANDARD The package named STANDARD defines the PL/SQL atmosphere. The package specification globally declares the exceptions, types, and subprograms that are available

Manipulating objects in pl sql, Manipulating Objects: You can use an o... Manipulating Objects: You can use an object type in the CREATE TABLE statement to indicate the datatype of a column. When the table is created once, you can use the SQL statem

Perform exception handling with user-defined errors, On occasion, some of B... On occasion, some of Brewbean's customers mistakenly leave an item out of a basket already checked out, so they create a new basket containing the missing items. However, they requ

%rowcount - implicit cursor attributes, %ROWCOUNT The %ROWCOUNT yields... %ROWCOUNT The %ROWCOUNT yields the number of rows affected by the INSERT, UPDATE, or DELETE statement, or returned by a SELECT INTO statement. The %ROWCOUNT yields zero when a

Join query, Using a join on 3 tables, select 5 columns and 10 rows from the... Using a join on 3 tables, select 5 columns and 10 rows from the 3 tables without the use of a Cartesian product Query: SELECT E.LAST_NAME, E.FIRST_NAME, S.BUILDING, S.BRAN