What is different bet native dynamic sql and Dbms_Sql?
- 4 Answers
- 15472 Views
- Thermotech, I also Faced
- E-Mail Answers
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
Please explain joins in oracle?
Explain about functional dependency and its relation with table design?
Explain the difference between replace() and translate() functions in oracle?
What is the order of defining local variables and sub procedures/functions?
What is recycle bin in Oracle?
Explain constraining triggers.
What is a Garbage Collection? and what is full recursive Garbage collection?
What happens to the current transaction if a ddl statement is executed?
Explain the features of oracle?
How to change user password in oracle?
What is oracle database client?
What is a table index in oracle?
How to use "in" parameter properly?
What is hot backup and logical backup?
What is index-organized table in Oracle?
