Interested to Buy Any Domain ? << Click Here >> for more details...
What is different bet native dynamic sql and Dbms_Sql?
- 4 Answers
- 16570 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
How to get maxsal , minsal, ename department wise in single query
How to bring a tablespace online?
how to do daily transactions with out sql* loader control file regesterd in apps?
How to create a new view in oracle?
Explain the use of record option in exp command.
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
What is a nvl function?
How to view the data files in the current database?
Explain the use of record length option in exp command.
How to see the table columns used in an index?
How to write date and time interval literals in oracle?
Which are the five query types available in oracle?
What is a data lock in oracle?
Difference between oracle's plus (+) notation and ansi join notation?
What are operators in oracle?
