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
14822 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 are wild cards used in database for pattern matching ? : Sql dba

1078

What is a unique constraint?

1016

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1037

Can we use ddl commands in pl sql?

1075

When is a declare statement required?

1083

Does oracle roll back the transaction on an error?

962

What has stored procedures in sql?

996

How can you fetch first 5 characters of the string?

948

How do I enable sql encryption?

969

what is data manipulation language? : Sql dba

949

What problem one might face while writing log information to a data-base table in pl/sql?

1067

What is package in pl sql with an examples?

972

What is $$ in sql?

943

Can we insert in view in sql?

1004

Give the order of sql select?

1089