Answer / 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'

Answer / 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.

How is debugging done?

0 Answers  

---

What is nested table in pl sql?

0 Answers  

---

What is the difference between the implicit and explicit cursors?

0 Answers  

---

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

0 Answers  

---

What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?

9 Answers   Oracle,

---

what are different types of keys in sql?

0 Answers  

---

How do I copy a table in sql?

0 Answers  

---

What are the three pl sql block types?

0 Answers  

---

What is java sql connection?

0 Answers  

---

What is the difference between alter trigger and drop trigger statements?

0 Answers  

---

Which is better join or inner query?

0 Answers  

---

how to calculate expressions with sql statements? : Sql dba

0 Answers  

---