Answer / gapbridge

In Oracle Database 11g, NDS supports statements larger than 32 KB by accepting a CLOB argument.

Answer / amrit paul-genpact

Normally we would write codes using Native Dynamic SQL(NDS).
This is because NDS heps writing clear, understandable code
where trouble shooting is apparently very easy.
However there might be situations when the input to a
EXECUTE IMMEDIATE code might use a SQL Text which is
greater than 32KB, thus over-ruling the max specified size
of PL/SQL VARCHAR2 limits. This is a clear situation where
we could use the DBMS_SQL package.

Answer / s.gousalya

Native Dynamic sql:
Directly we can include sql code into our query or
procedure using EXECUTE IMMEDIATE

DBMS_SQL it offers an API that execute SQL statement
dynamically.

Answer / 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

which statement is running fastly ie insert or delete?

13 Answers   Oracle,

---

Use of an integrity constraint is better to validate data. Explain

1 Answers  

---

How to export data to a csv file?

1 Answers  

---

Why do we use coalesce function in oracle?

1 Answers  

---

cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..

2 Answers  

---

What privilege is needed for a user to query tables in another schema?

1 Answers  

---

How to get execution path reports on query statements?

1 Answers  

---

What is the Tune Query

1 Answers  

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1 Answers  

---

Explain index?

1 Answers  

---

Difference between primary key and unique key ?

77 Answers   Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions,

---

How to create an initialization parameter file?

1 Answers  

---