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 implicit cursor in pl sql?

0 Answers  

---

HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP

1 Answers   TCS,

---

How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? 1. With commas (SET price = 0, status = 'I') 2. With parentheses (SET (price = 0) (status = 'I')) 3. With double-pipes (SET price = 0 || status = 'I') 4. With square-brackets (SET [price = 0] [status = 'I'] 5. With single or multiple spaces (SET price = 0 status = 'I')

2 Answers  

---

is it necessary to write group by and order by clause together

3 Answers   HCL, Wipro,

---

How can you fetch first 5 characters of the string?

0 Answers  

---

How do I remove sql developer from windows 10?

0 Answers  

---

write the Sql query for creating database backup?

7 Answers   TCS,

---

can i give user defined exception in a package

2 Answers  

---

How do I run sql?

0 Answers  

---

What does a pl/sql package consist of?

0 Answers  

---

Is hadoop a nosql?

0 Answers  

---