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 the different types of modules in oracle forms?

741

---

What happens if the update subquery returns multiple rows?

797

---

6. Display the client name and order date for all orders using the traditional method.

1997

---

How to convert csv to table in oracle?

716

---

How to write date and time literals in oracle?

734

---

Explain the use of analyse option in exp command.

770

---

Explain a private synonyms?

817

---

How do I manually create a database in oracle?

735

---

Are truncate and delete commands same? If so why?

825

---

How to assign a table row to a record variable?

760

---

What is dynamic proxy?

754

---

what are bitmap indexes? How does they work?

1945

---

Explain an index segment?

829

---

What is a sub query and what are the different types of subqueries?

860

---

What is an oracle tablespace?

777

---