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
Rephrase Conditional Control Statements When computing a logical expression, the PL/SQL uses short-circuit evaluation. That is, the PL/SQL stops evaluating the expression as s

1. Create a procedure called TAX_COST_SP to accomplish the tax calculation task. Keep in mind that the state and subtotal values are inputs into the procedure and the procedure is

Why Use Cursor Variables ? Primarily, you use the cursor variables to pass the query result sets between the PL/SQL stored subprograms and different clients. Neither PL/SQL nor

What Is a Collection The collection is an ordered group of elements, all of similar type (for e.g. the grades for a class of students). Each element has a unique subscript whic

THEORY OF SPONTANEOUS GENERATION - ABIOGENESIS OR AUTOGENESIS - According to this theory, the existing living communities have originated from non-living organic matter with

Use of Table Expressions - Expressing Constraint Conditions With the exception of key constraints, the examples in the theory book all explicitly reference at least one relvar

What are the rates for help in writing PL/SQL procedures and functions?

First Step at defining type SID in SQL CREATE TYPE SID AS ( C VARCHAR(5) ) ; Explanation: TYPE SID announces that a type named SID is being defined to the syst

Selecting Objects: Suppose that you have run the SQL*Plus script below that creates object type Person and object table persons, and that you have settled the table: CREATE

Project Description: I want a database for large governmental and private data sets on one country that will be easily extended to other countries in the future. Also, the datab