Execute immediate statement - syntax, PL-SQL Programming

EXECUTE IMMEDIATE Statement 

The EXECUTE IMMEDIATE statement prepare (parses) and instantly executes a dynamic SQL statement or an anonymous PL/SQL block.

Syntax:

736_execute statement syntax.png

Posted Date: 10/8/2012 6:16:48 AM | Location : United States







Related Discussions:- Execute immediate statement - syntax, Assignment Help, Ask Question on Execute immediate statement - syntax, Get Answer, Expert's Help, Execute immediate statement - syntax Discussions

Write discussion on Execute immediate statement - syntax
Your posts are moderated
Related Questions
i NEED THE QURIES TO SOME OF THE PROBLEMS USING plsql

#quesWrite a cursor to open an employee database and fetch the employee record whose age is greater than 45.tion..

Semijoin and Composition - SQL For semijoin, the dyadic relational operator MATCHING, defined thus: r1 MATCHING r2, where r1 and r2 are relations such that r1 JOIN r2 is de

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

Package Specification The package specifications contain the public declarations. The scopes of these declarations are local to your database representation and global to the

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

Using SET TRANSACTION You use the SET TRANSACTION statement to begin the read-only or read-write transaction, start an isolation level, or assign your present transaction to a

Exceptions An exception is the runtime error or warning condition that can be predefined or user-defined. The Predefined exceptions are raised implicitly through runtime system

Transactions in SQL BEGIN TRANSACTION, COMMIT, and ROLLBACK, SQL has the same syntax except for START in place of BEGIN. However, START TRANSACTION is used only for outermost

Keyword & Parameter Description: PRAGMA: These keywords signify that the statement is a pragma (i.e. compiler directive). The Pragmas are processed at the compile time, n