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

Which is faster subquery or join?

1217

How to get each name only once from an employee table?

1116

Which sorts rows in sql?

1020

What is data type in database?

994

What is PL/SQL Records?

1190

What is the difference between sql, mysql and sql server?

1105

Explain about various levels of constraint.

949

Can cursors be part of a trigger body?

1641

what is cross join? : Sql dba

997

Is pl sql a programming language?

994

How many types of tables are there?

952

What is pl sql script?

1035

Can a commit statement be executed as part of a trigger?

1050

What is a join?

1069

what is union, minus and interact commands? : Sql dba

1186