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
Use of Table Expressions - Expressing Constraint Conditions With the exception of key constraints, the examples in the theory book all explicitly reference at least one relvar

The SQL ‘CREATE TABLE' scripts for all the tables you have implemented. Note that your tables must correspond exactly to the ERD you have provided in 1. above, or you will lose ma

UNION without CORRESPONDING - SQL The use of UNION without CORRESPONDING. Example is merely by omitting CORRESPONDING, but only because the operands have identical SELECT clau

Parameter & Keyword Description: function_name: The user-defined function is identifying by that keyword. parameter_name: This identifies the formal parameter that

Stored Subprograms Normally, tools (like Oracle Forms) which incorporate the PL/SQL engine can store subprograms locally for later, strictly local execution. Though, to become

OPEN-FOR Statement The OPEN-FOR statements execute the multi-row query related with a cursor variable. It also allocates the resources used by the Oracle to process the query a

Indeterminacy in SQL Some SQL expressions are actually not function invocations at all in the mathematical sense, being indeterminate-invocations operating on identical input

I need SQL to infopath data connection Project Description: Want data retrieval connection from SQL to SharePoint infopath Skills required are Sharepoint, SQL

LAWS / RULES - Dollo's Law                     :           Living organisms do exhibit evolutionary irreversibility or evolution is irreversible. Williston's Law

Scope Rules You cannot declare an exception twice in the similar block. Though, you can, declare the similar exception in 2 different blocks. The Exceptions declared in a bloc