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
Extension and AND in SQL The theory book gives the following simple example of relational extension in Tutorial D: EXTEND IS_CALLED ADD ( FirstLetter ( Name ) AS Initial )

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

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

Declaring Subprograms   You can declare subprograms in any PL/SQL subprogram, block, or package. But, you should declare subprograms at the end of the declarative part after a

FETCH Statement The FETCH statement retrieve rows of data one at a time from the result set of the multi-row query. The data is stored in fields or variables which correspond t

Declaring Exceptions The Exceptions can be declared only in the declarative part of the PL/SQL subprogram, block, or package. By introducing its name, you can declare an excep

Accessing Attributes: You can refer to an attribute only by its name not by its position in the object type. To access or modify the value of an attribute, you can use the dot

Example of Cast Operator So long as CAST is used as shown, we could obtain the total marks for each exam in similar fashion, using SUM (Mark) AS TotalMarks. However, this giv

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

Advantages of Subprograms The Subprograms give extensibility; that is, tailor the PL/SQL language to suit your requirements. For illustration, if you require a procedure which