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 Referential Integrity?

3 Answers  

---

What is sp_helptext?

0 Answers  

---

What is sql partition?

0 Answers  

---

What is sqlerrd?

0 Answers  

---

Is sql the best database?

0 Answers  

---

What is difference between rank () row_number () and dense_rank () in sql?

0 Answers  

---

What is sql*loader and what is it used for? : aql loader

0 Answers  

---

what is difference between stored procedures and application procedures,stored function and application function?

1 Answers  

---

which tcp/ip port does sql server run on? : Sql dba

0 Answers  

---

Can function return multiple values in sql?

0 Answers  

---

Whate is use of MOD function in pl/sql.

3 Answers   Oracle,

---

Can a foreign key have a different name?

0 Answers  

---