Answer Posted / thirupathi.l

using native dynamic sql we can directly use DML and DDL
statements.
ex:native dynamic sql
declare
a varchar2(1000);
begin
a:='create table <tname>(elements)
execute immediate a;
end;

where as in dbms_sql package also we can use dml and DDL
but here declare cursor
coding is so lenthy
thats why currently using native dynamic sql

What are operators in oracle?

1101

---

How many types of synonyms in Oracle?

1175

---

Why do we use coalesce function in oracle?

1164

---

What is an oracle transaction?

1228

---

How to rollback the current transaction in oracle?

1104

---

What is an Oracle Instance?

1162

---

What is the difference between pre-select and pre-query?

1299

---

Explain the characteristics of oracle dba?

1175

---

What is oracle server autotrace in oracle?

1220

---

What are the various constraints used in oracle?

1093

---

How to turn on or off recycle bin for the instance?

1123

---

How to call a sub procedure?

1147

---

How to define a record variable to store a table row?

1111

---

What privilege is needed for a user to create tables in oracle?

990

---

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5476

---