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
15274 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 thread join () in threading?

1015

What are the string functions in sql?

975

What is range partitioning?

965

Is progress software supports to ( pl/sql )?

1037

Explain what is a column in a table?

1107

Is sql a backend language?

1094

what is the difference between myisam static and myisam dynamic? : Sql dba

1065

What is mutating sql table?

1110

what is a trigger in mysql? Define different types of trigger. : Sql dba

1069

What is rename command in sql?

1035

what happens if you no create privilege in a database? : Sql dba

1001

What is an ndf file?

994

What is record data type?

916

how to calculate expressions with sql statements? : Sql dba

1034

what is a database lock ? : Sql dba

1170