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
Interesting properties of CROSS JOIN - SQL Compare these with the "interesting properties of JOIN", CROSS JOIN is associative but not commutative. Unlike JOIN and NATURAL JOI

CHECK Constraints in SQL A CHECK constraint is a table constraint defined using the key word CHECK, as already illustrated in several examples in this chapter. In particular,

Defining REF CURSOR Types To make cursor variables, you take 2 steps. At first, you define a REF CURSOR type, and then declare the cursor variables of that type. You can defin

Example of Shorthand for a row constraint Example: Shorthand for a row constraint ALTER TABLE EXAM_MARK ADD CONSTRAINT Mark_in_range CHECK (Mark BETWEEN 0 AND 100);

Controlling Autonomous Transactions The first SQL statement in an autonomous routine starts a transaction. Whenever one transaction ends, the next SQL statement starts the oth

Referencing Records Unlike the elements in a collection, that are accessed using subscripts, the fields in a record are accessed by name. To reference an individual field, you

Example of Null operator - NiNo Rule If we wanted to make HIGHER_OF adhere to "NULL in, NULL out"-let's call it the NiNo rule-we would have to write something like what is sho

Create the four tables and populate them with the given data. Answer the following queries in SQL. 1. Get all part-color/part-city combinations. Note: Here and subsequently, the

Parameter and Keyword Description:   table_reference: This identifies a table or view which should be available when you execute the INSERT statement, and for that you sho

Benefit of the dynamic SQL: This part shows you how to take full benefit of the dynamic SQL and how to keep away from some of the common pitfalls. Passing the Names of Sc