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

Is sql database free?

1024

What are literals in sql server?

1243

Define commit?

1052

What is delimiter in pl sql?

1095

what is the use of friend function? : Sql dba

1057

Why do we use cursors?

1039

Define overloaded procedure?

1130

Explain the difference between 'between' & 'and' operators in sql

1039

what is column? : Sql dba

1047

Is null operator in sql?

1088

how to dump a table to a file with 'mysqldump'? : Sql dba

1096

What is the current version of postgresql?

1124

What are sql*plus environment variables?

1150

Can one improve the performance of sql*loader? : aql loader

1096

How to get each name only once from an employee table?

1153