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);
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
Name three sql operations that perform a sort.
What are different sql data types?
Why do we use cursors?
what is try_catch block in procedure
What is equi join in sql?
Does a join table need a primary key?
What is the best partition size for windows 10?
What are sql objects?
What is lookup table in sql?
How do I know if I have sql express or standard?
Write a sql query to get the third highest salary of an employee from employee_table?
What is localdb mssqllocaldb?
What is the difference between microsoft access and sql server?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
Does a primary key have to be a number?