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.

What is foreign key and example?

0 Answers  

---

Why we use pl sql?

0 Answers  

---

what is a constraint? Tell me about its various levels. : Sql dba

0 Answers  

---

Will truncate release space?

0 Answers  

---

Can we connect to postgresql using sql developer?

0 Answers  

---

Do you understand the meaning of exception handling?

3 Answers  

---

What is pls integer?

0 Answers  

---

Write a sql to print only character form the below string. @So&*CIE%$TE@GEN!@RAL

1 Answers   Societe Generale,

---

Define sql delete statement.

0 Answers  

---

What is Overloading of procedures ?

2 Answers  

---

What is the sql case statement?

0 Answers  

---

Is sql an operating system?

0 Answers  

---