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

1019

What are the benefits of pl sql?

1110

Explain alias in sql?

1036

What is bind variable in pl sql?

1038

Write a sql query to find the names of employees that begin with ‘a’?

999

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1045

What are pl/sql packages?

1095

what is data manipulation language? : Sql dba

997

Is sql port 1433 encrypted?

1017

Are subqueries faster than joins?

1007

What are its different types of dbms?

996

What is mdb stand for?

1003

What is a record in a database?

1051

How do I run a pl sql program?

1121

How can you load multi line records? : aql loader

1069