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

Is sql an operating system?

1069

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

1110

How do I use google cloud in sql?

1143

What is a dirty read sql?

1234

What is a unique key?

1103

what is dbms? : Sql dba

1033

What is cartesian join in sql?

1187

What is the use of function "module procedure" in pl/sql?

1233

What is audit logout in sql profiler?

1073

What is the difference between alter trigger and drop trigger statements?

1157

Why is sql important?

1166

Why do we use set serveroutput on?

1008

How do you bind variables in pl sql?

1154

Is it possible to include an insert statement on the same table to which the trigger is assigned?

1059

Which is faster view or stored procedure?

1004