The only option I feel is SELECT * FROM TABLE WHERE COL

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 / dipti

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

Answer Posted / dipti

The only option I feel is

SELECT * FROM TABLE
WHERE COL_NAME IS NOT NULL

will return the non null values which I think is asked for
this question.

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do you define a foreign key?

1008

How delete all data from table in sql?

1019

How do I run a pl sql program?

1132

Is drop table faster than truncate?

991

What is the difference between sql, mysql and sql server?

1109

what is the syntax for using sql_variant_property? : Transact sql

1049

How to return multiple rows from the stored procedure?

971

How can you load microsoft excel data into oracle? : aql loader

1174

What are different types of sql?

1193

Why we use stored procedure instead of query?

999

What are actual parameters and formal parameters?

1107

Explain what is table in a database?

1062

Can you have a foreign key without a primary key?

955

What steps server process has to take to execute an update statement?

977

Can we enter data in a table in design view?

969