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
14791 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 is difference between sql function and stored procedure?

934

Show how functions and procedures are called in a pl/sql block.

1038

How can I see all tables in sql?

983

What is difference between db2 and sql?

935

Does oracle roll back the transaction on an error?

956

What is delimiter sql?

920

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2107

What are three advantages to using sql?

958

Will truncate release space?

883

What are the parameter modes supported by pl/sql?

1015

Explain how can you save or place your msg in a table?

979

discuss about myisam index statistics collection. : Sql dba

905

What is normalization in a database?

1104

If a cursor is open, how can we find in a pl/sql block?

1103

How many primary keys can a table have?

949