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
15231 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 the usages of sql?

1056

Is it possible to read/write files to-and-from PL/SQL?

1099

What are types of exception?

916

What is scope of pl sql developer in future?

1014

What is plpgsql language?

1056

The select into statement is most often used to create backup copies of tables or for archiving records?

1062

Explain foreign key in sql?

1018

What do you mean by table in sql?

986

What are the benefits of pl sql?

1115

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

1192

Is pl sql different from sql?

990

What is trigger types of trigger?

1065

Give the order of sql select?

1133

How do you drop a trigger?

984

What is sql procedures and functions?

1002