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
Count Operator in SQL Example: Counting the students who have scored more than 50 in some exam (SELECT COUNT (*) FROM (SELECT DISTINCT StudentId FROM EXAM_MARK WHE

SQL outer join SELECT * FROM IS_CALLED NATURAL LEFT JOIN IS_ENROLLED_ON Note that adding LEFT to an invocation of CROSS JOIN has no effect unless the right-hand operand

Use Native Dynamic SQL A few programs (a normal-purpose report writer for illustration) should build and process a variety of SQL statements at run time. Therefore, their full

Tables within a Table - SQL Figure here is an exact copy of the one in the theory book and as before it is just an alternative way of representing some of the information con

Using the Collection Methods The collection methods below help to generalize the code and make collections easier to use and also make your applications easier to maintain:

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

%ROWCOUNT The %ROWCOUNT yields the number of rows affected by the INSERT, UPDATE, or DELETE statement, or returned by a SELECT INTO statement. The %ROWCOUNT yields zero when a

Defining and Declaring Collections To create the collections, you must define a collection type, and then declare the collections of that type. You can define the VARRAY types a

Using Operator REF: You can retrieve refs by using the operator REF that, like VALUE, takes as its argument a correlation variable. In the illustration below, you retrieve one

Character Types The Character types allow you to store alphanumeric data, represent words and text, and manipulate the character strings. CHAR You use the CHAR dataty