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
- 7464 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
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
what is a database lock ? : Sql dba
What is sql basics?
What is online transaction processing (oltp)?
What programs use sql?
Explain commit, rollback and savepoint.
What is a native sql query?
What is procedure in pl sql?
How do you delete data from a table?
How many tables can a sql database have?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
what is cursor. write example of it. What are the attributes of cursor.
What is cursor in pl sql?
What are operators available in sql?
Why is partition used in sql?
