What is dynamic SQl and how you will create and execute
dynamic sql?
Answer Posted / raksha
Dynamic SQL enables you to write programs that reference SQL statements whose full text is not known until runtime.
Below is the way to execute dynamic sql
EXECUTE IMMEDIATE 'SELECT d.id, e.name FROM dept_new d, TABLE(d.emps) e -- not allowed in static SQL
-- in PL/SQL
WHERE e.id = 1'
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Advantages and disadvantages of stored procedure?
Why do you partition data?
What happens when a trigger is associated to a view?
How to check if a column is nullable before setting to nullable?
what happens if you no create privilege in a database? : Sql dba
Is oracle sql free?
Why commit is not used in triggers?
Why left join is used in sql?
How we can update the view?
What is the purpose of cursors in pl/sql?
how to get a list of columns in an existing table? : Sql dba
What is database white box testing and black box testing?
how tsql statements can be written and submitted to the database engine? : Transact sql
what is a constraint? : Sql dba
Show code of a cursor for loop.