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
Projection and Existential Quantification - SQL Intuitively it might seem that projection in SQL is simply a matter of specifying the required columns in the SELECT clause, a

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

Multiset types - SQL An SQL multiset is what in mathematics is also known as a bag-something like a set except that the same element can appear more than once. The body of an

Keyword and Parameter Description: label_name: This is an undeclared identifier which optionally labels the PL/SQL block. When used, label_name should be enclosed by the do

LONG and LONG RAW You use the LONG datatype to store the variable-length character strings. The LONG datatype is such as the VARCHAR2 datatype, except that the maximum length o

The SQL ‘CREATE TABLE' scripts for all the tables you have implemented. Note that your tables must correspond exactly to the ERD you have provided in 1. above, or you will lose ma

Assignment Statement: The assignment statement sets the present value of the variable, parameter, field, or element. The statement consists of an assignment target followed by

What Is a Package? The package is a schema object that group logically related PL/SQL items, types, and subprograms. The Packages usually have 2 parts, a specification & a bo

Mutual Recursion The Subprograms are mutually recursive if they directly or indirectly call each other. In the illustration below, the Boolean functions odd & even, that dete

Referencing Records Unlike the elements in a collection, that are accessed using subscripts, the fields in a record are accessed by name. To reference an individual field, you