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
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

Declaring Objects: You can use the object types wherever built-in types like CHAR or NUMBER can be used. In the block below, you can declare object r of type Rational. Then, yo

Aggregate Operators SQL Supports all of the aggregate operators mentioned in the theory book and many more besides. The syntax, however, involves an unusual trick that SQL cal

Using the student and faculty tables create a select query that outputs all students for a specific advisor. Generate the execution plan, select out the explain plan . Create an

Effects of NULL for union - SQL The treatment of NULL in invocations of EXCEPT is as for UNION. This is different from its treatment in those of NOT IN and quantified compari

Comparison Operators Usually, you use the comparison operators in the WHERE clause of a data manipulation statement to form the predicates, that compare one expression to anot

a. Create a table odetails_new. It has all the attributes of odetails and an additional column called cost, whose values are the product of the quantity and price of the part bein

Other monadic - SQL In 2VL there are just 4 (2 2 ) monadic operators, of which negation is really the only "useful" one. When a third truth value is introduced we have 27 (3 3

Deleting Objects You can use the DELETE statement to eradicate objects from an object table. To eradicate objects selectively, you use the WHERE clause, as shown below: BEG

%ROWCOUNT The %ROWCOUNT yields the number of rows affected by the INSERT, UPDATE, or DELETE statement, or returned by a SELECT INTO statement. The %ROWCOUNT yields zero when a