Answer Posted / 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 sql*loader and what is it used for? : aql loader

1167

---

What is database sql?

1038

---

How to assign sql query results to pl sql variables?

1067

---

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2488

---

How do I save a stored procedure?

999

---

How to use sql statements in pl/sql?

1111

---

What does select count (*) mean in sql?

1013

---

how would concatenate strings in mysql? : Sql dba

1079

---

define data blocks ? : Sql dba

974

---

What are system versioned tables?

1017

---

What found sql?

938

---

what is auto increment? : Sql dba

1000

---

Write a sql select query that only returns each name only once from a table?

1007

---

what is offset-fetch filter in tsql? : Transact sql

939

---

How to create an array in pl/sql?

1060

---