Interested to Buy Any Domain ? << Click Here >> for more details...
What is dynamic SQl and how you will create and execute
dynamic sql?
- 2 Answers
- 7451 Views
- TCS, I also Faced
- E-Mail Answers
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
What is sql injection vulnerability?
Is pl sql useful?
what tools available for managing mysql server? : Sql dba
How do you declare a constant?
What is sql select statement?
What are the advantages of sql? Explain
What are the uses of sysdate and user keywords?
what are the differences among rownum, rank and dense_rank? : Sql dba
What is coalesce sql?
What is the difference between count 1 and count (*) in a sql query?
How do you modify a table in sql?
What is duration in sql profiler trace?
how to convert character strings to numeric values? : Sql dba
How do I upgrade sql?
What are conditional predicates?
