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
15241 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

Does view contain data?

1024

What is the difference between function and procedure in pl/sql?

1081

How run sql*plus commands that are stored in a local file?

1059

What does where 1 1 mean in sql?

1038

What is rownum and rowid?

1030

What is dynamic sql in pl sql?

1032

Enlist some predefined exceptions?

1055

What is java sql driver?

1112

Explain the difference between 'between' & 'and' operators in sql

996

What is a stored procedure in sql with example?

1125

How can you tell the difference between an index and a view?

935

What are the types of optimization?

955

How does a self join work?

1109

How to pipe multiline string to isql?

1005

What trigger means?

975