Interested to Buy Any Domain ? << Click Here >> for more details...
What is different bet native dynamic sql and Dbms_Sql?
- 4 Answers
- 16578 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
What is sharded cluster?
How to create tables for odbc connection testing?
What is set verify off in oracle?
How to set a transaction to be read only in oracle?
Explain the use of owner option in exp command.
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
What is rowid and rownum in oracle?
What are the logical operations?
What is the data type of dual table?
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
How to work with data objects interactively?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
How to estimate disk space needed for an export job?
Explain oracle’s server parameter file.
What are joins, explain all types of joins?
