Interested to Buy Any Domain ? << Click Here >> for more details...
What is different bet native dynamic sql and Dbms_Sql?
- 4 Answers
- 16349 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
How would you go about verifying the network name that the local_listener is currently using?
Explain what are clusters?
What is the order of defining local variables and sub procedures/functions?
How do I spool to a csv formatted file using sqlplus?
Why do we need integrity constraints in a database?
How to enter a new row into a table interactively?
Which is better Oracle or MS SQL? Why?
How to get execution path reports on query statements?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
How do you store pictures in a database?
How to use null as conditions in oracle?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
How to get the Installed Oracle Version Information ?
How to view all columns in an existing table?
Explain the use of rows option in imp command.
