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 your daily office routine?

2351

define sql insert statement ? : Sql dba

1108

Is primary key clustered index?

1027

how to use regular expression in pattern match conditions? : Sql dba

1125

What is the best sql course?

1062

what are the advantages of sql ? : Sql dba

1154

Is primary key always clustered index?

1101

what is sql server agent? : Sql dba

1188

how to start mysql server? : Sql dba

1279

Can we rollback truncate?

1083

Is inner join faster than left join?

1287

what are aggregate and scalar functions? : Sql dba

1142

Do we need to rebuild index after truncate?

1151

Can we use distinct and group by together?

1146

what are all the common sql function? : Sql dba

1141