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
to write a heap sort program usin pl-sql

%FOUND Until the SQL data manipulation statement is executed, the %FOUND yields NULL. Afterward, the %FOUND yields TRUE, when an INSERT, UPDATE, or DELETE statement affected o

What Are Cursor Variables  ? The Cursor variables are like C or Pascal pointers that hold the memory location (address) of some item rather of the item itself. Therefore, decl

Explicit Cursors The set of rows returned by the query can include zero, one, or multiple rows, depending on how many rows meet your search criteria. Whenever a query returns

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

Keyword and Parameter Description: label_name: This is an undeclared identifier which optionally labels the PL/SQL block. When used, label_name should be enclosed by the do

Positional and Named Notation You can write the actual parameters when calling a subprogram, using either positional or named notation. That is, you can point to the relationsh

We are seeking a freelance consultant that is familiar with Appgen applications. We require exporting all our data into a format appropriate for importing into SAP Business One. Pl

Closing a Cursor Variable The CLOSE statement disables the cursor variable. After that, the related result set is undefined. The syntax for the same is as shown below: CLOS

Redeclaring Predefined Exceptions Keep in mind that, the PL/SQL declares predefined exceptions globally in the package STANDARD; Therefore you need not declare them yourself.