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 the difference difference between procedure and packages

10279

What is the current version of postgresql?

1019

What is difference between mysql and postgresql?

1068

How many types of index are there?

980

What are the types of operators available in sql?

1020

Define a temp table?

978

What is substitution variable in pl sql?

994

Which command is used to delete a package?

1110

Is left join inner or outer?

978

What is the difference between row level and statement level trigger?

970

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1032

How do I install sql?

947

What are all the different normalizations?

982

What is sharding in sql?

928

What are the types pl/sql code blocks?

1083