What is Pragma EXECPTION_INIT ? Explain the usage ?

2 Answers  

---

How do you delete data from a table?

0 Answers  

---

How well can multiple sessions access the same data simultaneously ?

1 Answers   Oracle,

---

What is difference between select statement and cursor

3 Answers   JDA,

---

Are null values same as that of zero or a blank space?

0 Answers  

---

---

can we write stored function in out parameters? how to call through select statement? how to written more than one value plz give the exmple?

1 Answers  

---

What is a nested table in word?

0 Answers  

---

How to rename a column in the output of sql query?

0 Answers  

---

in sql table follw columns r their vehicle_no|servicetype|date|location| 1234 |1FS |1-JAN|PUNE| 4561 |2FS |5-JAN|PUNE| 1234 |PS |7-JAN|PUNE| 1234 |PS |15-JAN|MUMB| i want o/p below vehicleno|1fs|1fsdate|1fslocation|1ps|1PSDATE|1PSLOC|2PS|2PS DATE|2PSLOCA e.g 1234|1FS|1JAN|PUNE|1PS|7JAN|PUNE|2PS|15JAN|MUMBAI PLS help me out to execute using sql query

1 Answers  

---

1.when will you use week refcursor and when will you use strong ref cursor ? 2.what is the use of sql trace..how do you use it ? 3.can you please send all the sql plus commands...like set line 6000....

1 Answers   Satyam,

---

explain the advantages and disadvantages of stored procedure? : Sql dba

0 Answers  

---

How does rowid help in running a query faster?

0 Answers  

---