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
Parameter and Keyword Description: select_item: This select_item is a value returned by the SELECT statement, and then assigned to the equivalent variable or field in the

Some Varray Examples In SQL Plus, assume that you define an object type Project, as described below: SQL> CREATE TYPE Project AS OBJECT ( 2 project_no NUMBER(2), 3 title VARCHA

Controlling Autonomous Transactions The first SQL statement in an autonomous routine starts a transaction. Whenever one transaction ends, the next SQL statement starts the oth

write the program for traffic control system with 10 second, 15 secod, and 20 second delay

Manipulating Objects: You can use an object type in the CREATE TABLE statement to indicate the datatype of a column. When the table is created once, you can use the SQL statem

Parameter and Keyword Description: SQL: This SQL is the name of the implicit SQL cursor. %FOUND: This attribute results TRUE if an INSERT, DELETE, or UPDATE state

COMMIT Statement The COMMIT statement explicitly makes everlasting changes to the database during the present transaction. The Changes made to the database are not considered e

Aggregate Assignment The %ROWTYPE declaration cannot include an initialization clause. Though, there are two ways to assign values to all fields in a record at once. At First, t

Explicit Cursor Attributes The cursor variable or each cursor has four attributes: %FOUND, %ISOPEN, %ROWCOUNT, and %NOTFOUND. When appended to the cursor or cursor variable, th

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