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
- 12832 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / hiya
SELECT REPLACE(A,'NULL',' '),
REPLACE(B,'NULL',' '),
REPLACE(C,'NULL',' ')FROM TEST1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is sql in java?
Is it mandatory for the primary key to be given a value when a new record is inserted?
how to select first 5 records from a table? : Sql dba
what is the difference between group by and order by in sql? : Sql dba
What are the types of keys?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
Does db2 use sql?
What is a pl/sql block?
Can a table contain multiple primary key’s?
Which kind of parameters cannot have a default value in pl sql?
What is a sql profiler?
What is cursor explain with example?
What is the clause we need to add in function body to return variable?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
Is sql easier than java?
