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
1- You can check attribute names from each table in DBF11 by running for example:  desc dbf11.Member;  desc dbf11.Agent;  desc dbf11.Producer; Because some attribute names in

CURRVAL and NEXTVAL The series is a schema object which generates the sequential numbers. Whenever you form a sequence, you can specify its primary value and an increment. T

Pass the nulls to a dynamic SQL: Passing Nulls: Assume that you want to pass the nulls to a dynamic SQL statement. For illustration, you may write the EXECUTE IMMEDIATE

Need Database Development with Analysis Tools Project Description: I want a database for large governmental and private data sets on one country that can be simply extended t

OPEN-FOR Statement The OPEN-FOR statements execute the multi-row query related with a cursor variable. It also allocates the resources used by the Oracle to process the query a

I have a Pascal Source file that needs to be compiled into a Service. In addition, there are various functions (Pascal Procedures I guess) that need to be created to Read and Write

Advantages of Packages The benefits of the Packages are as shown below: Modularity The Packages encapsulate logically associated items, types, and subprograms in the

UPDATE Statement   The UPDATE statement transforms the values of the specified columns in one or more rows in the table or view. Syntax:

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

Use the RETURNING Clause Frequently, the application requires information about the row affected by a SQL operation, for illustration, to produce a report or take a subsequent