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
heap sort program in pl/sql

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,

SQL outer join SELECT * FROM IS_CALLED NATURAL LEFT JOIN IS_ENROLLED_ON Note that adding LEFT to an invocation of CROSS JOIN has no effect unless the right-hand operand

In Packages The Forward declarations also group logically related subprograms in the package. The subprogram specifications go in the package specification, & the subprogram b

Need Windows and Linux system Administrator We are seeking a part time system administrator to take care of our servers. Your things to do would add, but not limited to: -

Cursor Attributes   The Cursors and cursor variables have 4 attributes which give you helpful information about the execution of a data manipulation statement. Syntax:

Using EXTEND To enlarge the size of a collection, use EXTEND. This process has 3 forms. The EXTEND appends one null element to a collection. And the EXTEND(n) appends n null e

Order of Evaluation When you do not use the parentheses to specify the order of evaluation, the operator precedence determine the order. Now compare the expressions below: NOT

Using COUNT The COUNT returns the number of elements that a collection presently contains. For instance, when a varray projects contains 15 elements, then the following IF con

How Calls Are Resolved? The figure shows that how the PL/SQL compiler resolves the subprogram calls. When the compiler encounters the procedure or function call, it tries to di