Parameter & keyword description-execute immediate statement, PL-SQL Programming

Parameter and Keyword Description:

dynamic_string:

This is a string variable, literal, or expression which represents a SQL statement or the PL/SQL block.

define_variable_name:

This identifies a variable which stores a SELECTED column value.

record_name:

This identifies a user-defined or %ROWTYPE record which stores a SELECTED row.

bind_argument_name:

These identify an expression whose value is passed to the PL/SQL block or dynamic SQL statement.

INTO ...:

This clause, useful only for specifies the variables record, or single-row queries into which the column values are fetched.

USING ...:

This clause specifies the list of bind arguments. If you do not specify the parameter mode, it default to IN. At run time, a few bind arguments in the USING clause substitute the corresponding placeholders in the PL/SQL block or SQL statement.

Posted Date: 10/8/2012 6:18:30 AM | Location : United States







Related Discussions:- Parameter & keyword description-execute immediate statement, Assignment Help, Ask Question on Parameter & keyword description-execute immediate statement, Get Answer, Expert's Help, Parameter & keyword description-execute immediate statement Discussions

Write discussion on Parameter & keyword description-execute immediate statement
Your posts are moderated
Related Questions
Effect of Anonymous Columns Now, recall that a VALUES expression denotes a table with undefined column names. If an initial value is to be specified when a base table is creat

Closest Approximation to Relational Union - SQL Actually, just as SQL has several varieties of JOIN, it also has several varieties of UNION, none of which is equivalent to th

Declaring and Initializing Objects: An object type is once defined and installed in the schema; you can use it to declare the objects in any PL/SQL, subprogram, block or packa

Iterative Control: LOOP  Statements The LOOP statement executes a series of statements multiple times. There are 3 forms of LOOP statements: LOOP, WHILE-LOOP, & FOR-LOOP. LOOP

Literals A literal is an explicit numeric, string, character, or Boolean value not represented by an identifier. Numeric literal 147 and the Boolean literal FALSE are some of

Using Cursor Attributes To process the SQL data manipulation statements, the SQL engine must opens an implicit cursor named SQL. This cursor's attributes (%FOUND, %NOTFOUND, %

Recursion versus Iteration Dissimilar the iteration, recursion is not crucial to PL/SQL programming. Any problem which can be solved using recursion can be solving using the it

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

Defining and Declaring Records To create records, you have to define a RECORD type, and then declare records of that type. You may also define RECORD types in the declarative

Keyword and Parameter Description select_statement: This is a query which returns a result set of the rows. Its syntax is such that of select_ into_statement without the IN