What is dynamic SQl and how you will create and execute
dynamic sql?
Answer Posted / ravi singh
Dynamic SQL enables you to executes your SQL statement at run time on the basis of different conditions. They can be executed with the help of creating SQLs at run time. you can store your where clause or sql statements in variables and on the basis of requirements you can execute them.
Dynamic SQL comprises reference cursors.
for ex: open cursor for select a,b,c from table_name;
execute immediate 'select a,b from table_name'
you can store the result set into variables too.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Are subqueries better than joins?
Whis is not false in primary key?
How does sql developer connect to oracle database?
what is oltp (online transaction processing)? : Sql dba
What company owns postgresql?
Is left join inner or outer?
What is difference between hql and native sql?
What is left join in sql?
How do I remove duplicates in two columns?
What is the usage of distinct keyword?
How do I find sql profiler?
What is sql partition function?
What is auto increment?
Explain the the update statement in sql?
What are the advantages of pl sql over sql?