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,

---

If we update a complex view, is base table will get update ?

2 Answers   Ardee Technologies, HCL,

---

what is difference between stored procedures and application procedures,stored function and application function?

1 Answers  

---

If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.

4 Answers   Saama Tech, TCS,

---

How do I delete a trigger?

0 Answers  

---

What is pl sql block in dbms?

0 Answers  

---

Is a table valued function object?

0 Answers  

---

what is rdbms? : Sql dba

0 Answers  

---

There is a table, In one column it has implemented a index, but the index is disturbed by the regular dml statements.. but still we need to keep the index. how it is possible?

1 Answers   Cognizant,

---

select 1,col1,col2 from table1. output?

5 Answers   Ramco,

---

What do you know by pl/sql cursors?

0 Answers  

---

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

0 Answers  

---