What is different bet native dynamic sql and Dbms_Sql?
- 4 Answers
- 15520 Views
- Thermotech, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Does oracle charge for java?
What is the disadvantage of User defind function?
What are the different types of failures that occur in Oracle database?
What are the types of trigger in oracle?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How to shutdown your 10g xe server from command line?
What are the different editions of oracle?
How to write a left outer join with the where clause in oracle?
How to define an anonymous block?
What is the difference between "as" and "is" in an oracle stored procedure?
What happens in oracle commit?
How to connect to a local oracle 10g xe server?
What is MTTR advisor in Oracle?
How to enter a new row into a table interactively?
What is backup in Oracle?
