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

Can we use distinct and group by together?

588


What is the difference between the implicit and explicit cursors?

527


How do you concatenate in sql?

552


What is on delete set null?

570


what is a table in a database ? : Sql dba

545






What sql does db2 use?

544


How long it takes to learn pl sql?

533


What is data type in database?

548


What will you get by the cursor attribute sql%notfound?

595


How to read xml file in oracle pl sql?

509


What is output spooling in sql*plus?

553


What is the process of copying data from table a to table b?

601


Why we use triggers in mysql?

560


Which is faster count (*) or count 1?

542


How can you view the errors encountered in a trigger?

552