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
Effects of NULL in Table Literal When a VALUES expression appears as the source value for an SQL INSERT statement, the key word NULL can appear as a field value, such that for


Problem: (a) Define the following terms: (i) data mining. (ii) OLAP. (b) Differentiate between snowflake schema and star schema. Support your answer with appropriate

Project Description: I have two types of data sources. One that is a list in SharePoint and another that is an access desktop database. The access desktop database is fairly com

Using Operator DEREF: You cannot navigate through refs within the PL/SQL procedural statements. Rather than, you should use the operator DEREF in the SQL statement. The DEREF

Remote Operations: As the illustration shows below, the PL/SQL subprograms can execute the dynamic SQL statements which refer to the objects on a remote database: PROCEDURE

Exceptions An exception is the runtime error or warning condition that can be predefined or user-defined. The Predefined exceptions are raised implicitly through runtime system

Write a stored procedure that accepts the post code in which the customer resides as the input parameter. The procedure should then use an explicit cursor to display comprehensive

Logical Connectives - SQL SQL's extended truth tables in which the symbol, for unknown, appears along with the usual T and F. Negation (NOT, ¬) Conjunction (

Advantages of Wrapping   The PL/SQL Wrapper convert the PL/SQL source code into a transitional form of the object code. By hiding the application internals, the Wrapper secure