select * from table_name where nvl(column

display null value rows with out using null function?

Question Posted / nilesh patil

Answer Posted / nilesh patil

select * from table_name where nvl(column_name,'#')='#';

Is This Answer Correct ?

6 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How much does sqlite cost?

982

Which version of sql do I have?

993

What is 19 null in sql?

893

what are the nonstandard string types? : Sql dba

1078

What is benefit of creating memory optimized table?

905

Can we use join in subquery?

1020

how to delete an existing column in a table? : Sql dba

950

What is a Mapplet?

1053

How can we avoid duplicating records in a query?

917

What programs use sql?

940

What is data control language?

945

What is exception? What are the types of exceptions?

1028

Why do we need unique key in a table?

882

What is Histogram?

1499

How subquery works in sql?

992