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
how to get @@error and @@rowcount at the same time? : Sql dba
What is difference between stored function and application function?
define data blocks ? : Sql dba
Does sql view stored data?
How to avoid duplicate records in a query?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What is anonymous block in sql?
What is self-join and what is the requirement of self-join?
How do you modify a table in sql?
Show the two pl/sql cursor exceptions.
What is loop in pl sql?
Why do we use sql constraints?
how to show all tables with 'mysql'? : Sql dba
What is sql analyzer?
How do I count duplicates in sql?