Interested to Buy Any Domain ? << Click Here >> for more details...
What is different bet native dynamic sql and Dbms_Sql?
- 4 Answers
- 16576 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
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
How to count groups returned with the group by clause in oracle?
20. Using a set operator, display the client number of all clients who have never placed an order.
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
What are operators in oracle?
How does the on-delete-cascade statement work?
How would you best determine why your MVIEW couldnt FAST REFRESH?
How to list all user accounts in oracle?
What is materialized view in Oracle?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
What is different types of joins?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
How to pass parameters to procedures in oracle?
Please explain oracle data types with examples?
