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
What is rowid and rownum in oracle?
What are the four Oracle system processes that must always be up and running for the database to be useable?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
What is meant by raw datatype?
What is a table in oracle?
How to best split csv strings in oracle 9i?
various types of hints and their usage
What is merge statement used for?
Why do you create or replace procedures rather that drop and recreate.
What is ADDM Advisor in Oracle?
How to convert character types to numeric types?
How to drop a stored procedure in oracle?
Explain the use of ignore option in imp command.
What are the ways tablespaces can be managed and how do they differ?
What are the different types of synonyms?