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
Read-Only Operator (+) - SQL The term read-only operator to the mathematical term function. Here I just need to add that the SQL standard reserves the term function for read-

Table Comparison - SQL The following definitions for relation comparisons: Let r1 and r2 be relations having the same heading. Then: r1 ⊆ r2 is true if every tuple of r1

How do I display usernames for students from a student table, assigning each student a username initials001 (initials is the actual student initials), and if the students initials

Need Azure CRM Web Application with two-factor authentication We presently have a CRM-like database stored on MS Azure that we presently access over an MS Access application. It

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

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

Question 1 . Compare SQL and PL/SQL Question 2 . Write a database trigger to implement the following check condition                          Given the following table

Relational Operators and Logical Operators It prepares the ground for subsequent sections in which each specific relational operator is paired with its logical counterpart, su

Row Counterparts of Table Operators SQL does not have counterparts tuple rename, tuple projection, tuple extension, tuple join and tuple compose. To obtain the same effects as

Parameter Aliasing   To optimize the subprogram call, the PL/SQL compiler can decide between the two techniques of the parameter passing. With the by-value techniques, the v