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
- 13413 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 on delete restrict?
Can you inner join the same table?
What is type and rowtype in pl sql?
Does pdo prevent sql injection?
Write an sql query to select all records from the table?
What is sql procedures and functions?
what are the nonstandard string types? : Sql dba
What jobs use sql?
What is a trigger word?
How do you modify a column in sql?
What are the different types of functions in sql?
What is compound trigger?
How many sql core licenses do I need?
How do I remove all records from a table?
How does an execution block start and end in pl sql?
