Generally when u give query like Select * from tablename; you will not ge

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

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

Answer Posted / shekharjchandra

Generally when u give query like
Select * from tablename; you will not get NULL displayed in Oracle SQL* Plus. I am not sure what tool you are using.

In SQL server you will get the output displayed NULL for null values.

If you still getting NULL as display value for null values then probably u have to do small change.

at SQL prompt use SQL* Plus command

SQL> SET NULL ""

now u give u r query, u will not get NULL displayed for null values

Regards
J

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is meant by <> in sql?

893

Is primary key clustered or nonclustered?

951

What are the steps for performance tuning.

1268

what is meant by urlencode and urldocode? : Sql dba

1090

what are the differences among rownum, rank and dense_rank? : Sql dba

981

How to write a query to show the details of a student from students table whose

938

How do you remove duplicate records from a table?

885

What is column?

940

What is a common use of group by in sql?

995

What is a database event trigger?

1081

What are three advantages to using sql?

958

Is sql similar to python?

917

Can we join tables without foreign key?

908

What are triggers in sql?

972

Is sql better than access?

961