what is the difference between pragma exception_init and raise_application_error

1 Answers   Aetins, State Street,

---

Why do we go for stored procedures?

0 Answers  

---

Explain the insert into statements in sql?

0 Answers  

---

.  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. CUST         ACC a            dv b            fg b            bh c            mk c            cl c            so result:- A  B   c dv fg mk    bh cl       so

3 Answers  

---

How do you use join?

0 Answers  

---

What are instead of triggers?

0 Answers  

---

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?

13 Answers   Cap Gemini, TCS,

---

How do you select unique values in sql?

0 Answers  

---

Why we use stored procedure instead of query?

0 Answers  

---

What is clustered, non-clustured and unique index. How many indexes can be created on a table ?

3 Answers   TCS,

---

What is dba in sql? : SQL DBA

0 Answers  

---

in a package one procedure is wrong package shows valid or not

4 Answers  

---