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

Ssrs report writing, SSRS Report Writing Project Description: This re... SSRS Report Writing Project Description: This report is part of a larger project to make a SQL Server Reporting Service (SSRS) based reporting solution. There can be more rep

Read-only operator (+) - sql, Read-Only Operator (+) - SQL The term r... Read-Only Operator (+) - SQL The term read-only operator to the mathematical term function. Here I just need to add that the SQL standard reserves the term function for read-

Order of evaluation-pl/sql expressions , Order of Evaluation When you do... Order of Evaluation When you do not use the parentheses to specify the order of evaluation, the operator precedence determine the order. Now compare the expressions below: NOT

Keyword and parameter description - forall statement, Keyword &Parameter De... Keyword &Parameter Description: index_name: This is an undeclared identifier which can be referenced only within the FORALL statement and only as the collection subscript

Aggregate assignment-declarations in sql, Aggregate Assignment The %ROWT... Aggregate Assignment The %ROWTYPE declaration cannot include an initialization clause. Though, there are two ways to assign values to all fields in a record at once. At First, t

Use external routines - improve performance of application, Use External Ro... Use External Routines The PL/SQL is particular for the SQL transaction processing. Therefore, several tasks are more quickly completed in a lower-level language like C that is

Inner join, Inner Join We have learned how to retrieve data from one t... Inner Join We have learned how to retrieve data from one table by using SELECT statement. But, as we have learned, normalized relational databases mean the data is spread betw

Example of alternative formulation as a table constraint, Example of Altern... Example of Alternative formulation as a table constraint Example: Alternative formulation as a table constraint ALTER TABLE EXAM_MARK ADD CONSTRAINT Must_be_enrolled_to_

Understanding varrays, Understanding Varrays The Items of type VARRAY ar... Understanding Varrays The Items of type VARRAY are termed as the varrays. They permit you to relate a single identifier with the whole collection. This relationship lets you man

Using inner join, Using INNER JOIN INNER JOIN is used to retrieve the ... Using INNER JOIN INNER JOIN is used to retrieve the data from all tables listed based on a condition of equality listed after keyword ON. If the condition is not meet, rows ar