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
What do you mean by group by clause?
What are the oracle differences between nvl and coalesce
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
What are the most common interview questions on ETL Testing for experience?
How to insert multiple rows with one insert statement in oracle?
What is ASM (Automatic Storage Management) in Oracle?
How to pass parameters to procedures?
How many categories of data types in oracle?
How to rename an existing table?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
what is the scripts in data base?
How many types of synonyms in Oracle?
what is the dual table in oracle?
What is where clause in oracle?
How do I spool to a csv formatted file using sqlplus?