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 'mysqldump'? : Sql dba

761

Why do we need sharding?

730

what is the difference between sql and t-sql? : Transact sql

811

What is java sql drivermanager?

746

What is mutating error?

699

When are we going to use truncate and delete?

718

how to show all tables with 'mysql'? : Sql dba

817

What is the advantage of nosql?

735

What are the types of variables use in pl sql?

689

What are types of joins?

703

What is crud stand for?

746

Is primary key an index?

713

What is the use of %rowtype?

747

What are the commands used in sql?

739

Which is faster joins or subqueries?

717