How many tables can you join in sql?

0 Answers  

---

What is the basic form of sql query?

0 Answers  

---

What are the popular database management systems in the it industry?

0 Answers  

---

how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

11 Answers   Satyam,

---

What is range partitioning?

0 Answers  

---

I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.

7 Answers   MTS,

---

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

0 Answers  

---

What is the difference between having clause and where clause?

0 Answers  

---

What are stuff and replace function?

0 Answers  

---

How will we see framework of a table?

2 Answers   Accenture,

---

Explain Connect by Prior?

2 Answers  

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

0 Answers  

---