suppose we hav,table name: demo values ------ 1 2 3 NULL 3 4 1 5

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);

Question Posted / lavanya

11 Answers
15131 Views
Satyam, I also Faced
E-Mail Answers

Answer Posted / lavanya

suppose we hav,table name: demo
values
------
1
2
3
NULL
3
4
1
5
NULL

select values from demo where values!=NULL

Is This Answer Correct ?

0 Yes

8 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is bind reference and how can it be created?

1002

Is sql database free?

957

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

1003

How many types of triggers are there in pl sql?

1049

Can pl sql procedure have a return statement?

999

What are hotfixes and patches?

926

How do you bind variables in pl sql?

1073

Why having clause is used in sql?

957

What is the difference between the sql*loader and import utilities? : aql loader

1013

What is date functions?

1013

What is sql keyword?

980

What are some predefined exceptions in pl/sql?

1143

What does subquery mean in sql?

1034

What is out parameter used for eventhough return statement can also be used in pl/sql?

1058

What type of join is sql join?

960