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,

---

what are the different functions in sorting an array? : Sql dba

0 Answers  

---

What is trigger and how to use it in sql?

0 Answers  

---

When you have to use a default "rollback to" savepoint of plvlog?

0 Answers  

---

What are tables and fields?

0 Answers  

---

What is the basic structure of an sql?

0 Answers  

---

package specification-3 procedures package body-4 procedures how can i write for other procedure in package body

2 Answers   Reliance,

---

What is the difference between Union and Union all. Which is faster.

0 Answers  

---

what is Hash join?how it is different from inner join?what is the sign used for inner join?(eg: like the (+) sign used for outer join)?

3 Answers   TCS,

---

What is %type in sql?

0 Answers  

---

how do you know if your mysql server is alive? : Sql dba

0 Answers  

---

i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75

12 Answers   IBM,

---