What is the difference between view and stored procedure?

0 Answers  

---

i have xml source. xml source having lacks of records. i want extract/retrive xml source data using sql query. please tell me how to write query.

4 Answers   TCS,

---

How does pl sql work?

0 Answers  

---

What is the difference between rollback and rollback to statements?

0 Answers  

---

What is a merge query?

1 Answers  

---

---

How to get unique records from a table?

0 Answers  

---

Can we use delete in merge statement?

0 Answers  

---

Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.

3 Answers   JPMorgan Chase,

---

What is Collation Sensitivity ? What are the various type ?

0 Answers  

---

What is the purpose of design view?

0 Answers  

---

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

2 Answers  

---

what is the difference difference between procedure and packages

2 Answers   3i Infotech, Oracle,

---