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);
- 11 Answers
- 12831 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
Is keyword pl sql?
What is aggregate function in sql?
What is date functions?
What is the difference between an inner join and an outer join?
What are the most important ddl statements in sql?
Why schema is used in sql?
what are the limitations of identity column? : Transact sql
what is auto increment? : Sql dba
How do you optimize a stored procedure in sql?
What is raw datatype in sql?
What does count (*) mean?
What does 0 mean in sql?
What is the difference between count 1 and count (*) in a sql query?
Why stored procedure is faster than query?
what are numeric data types? : Sql dba
