Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 15307 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
What is sharding in sql?
how to select unique records from a table? : Sql dba
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
what is a relationship and what are they? : Sql dba
How can I delete duplicate rows?
What is secondary key?
What is thread join () in threading?
What is database migration?
What are the advantages of sql? Explain
Should I use mbr or gpt?
What is a boolean in sql?
What operating systems are supported by oracle sql developer?
Is a secondary key the same as a foreign key?
Is sql free?
What is a clob in sql?
