Which is better join or subquery?

0 Answers  

---

Question: Below is the table city gender name delhi male a delhi female b mumbai male c mumbai female d delhi male e I want the o/p as follows: male female delhi 2 1 mumbai 1 1 Please help me in writing the query that can yield the o/p mentioned above?

2 Answers  

---

How to disable a trigger name update_salary?

0 Answers  

---

How to order siblings in oracle hierarchy queries?

0 Answers  

---

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

0 Answers  

---

---

Where do we use pl sql?

0 Answers  

---

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 is sql entity?

0 Answers  

---

when a procedure /package is getting invalidated?

4 Answers   TCS,

---

What is secondary key?

0 Answers  

---

how instead of triger is helpful for mutating tables errors handlling ?

2 Answers   Oracle,

---

What is pl sql block in dbms?

0 Answers  

---