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

display null value rows with out using null function?

Question Posted / ansupriya

Answer Posted / ansupriya

select * from emp where nvl(to_char(comm),'null')='null';

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is a constraint?

1022

What is triggering circuit?

1064

What is data control language?

988

Which is faster count (*) or count 1?

1035

Explain the difference between rename and alias?

1010

How can you get sql*loader to commit only at the end of the load file? : aql loader

1012

What is data abstraction in sql?

1029

What is trigger explain it?

1015

can a stored procedure call itself or recursive stored procedure? : Sql dba

1028

What is the meaning of disabling a trigger?

1182

Is sql open source?

970

What is the usage of the distinct keyword?

1220

how can we know the count/number of elements of an array? : Sql dba

1060

What is difference between table and view?

1054

what are the differences between require and include, include_once and require_once? : Sql dba

1020