Parameter and keyword description - select into statement, PL-SQL Programming

Parameter and Keyword Description:

select_item:

This select_item is a value returned by the SELECT statement, and then assigned to the equivalent variable or field in the INTO clause.

BULK COLLECT:

The SQL engine is instructed 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 equivalent columns should store the scalar (not the composite) values. 

variable_name:

This identifies a formerly declared scalar variable into which a select_item value is fetched. For each and every select_item value returned by the query, there should be a equivalent, 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 select_item the value returned by the query, there should be a equivalent, type-compatible field in the record.

collection_name:

This identifies a declared collection into which the select_item values are bulk fetched. For each of the select_item, there should be a equivalent, 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 select_item values are bulk fetched. For each of the select_item, there should be an equivalent, type-compatible array in the list. The Host arrays should be prefixed with a colon.

table_reference:

This identifies the table or view that should be accessible when you execute the SELECT statement, and for which you should have SELECT rights.

Subquery:

This is a SELECT statement which provides a set of rows for the processing.

TABLE (subquery2):

The operand of the TABLE is a SELECT statement which returns a single column value, that must be a nested table or a varray cast as a nested table. The Operator TABLE informs the Oracle that the value is a collection, but not a scalar value.

alias:

This is the other (typically short) name for the referenced, table, column or the view.

rest_of_statement:

This is something which can legally follow the FROM clause in the SELECT statement apart from the SAMPLE clause.

Posted Date: 10/8/2012 8:03:21 AM | Location : United States







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

Write discussion on Parameter and keyword description - select into statement
Your posts are moderated
Related Questions
Cursor Variables Similar to a cursor, cursor variable points to the current row in the result set of a multi-row query. But, dissimilar a cursor, a cursor variable can be opene

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

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

Cursors   To execute the multi-row query, the Oracle opens an unnamed work region which stores the processing information. The cursor names the work region, access the informa

Tautology - Equivalences Rules: If there Tautologies are not all the time as much easy to note as the one above so than we can use these truth tables to be definite that a sta

Use External Routines The PL/SQL is particular for the SQL transaction processing. Therefore, several tasks are more quickly completed in a lower-level language like C that is

Operators on Tables and Rows Row Extraction TUPLE FROM r, SQL has row subqueries. These are just like scalar subqueries except that they may specify more than one column.

Initial thought process: Design a script which was simple and user friendly. Integrate procedures/functions to extract data under the hood. I focused on giving the user the opt

Use Bulk Binds If SQL statements execute inside a loop using the collection elements as bind variables, context switching between the PL/SQL & SQL engines can slow down the ex

%TYPE Attribute The %TYPE attribute gives the datatype of a record, field, nested table, database column, or the variable. You can use the %TYPE attribute as the datatype speci