Hi You Can Replace the null without using nvl function. using replac

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 / jayendra

11 Answers
15150 Views
Satyam, I also Faced
E-Mail Answers

Answer Posted / jayendra

Hi
You Can Replace the null without using nvl
function.
using replace key world
like this
Select Replace(values,'null')
from demo where values!=NULL;
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

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is the difference between primary key and unique key? : Sql dba

1015

What are the two virtual tables available at the time of database trigger execution?

1198

Name the operator which is used in the query for pattern matching?

929

How to change the order of columns in Oracle SQL Plus ?

1041

how to create a test table in your mysql server? : Sql dba

989

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1056

What is pivot query?

1055

Is it possible to update views?

946

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1208

what are the authentication modes in sql server? : Sql dba

1044

Enlist the characteristics of pl/sql?

1778

What is left join example?

934

What is difference between stored procedure and trigger?

1134

What is input buffer in sql*plus?

1192

What is a sql schema used for?

1080