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 does an inner join do?

1196

Can a table contain multiple foreign key’s?

1010

How do I add a database to sql?

1139

How to load data with sql*loader?

1060

Does db2 use sql?

955

What is the difference between function, procedure and package in pl/sql?

1273

What is a table partition?

1150

what is commit? : Sql dba

1085

What is a unique constraint?

1085

How to make a copy values from one column to another in sql?

1047

What are all the different types of indexes?

1159

What is sql deadlock?

1152

How to raise user-defined exception with custom sqlerrm ?

1140

Name the different types of indexes in sql and define them.

1161

Write a unique difference between a function and a stored procedure.

1010