Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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 / j.n.tripathi

Answer Posted / j.n.tripathi

Hi
Sorry To ALL.....
For Above Answer
Writing Mistake there.....

You Can Replace the null without using nvl
function.
using replace key world
like this
Select Replace(values,'null')
from demo
it will display the result like this
1 2 3
3 4
1 5

Thanks
J.N.Tripathi
9868703898

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can a varchar be a primary key?

694

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

1740

What is the sql case statement?

746

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

1890

how to drop an existing index in mysql? : Sql dba

714




How can we avoid duplicating records in a query?

737

explain what is mysql? : Sql dba

783

what is index? : Sql dba

746

what is a view? : Sql dba

810

What is cartesian join in sql?

742

What are schema-level triggers?

753

explain mysql aggregate functions. : Sql dba

722

what is heap table? : Sql dba

799

What are different sql data types?

684

What is the process of copying data from table a to table b?

799