In Case of NUMBER Data Type Column select comm from emp where nvl(to

display null value rows with out using null function?

Question Posted / ajit

Answer Posted / ajit

In Case of NUMBER Data Type Column

select comm
from emp
where nvl(to_char(comm),'#') = '#'

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is collation? : Sql dba

1242

If a cursor is open, how can we find in a pl/sql block?

1252

what is sql server agent? : Sql dba

1188

What is the current version of sql?

1106

Is primary key always clustered index?

1101

what are the advantages of sql ? : Sql dba

1153

Can delete statement be rollbacked?

1065

What is your daily office routine?

2351

What is the best sql course?

1062

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

1125

Does group by remove duplicates?

1120

what is bcp? When does it used? : Sql dba

1065

what are aggregate and scalar functions? : Sql dba

1142

how to escape special characters in sql statements? : Sql dba

1124

what is schema? : Sql dba

1163