What is rank function in sql?

0 Answers  

---

Can you have multiple SPs with the same name on a database?

6 Answers   CGI,

---

What is the difference between sql/pl-sql/embeded sql?

3 Answers  

---

How to run pl/sql statements in sql*plus?

0 Answers  

---

What is case function?

0 Answers  

---

How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?

4 Answers   Fidelity, KCP,

---

What's the difference between inner join and left join?

0 Answers  

---

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 Answers   IBM,

---

What is the basic difference between a sql and stored procedure ?

2 Answers   L&T,

---

What is the difference between the sql*loader and import utilities? : aql loader

0 Answers  

---

What is materialised View?

2 Answers   IBM,

---

What is Referential Integrity?

3 Answers  

---