difference between oracle 8i and oracle 9i

8 Answers  

---

Why we use triggers in mysql?

0 Answers  

---

Can we perform dml in function?

0 Answers  

---

Is postgresql a nosql database?

0 Answers  

---

How do you declare a user-defined exception?

0 Answers  

---

---

Create a procedure to delete certain records from a table and display the total number of records deleted in this process. (Condition for deletion can be of ur choice, for instance delete all records where eid='')

2 Answers  

---

What is the difference between left join and right join?

0 Answers  

---

Can %notfound return null after a fetch?

0 Answers  

---

I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.

7 Answers   MTS,

---

How long will it take to learn pl sql?

0 Answers  

---

In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop

4 Answers   JDA,

---

What are analytic functions in sql?

0 Answers  

---