Parameter and keyword description - fetch statement, PL-SQL Programming

Parameter and Keyword Description:

cursor_name:

This identifies an explicit cursor formerly declared within the present scope.

cursor_variable_name:

These identify a PL/SQL cursor variable (or parameter) formerly declared within the present scope.

host_cursor_variable_name:

This identifies a cursor variable declared in the PL/SQL host atmosphere and passed to the PL/SQL as a bind variable. The host cursor variable datatype is well-suited with the return type of any PL/SQL cursor variable. The Host variables should be prefixed with a colon.

BULK COLLECT:

This clause instructs the SQL engine to bulk-bind the output collections before returning them to the PL/SQL engine. The SQL engine bulk-binds all the collections referenced in the INTO list. The corresponding columns should store scalar (not the composite) values.

variable_name:

This identifies a formerly declared scalar variable into which a column value is fetched. For each and every column value return by the query related with the cursor variable or cursor, there should be a analogous, type-compatible variable in the list.

record_name:

This identifies a user-defined or %ROWTYPE record into which the rows of values are fetched. For each and every column value return by the query is related with the cursor variable or cursor, there should be a analogous, type-compatible field in the record.

collection_name:

This identifies a declared collection into which the column values are bulk fetched. For each query select_item, there should be a analogous, type-compatible collection in the list.

host_array_name:

This identifies an array (stated in the PL/SQL host atmosphere and passed to the PL/SQL as a bind variable) into which the column values are bulk fetched. For each query select_item, there should be a corresponding, type-compatible array in the list. The Host arrays should be prefixed with a colon.

Posted Date: 10/8/2012 6:44:09 AM | Location : United States







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

Write discussion on Parameter and keyword description - fetch statement
Your posts are moderated
Related Questions
PITS Depressions in secondary cell wall is called pit. A pit present on the free cell wall surface without its partner is called Blind pit. It consists of 2 parts -

Need to change mysql query to PDO Project Description: I want someone to convert me 1 .php file that includes some sql/mysql stuff to PDO is a very small file. Skills requ

Parameter and Keyword Description: package_name: This construct identifies the package. AUTHID Clause: This determine whether all the packaged subprograms impleme

%NOTFOUND The %NOTFOUND is logical, opposite of the %FOUND. The %NOTFOUND yields FALSE if the last fetch returned a row, or TRUE when the final fetch failed to return a row. I

Collection Methods:   The collection method is a built-in function or procedure which operates on the collections and is called using the dot notation. The methods like the C

Oracle 10G new features:- Automatic Database Diagnostic Monitor System Advancements - these methods will provides several methods for extracting reports through the Automatic

Transaction context As the figure shows, the major transaction shares its context with the nested transactions, but not with the autonomous transactions. Similarly, If one aut

Create a view named CustomerAddresses that shows the shipping and billing addresses for each customer in the MyGuitarShop database. This view should return these columns from the

Rollback Behavior When a FORALL statement fails, the database changes are rolled back to an implicit savepoint marked before each of the SQL statement execution. The Changes t

Special cases of projection This section describes the identity projection, r {ALL BUT}, and the projection on no attributes, r { }, which yields TABLE_DUM when r is empty, ot