what are Dynamic SQL statements?

Answer Posted / 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 " ; "

Is This Answer Correct ?    1 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are character functions in sql?

663


Which table is left in left join?

714


what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

862


How to run pl/sql statements in sql*plus?

756


How can you view the errors encountered in a trigger?

732






Is inner join same as self join?

783


How many types of triggers are there in pl sql?

777


Why use stored procedures?

771


How sql query is executed?

782


what is data integrity? : Sql dba

775


what is the difference between nested subquery and correlated subquery?

743


What is secondary key?

669


How do I remove sql plus from windows 10?

765


What is Histogram?

1273


What is a native sql query?

700