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 insert autocommit in oracle?

1012

---

How to run create database statement?

972

---

can u plz provide me oca sql dumps please i need them

1900

---

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

1964

---

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5406

---

What are advantages of dateset in datastage?

2197

---

What is BBED in Oracle?

1086

---

How to define an oracle cursor variable?

972

---

What happens to indexes if you drop a table?

1107

---

What is oracle host variable?

978

---

What are the different pseudo commands? Explain in general?

1019

---

What are data pump export and import modes?

1014

---

How to connect to the server with user account: sys?

968

---

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

1952

---

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1843

---