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
15613 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 an ndf file?

1062

What is time based sql injection?

1033

discuss about myisam key cache. : Sql dba

1068

What are the topics in pl sql?

1023

What is compiled query?

1084

Which kind of parameters cannot have a default value in pl sql?

1210

How does sql*loader handles newline characters in a record? : aql loader

1090

Does db2 use sql?

1009

Define the select into statement.

1109

explain the options of myisamchk to improve the performance of a table. : Sql dba

1072

What is the difference between in and between in sql?

1108

What plvcmt and plvrb does in pl/sql?

1366

difference between anonymous blocks and sub-programs.

1188

How do I run a sql script?

1227

What are the different dml commands in sql?

1247