SELECT REPLACE(A,'NULL',' '), REPLACE(B,'

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);

Question Posted / hiya

11 Answers
15266 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

Please Help Members By Posting Answers For Below Questions

What are pl sql procedures?

1024

What is scalar function?

1051

What is sql procedures and functions?

1004

What is Difference Between Unique and Primary Key Constraints?

1105

What is cross join sql?

917

Does sql*plus also have a pl/sql engine?

1079

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

1005

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1581

What is multiple columns?

1065

How to return multiple rows from the stored procedure?

970

Advantages and disadvantages of stored procedure?

1122

What is a dynamic query?

1022

Is it possible to create the following trigger: before or after update trigger for each row?

1286

What is sap sql anywhere?

1077

what is a foreign key ? : Sql dba

1081