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
15153 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

How many tables can you join in sql?

942

what is try_catch block in procedure

1723

What is constant in pl sql?

1005

Are dml statements autocommit?

1028

What does where 1 1 mean in sql?

1019

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3988

how do you tune the slow running queries in oracle db , explain the methodology

2581

What is difference between ms sql and mysql?

945

How do you modify a trigger?

914

What is an oracle stored procedure?

1029

how to add a new column to an existing table in mysql? : Sql dba

1049

what are the limitations of identity column? : Transact sql

1087

Which language is used in sql?

1041

How are sql commands classified?

1071

Is it possible to update views?

946