what are Dynamic SQL statements?

Answer Posted / 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.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I run a query in pl sql developer?

721


Explain constraints in sql?

766


What is sql and its types?

813


How do I debug a stored procedure?

811


How do I save the results of sql query in a file?

711






What is an inner join sql?

694


what are the advantages of sql ? : Sql dba

736


What do you understand by pl/sql packages?

766


What is primary key secondary key alternate key candidate key?

759


Is there a way to automate sql execution from the command-line, batch job or shell script?

746


Is sql workbench free?

711


Is sql a scripting language?

690


Which is better join or subquery?

791


Mention what is the plv (pl/vision) package offers?

839


Why are cursors used?

789