What is different bet native dynamic sql and Dbms_Sql?
- 4 Answers
- 14820 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
Give the different types of rollback segments.
How to pass a parameter to a cursor in oracle?
What is the best way to do multi-row insert in oracle?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
what is difference between sql plus and sql*plus? (not sql and sql plus).
How a tablespace is related to data files?
What are the attributes of cursor?
Explain view?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
Can sub procedure/function be called recursively?
What is a cursor in oracle?
How to create an oracle testing table?
Explain about achiever in sql?
What is transaction control statement and how many types of transaction control statement in Oracle?
What happens in oracle commit?
