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
- 13406 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
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
What is bulk collect in pl sql?
How is pl sql different from sql?
how to include character strings in sql statements? : Sql dba
How does an execution block start and end in pl sql?
What can you do with pl sql?
Can we create view in stored procedure?
define join and explain different type of joins? : Sql dba
What are different types of tables in sql?
What is pl/sql language case sensitive?
what is 'mysqladmin' in mysql? : Sql dba
How do I use google cloud in sql?
What are the most important characteristics of pl/sql?
What is linq to sql?
Why left join is used in sql?
