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
- 7311 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 an alias command?
What is difference between my sql and sql?
Can I join the same table twice?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
What is sql integrity?
How do I run a sql query in pgadmin 4?
What are inbuilt functions in sql?
Explain the difference between 'between' & 'and' operators in sql
What are the dml statements?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
Is the primary key an index?
What do you understand by pl/sql packages?
Explain what is a field in a database and record in a database?
What are the types of optimization?
