What is different bet native dynamic sql and Dbms_Sql?
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 |
difference between procedures and function?
query optmization techniques and quwry analyser+projects+ppts
What are the components of logical database structure in oracle database?
What is a Data Dictionary ?
I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it
How to enter a new row into a table interactively?
write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"
how to create a new database in oracle?
I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?
how to we delete a row using varray
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.