Name the tables where characteristics of Package, procedure and functions are stored ?

3 Answers  

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

0 Answers   CTS,

---

Why do we use set serveroutput on?

0 Answers  

---

How is Oracle 10g helpful when compared to oracle 9i and what is grid computing

1 Answers   Flextronics,

---

What is sql injection vulnerability?

0 Answers  

---

---

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

4 Answers   CGI, IBM,

---

what is explain plan?

4 Answers  

---

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

0 Answers  

---

write sub query for eliminating duplicate rows using analytical function?

3 Answers   Metric Stream,

---

Why query optimization is needed?

0 Answers  

---

need to split a string into seperate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,b,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

1 Answers  

---

What is pl sql and why it is used for?

0 Answers  

---