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
How to retrieve data from an explicit cursor?
What privilege is needed for a user to insert rows to tables in another schema?
How to create a new user account in oracle?
What is different types of joins?
Explain compound trigger in oracle?
What is a server parameter file in oracle?
What is query image?
What is an oracle user account?
What is the use of oracle?
What is recycle bin in Oracle?
How to recover a dropped table in oracle?
Explain the use of rows option in imp command.
What is a tns service name?
How to write numeric literals in oracle?
what is the difference between substr and instr function in oracle?