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 do you update f as m and m as f from the below table testtable?

0 Answers  

---

How do I create an index in word?

0 Answers  

---

Is full outer join same as cross join?

0 Answers  

---

What is correlated sub-query?

7 Answers   Oracle,

---

in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out

4 Answers  

---

How to return multiple rows from the stored procedure?

0 Answers  

---

Do prepared statements prevent sql injection?

0 Answers  

---

Why we use cross join?

0 Answers  

---

can we call a procedure from a function?

9 Answers   Mind Tree,

---

Does truncate table reset auto increment?

0 Answers  

---

what is purge command explain about oracle performance tuning

2 Answers   Accenture, eCentric Solutions,

---

how to check the 3rd max salary from an employee table?

23 Answers   IBM,

---