What is different bet native dynamic sql and Dbms_Sql?
- 4 Answers
- 15571 Views
- Thermotech, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / gapbridge
In Oracle Database 11g, NDS supports statements larger than 32 KB by accepting a CLOB argument.
| Is This Answer Correct ? | 3 Yes | 0 No |
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.
| Is This Answer Correct ? | 2 Yes | 3 No |
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.
| Is This Answer Correct ? | 0 Yes | 4 No |
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
| Is This Answer Correct ? | 1 Yes | 5 No |
How can we delete duplicate rows in a table?
What is Undo Management Advisor in Oracle?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
What are the system predefined user roles?
What do database buffers contain?
How can we create the complete backup of data in the oracle.
0 Answers IPEC, Satyam, SunTec,
consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?
What is control file used for?
How to import one table back from a dump file?
What are advantages fo Stored Procedures?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
Does oracle database need java?
Oracle General 
