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 'mysqld'? : Sql dba

907

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3008

What is a common use of group by in sql?

995

What is t sql used for?

972

How does stored procedure reduce network traffic?

965

How to find 3rd highest salary of an employee from the employee table in sql?

1035

What is sql query optimization?

1021

How do I order columns in sql?

912

How to process query result in pl/sql?

1060

What is a memo field?

901

Which command is used to delete a package?

1090

Is progress software supports to ( pl/sql )?

969

What is memory optimized table?

984

What is posting?

990

How to raise user-defined exception with custom sqlerrm ?

1061