What is different bet native dynamic sql and Dbms_Sql?
Answer Posted / s.gousalya
Native Dynamic sql:
Directly we can include sql code into our query or
procedure using EXECUTE IMMEDIATE
DBMS_SQL it offers an API that execute SQL statement
dynamically.
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
Why is oracle database so popular?
Explain table?
How to use an explicit cursor without open statements?
Explain the use of Merge statement in oracle 11g
what is insert all statement in sql
What is the difference between sharding and partitioning?
How does one get the view definition of fixed views/tables?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
How to start your 10g xe server from command line?
How to Truncate Table in Oracle
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
How to increment dates by 1 in oracle?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
What are the data types in oracle?
Is there an oracle sql query that aggregates multiple rows into one row?