ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.

1 Answers   Zensar,

---

in procedure how to return a value

3 Answers   Wipro,

---

What are sql procedures?

0 Answers  

---

wirte a query to filter improper date format follwing table? date 20-apr 22-may-2010 26-jun-2010 feb-2009 i want the output date 22-may-2010 26-jun-2010

6 Answers   Accenture,

---

query to retrive the employees whose sal is greater than avg sal

10 Answers   TCS,

---

---

What is java sql package?

0 Answers  

---

how a reference cursor works?what all adnvantages are gained with it..specify the situation?

4 Answers   TCS,

---

Does view store data in sql?

0 Answers  

---

Can we use having without group by in sql?

0 Answers  

---

Is keyword pl sql?

0 Answers  

---

What is cte?

0 Answers  

---

i declare 4 procedure in package specification but in package body i write only 3 procedure. is it complie??//w

4 Answers   Scope International,

---