Parameter and keyword description - sql cursor, PL-SQL Programming

Parameter and Keyword Description:

SQL:

This SQL is the name of the implicit SQL cursor.

%FOUND:

This attribute results TRUE if an INSERT, DELETE, or UPDATE statement affected one or more rows or a SELECT INTO statement returned one or more rows. Or else, it results FALSE.

%ISOPEN:

This attribute always results FALSE as the Oracle closes the SQL cursor automatically after executing its related SQL statement.

%NOTFOUND:

This attribute is the logical reverse of the %FOUND. It results TRUE if an INSERT, DELETE, or UPDATE statement affect no rows, or the SELECT INTO statement returned no rows. Or else, it results FALSE.

%ROWCOUNT:

This attribute results the number of rows affected by an INSERT, DELETE, or UPDATE statement, or returned by the SELECT INTO statement.

Posted Date: 10/8/2012 8:07:10 AM | Location : United States







Related Discussions:- Parameter and keyword description - sql cursor, Assignment Help, Ask Question on Parameter and keyword description - sql cursor, Get Answer, Expert's Help, Parameter and keyword description - sql cursor Discussions

Write discussion on Parameter and keyword description - sql cursor
Your posts are moderated
Related Questions
Using FORALL and BULK COLLECT Together You can unite the BULK COLLECT clause with the FORALL statement, in that case, the SQL engine bulk-binds column values incrementally. In

UNNEST operator in SQL The inverse operator of GROUP is UNGROUP. SQL has an operator, UNNEST, that can be used for similar purposes, but its method of invocation is somewhat p

Semijoin and Composition - SQL For semijoin, the dyadic relational operator MATCHING, defined thus: r1 MATCHING r2, where r1 and r2 are relations such that r1 JOIN r2 is de

Operator Precedence The operations within an expression are completed in a particular order depending on their precedence (priority). The table shows the default order of the op

Example of Shorthand for a row constraint Example: Shorthand for a row constraint ALTER TABLE EXAM_MARK ADD CONSTRAINT Mark_in_range CHECK (Mark BETWEEN 0 AND 100);

Definition of FROM - SQL Recall that the operand of FROM is denoted by a commalist, each element of that commalist being a table expression optionally accompanied by a range v

Case Sensitivity Similar to all the identifiers, the variables, the names of constants, and parameters are not case sensitive. For illustration, PL/SQL considers the following n

Defining and Declaring Collections To create the collections, you must define a collection type, and then declare the collections of that type. You can define the VARRAY types a

Keys in SQL SQL support for keys in the following respects: SQL does not require at least one key for every base table. If no key is explicitly declared, then KEY {ALL B

Organi c Evolution Evolution is a slow continuous, irreversible and natural process of change to give rise to advance and diverse forms of life i.e. formation of new specie