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

Explain the types of joins in sql?

1035

What is the use of pl/sql table?

1068

What is character functions?

1064

How do I save the results of sql query in a file?

980

i have some prob lem to tell me about my self in interview first round ...

2165

Is sql a scripting language?

1020

Why do we need view in sql?

990

What is sql in java?

1091

What is set serveroutput on in pl sql?

1301

what is primary key? : Sql dba

1032

Can cursors be part of a trigger body?

1641

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

1000

what are the differences between binary and varbinary? : Sql dba

1046

How do I view tables in sql developer?

954

How do you copy a table in sql?

1076