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
Magento change address format depending on store Project Description: What I need is that depending on the store in which the customer bought the address should change the fo

MECHANISTI S THEORY-HAECKEL (1866) - Haeckel stating that after each catalysm, some new organism suddenly forms as a chance event in one stride from inanimate matter and sub

Redeclaring Predefined Exceptions Keep in mind that, the PL/SQL declares predefined exceptions globally in the package STANDARD; Therefore you need not declare them yourself.

Using LIMIT For nested tables, that have no maximum size, the LIMIT returns NULL. For varrays, the LIMIT returns the maximum number of elements that a varray can have (that yo

Advantages of Wrapping   The PL/SQL Wrapper convert the PL/SQL source code into a transitional form of the object code. By hiding the application internals, the Wrapper secure

%TYPE: This attribute gives the datatype of a formerly declared collection, cursor variable, object, field, record, database column, or variable. Datatype: This is simply

Parameter Aliasing   To optimize the subprogram call, the PL/SQL compiler can decide between the two techniques of the parameter passing. With the by-value techniques, the v

Assignment of Variable - Updating a Variable Syntax: SET SN = SID ('S2'); This can obviously be read as "set the variable SN to be equal in value to SID ( 'S2' )".

Procedures   The procedure is a subprogram which performs a specific action. You write procedures using the syntax as shown below: PROCEDURE name [(parameter[, parameter, .

Data Types and Representations This explains the concept possible representation, abbreviated possrep, and explains how these can be used in conjunction with constraints to de