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 do I manually create a database in oracle?
Explain a private synonyms?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
What is a package ? What are the advantages of package ?
How to join two tables in a single query using oracle?
What is the quickest way to fetch the data from a table?
How to rebuild an index in oracle?
What is oracle join syntax?
Is oracle an operator?
Difference between inner join vs where ?
What is define in oracle?
What are the advantages of oracle?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
What is a snapshot log?
Why do we need oracle client?