In Case of NUMBER Data Type Column select comm from emp where nvl(to

display null value rows with out using null function?

Question Posted / ajit

Answer Posted / ajit

In Case of NUMBER Data Type Column

select comm
from emp
where nvl(to_char(comm),'#') = '#'

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is csv? : Sql dba

988

How do I partition a table in sql?

1114

Write a query to find the names of users that begin with "um" in sql?

982

what is acid property in database? : Sql dba

1016

What is difference between stored procedures and application procedures?

1004

how to use regular expression in pattern match conditions? : Sql dba

1018

What is data abstraction in sql?

1015

How to call a javascript function from pl sql?

1127

What is clustered and nonclustered index in sql?

935

How do I partition in sql?

955

explain the options of myisamchk to improve the performance of a table. : Sql dba

1001

what is query cache in mysql? : Sql dba

1024

Why self join is used in sql?

966

What is a system versioned table?

973

what is msql? : Sql dba

981