What is different bet native dynamic sql and Dbms_Sql?
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
Name the three major set of files on disk that compose a database in Oracle?
What is an oracle table?
How to resolve name conflicts between variables and columns?
Explain the truncate in oracle?
What is data block in Oracle?
How to define an oracle sub procedure?
What is enter substitution variable in oracle?
What is oracle data type?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
How can we view last record added to a table?
Can we convert a date to char in oracle and if so, what would be the syntax?
How to download oracle database 10g xe?
Is there a combination of "like" and "in" in sql?
How to find out what oracle odbc drivers are installed?
What is oracle latest version?