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
Cursor Attributes   The Cursors and cursor variables have 4 attributes which give you helpful information about the execution of a data manipulation statement. Syntax:

Using raise_application_error The Package DBMS_STANDARD that is supplied with Oracle gives language facilities that help your application to interact with Oracle. For illustra

Cursors The Oracle uses work areas to execute the SQL statements and to store process information. A PL/SQL construct known as the cursor. Let's you assume name a work area and

MECHANISTI S THEORY-HAECKEL (1866) - Haeckel stating that after each catalysm, some new organism suddenly forms as a chance event in one stride from inanimate matter and sub

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

Use Object Types and Collections The Collection types and object types increase your efficiency by allowing for the realistic data modeling. The Complex real-world entities an

Use the PLS_INTEGER Datatype When you require to declare an integer variable, use the datatype PLS_INTEGER that is the most efficient numeric type. That is as the PLS_INTEGER

At times, Brewbean's has changed the id number for existing products. In the past, they have had to add a new product row with the new id to the BB_PRODUCT table, modify all the co

Role of Abstraction in pl/sql: The abstraction is a high-level description or model of a real-world entity. The Abstractions keep our daily lives convenient. They help us ca

The SQL ‘CREATE TABLE' scripts for all the tables you have implemented. Note that your tables must correspond exactly to the ERD you have provided in 1. above, or you will lose ma