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
Semidifference and NOT - SQL In this section first describe the relational difference operator, named MINUS. Example here shows SQL's closest counterpart of that operator.

I want to implement heap sort algorithm in pl sql please share the source code for guidance

DELETE Command - SQL Loosely speaking, DELETE removes some existing rows from its target table. Suppose the university decides that course C3 is to be withdrawn. Example shows

Understanding Varrays The Items of type VARRAY are termed as the varrays. They permit you to relate a single identifier with the whole collection. This relationship lets you man

Example of Foreign Key Constraint Example: Alternative formulation for 6.3 as a foreign key constraint ALTER TABLE EXAM_MARK ADD CONSTRAINT Must_be_enrolled_to_take_exam

Understanding Nested Tables Within the database, the nested tables can be considered as one-column database tables. The Oracle stores the rows of a nested table in no specific o

The Package Body The package specification is implemented by the package body. That is, the package body has the definition of every cursor and the subprogram declared in the p

Tautologies: Above given table allows us to read the truth of the connectives in the next manner. Just expect we are looking at row three. It means this says that, if there P

Natural Join - SQL In the absence of NATURAL JOIN Example has to be replaced by something rather more longwinded, as shown in Example. Example: Joining IS_CALLED and IS_EN

Example of Check Constraints Example: Workaround for when subqueries not permitted in CHECK constraints CREATE FUNCTION NO_MORE_THAN_20000_ENROLMENTS ( ) RETURNS BOOLEAN