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

How to disable a trigger name update_salary?

1210

Why truncate is faster than delete?

1062

What is a join query?

910

What is bulk collect in pl sql?

1038

Why left join is used in sql?

930

What is coalesce sql?

950

What is difference between inner join and cross join?

917

How do you add a column to a table?

1009

Why function is used in sql?

888

Explain the savepoint statement.

1050

What are different types of indexes?

972

How many parts of a pl sql block are optional?

1046

What is meant by temporal data?

917

Explain the insert into statements in sql?

953

Explain what is a column in a table?

1053