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
12155 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 mysql and postgresql?

520

What is sql comments?

654

what is datawarehouse? : Sql dba

573

What is clause?

612

what is bdb (berkeleydb)? : Sql dba

574

Explain correlated query work?

601

How to disable a trigger name update_salary?

678

What is memory optimized table?

577

What is partition in sql query?

521

What is recursive stored procedure?

608

What is trigger types of trigger?

556

how to get a list of all tables in a database? : Sql dba

513

What can I use instead of union in sql?

518

What is varchar data type in sql?

520

What are analytic functions in sql?

555