Answer / tharanath.n

A SQL statement is dynamic if it is constructed
at runtime and then executed.
we can use ddl commands by dynamic sql, without we can't
use.

Answer / soujanya

A SQL statement is dynamic if it is constructed
at runtime and then executed.

Answer / srikanth

EXECUTE IMMEDIATE

Answer / naresh

Basically Dynamic SQL means, you'll construct a SQL
statement dynamically while runtime and run it.

Why this needed: Since the stored database objects
(Procedures and Functions and others) will be compiled while
creating and stored inside a database.so everything has been
checked already. so whenever you make a call to these
programs they will directly run withou compiling second time.
since it runs without compiling you cannot use DDL commands
inside a stored program.

So to avoid this you can directly mention Execute Immediate
keywords in front of a SQL query dynamically in your
block.so that it'll work this time.

Hope this helps.

Answer / brahmam

-> the combination of Sql and Plsql is called dynamic Sql.
when ever sql statements executed runtime then we are using
Execute immediate clause in executable section of the plsql block.

Answer / thanvi

Both compilation and execution happens at the time.It will be useful where we don't know (the value of col_name or table_name) till runtime.
-Compilation means checks for the syntax.

Answer / tharanath.n

A SQL statement is dynamic if it is constructed
at runtime and then executed.
we can use ddl commands by dynamic sql, without we can't
use.

Answer / vishal kumar

Sql statement should be written in quotes like

'select table1.col1, tabel2.col2 from table1,table2 where
table1.col3=table2.col4'
and we can execute through below command "execute immidiate"
EXECUTE IMMEDIATE 'select table1.col1, tabel2.col2 from
table1,table2 where table1.col3=table2.col4'

it execute at runtime, means its not allowed as static.

Answer / manoj

It take value dynamicaly at run time

Need:- If we need DDL in programming as "CREATE, INSERT"

.. It always written in single
quote " 'sql_statement ' " both end
with termination " ; "

What are the properties of a transaction?

0 Answers  

Is it possible for a table to have more than one foreign key?

0 Answers  

what are the demerits of sql?

1 Answers  

What is pragma in sql?

0 Answers  

Does sql backup shrink transaction log?

0 Answers  

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Suneel Reddy

6 Answers   Target,

when normalization is required

3 Answers   HCL,

Can we rollback truncate?

0 Answers  

Can we create foreign key without primary key?

0 Answers  

Is pl sql better than sql?

0 Answers  

Why is stored procedure faster than query?

0 Answers  

how to insert the data through views? The view is depending upon more than two tables? how to update materalized views?

3 Answers   3i Infotech,