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

Is a rollback possible to any savepoint?

1091

---

How to commit the current transaction in oracle?

1107

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4517

---

What is a procedure in oracle?

1176

---

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2281

---

Explain a private synonyms?

1028

---

What is the difference between PFILE and SPFILE in Oracle?

1054

---

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1080

---

how can we store any pdf file in oracle

2158

---

How oracle handles dead locks?

1064

---

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1014

---

How do you tell what your machine name is and what is its IP address?

2088

---

How to resolve the ORA-39133 error in Oracle?

1104

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2124

---

What is a subquery?

1115

---