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 are sql built in functions?

894

What are the dml statements?

1095

Does sql*plus also have a pl/sql engine?

1037

Does truncate need commit?

893

Is sql microsoft?

977

What is an ndf file?

926

What are pl/sql packages?

1035

How do I find duplicates in two columns?

1057

What is nosql example?

969

Explain the select statement in sql?

1044

What company owns postgresql?

961

State some properties of relational databases?

1002

what is subquery? : Sql dba

1066

what are the types of subquery? : Sql dba

1049

what are the advantages of using stored procedures? : Sql dba

1059