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

Which function is used to return remainder in a division operator in sql?

690


What is use of trigger?

590


What is %type in sql?

606


how to use myisamchk to check or repair myisam tables? : Sql dba

603


What is difference between hql and sql?

594






What is a schema sql?

627


What is a common use of group by in sql?

698


What does the acronym acid stand for in database management?

672


What is the difference between drop and truncate commands?

581


What port does sql server use?

610


What is a recursive stored procedure?

713


Why do you partition data?

631


Where do we use pl sql?

641


What are the different types of tables in sql?

571


Enlist some predefined exceptions?

693