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

Can a parameter be passed to a cursor?

1059

---

How to create an initialization parameter file?

990

---

How to loop through data rows in the implicit cursor?

1021

---

Give the constructs of a package, function or a procedure.

990

---

How to create a new table in oracle?

1078

---

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1017

---

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2211

---

What are advantages of dateset in datastage?

2208

---

How a database is related to tablespaces?

989

---

What are the benefits of ordbms?

1030

---

How much memory your 10g xe server is using?

1058

---

What is a relational database management system?

1069

---

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2266

---

How to invoke the data pump export utility?

1123

---

What are joins, explain all types of joins?

2227

---