Parameter and keyword description - open-for statement, PL-SQL Programming

Parameter and Keyword Description:

cursor_variable_name:

This identifies a cursor variable or the parameter formerly declared within the present scope.

host_cursor_variable_name:

This identifies the cursor variable formerly declared in a 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.

select_statement:

This is a query related with the cursor variable that returns a set of values. The query can reference the bind variables and PL/SQL parameters, variables, and functions but cannot be FOR UPDATE. The syntax of the select_statement is similar to the syntax for the select_into_statement.

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







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

Write discussion on Parameter and keyword description - open-for statement
Your posts are moderated
Related Questions
Committing and Rolling Back The COMMIT and ROLLBACK end the active autonomous transaction but do not exit the autonomous routine. As the figure shows, if one transaction ends,

Effects of NULL Operator As a general rule-but not a universal one-if NULL is an argument to an invocation of a system-defined read-only operator, then NULL is the result of t

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

Pass the nulls to a dynamic SQL: Passing Nulls: Assume that you want to pass the nulls to a dynamic SQL statement. For illustration, you may write the EXECUTE IMMEDIATE

Cause of Indeterminacy in SQL One root cause of indeterminacy in SQL lies in its implementation of comparison for equality. For certain system-defined types it is possible for

Advantages of Subprograms The Subprograms give extensibility; that is, tailor the PL/SQL language to suit your requirements. For illustration, if you require a procedure which

Data Types in SQL - Integer INTEGER or  synonymously INT, for integers within a certain range. SQL additionally has types SMALLINT and BIGINT for certain ranges of integers. T

%TYPE: This attribute gives the datatype of a formerly declared collection, cursor variable, object, field, record, database column, or variable. Datatype: This is simply

Effects of NULL for Multiple Assignments - SQL If the row expression given as the source for a multiple assignment evaluates to NULL, then NULL is assigned to each target. If

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