Interested to Buy Any Domain ? << Click Here >> for more details...
What is different bet native dynamic sql and Dbms_Sql?
- 4 Answers
- 16751 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
Can group functions be mixed with non-group selection fields?
What is bulk collect in oracle?
please explain.. DB architecture ...
What is the exact use of Collections?
Explain a data segment?
What is a snapshot in oracle database?
What is the implicit cursor in oracle?
How to set up autotrace for a user account?
What is instant client oracle?
What is redo log?
Explain about the analyze command in oracle?
what is insert all statement in sql
Explain about achiever in sql?
How to connect asp pages to oracle servers?
What is difference between sid and service name in oracle?
