Interested to Buy Any Domain ? << Click Here >> for more details...
What is different bet native dynamic sql and Dbms_Sql?
- 4 Answers
- 16378 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 |
What is COST-based approach to optimization ?
5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.
What is a package in oracle?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
How do I start tns listener?
How to view all columns in an existing table?
What is meant by joins? List out the types of joins.
How to start your 10g xe server from command line?
What is a nvl function? How can it be used?
Difference between varchar and varchar2 data types?
What happens if the imported table already exists?
When a form is invoked with call_form, Does oracle forms issues a save point ?
Oracle General 
