how to get a list of all tables in a database? : Sql dba

0 Answers  

---

What is a merge query?

1 Answers  

---

what is sql in mysql? : Sql dba

0 Answers  

---

I have one table,in that table (1)i have java1.1 version books are 2 and java1.5 version books are 4. (2).Net2.0 books are 3, .Net3.5 books are 2 (3)ABC1.6 books are 4, ABC2.0 books are 3. Now i want output is like Book Count Java 6 .Net 5 ABC 7 For this i need sql query, please help me if anyone how to get this result. Thanks, Seenu

4 Answers   Adea,

---

table :- city name country code abc 11 bcd 22 cde 232 def 33 write a procedure , so that when we give a phone no. eg - 1123456789 - o/p sud be city name = abc if phone no. - 2322345897 , o/p sud be =cde note - bcd and cde city name sud be diff. as dey diff only with th last no. Pls ans. this questnion.

1 Answers  

---

---

what are all different types of collation sensitivity? : Sql dba

0 Answers  

---

What is the difference between instead of trigger and after trigger?

0 Answers  

---

Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?

4 Answers   IBM, Metric Stream,

---

What is the primary use of normalization?

0 Answers  

---

What is the usage of NVL?

7 Answers   Infosys, Micro Infotek,

---

Is sqlite free?

0 Answers  

---

What does select count (*) mean in sql?

0 Answers  

---