display null value rows with out using null function?
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 |
Post New Answer View All Answers
what is 'mysqld'? : Sql dba
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
What is a common use of group by in sql?
What is t sql used for?
How does stored procedure reduce network traffic?
How to find 3rd highest salary of an employee from the employee table in sql?
What is sql query optimization?
How do I order columns in sql?
How to process query result in pl/sql?
What is a memo field?
Which command is used to delete a package?
Is progress software supports to ( pl/sql )?
What is memory optimized table?
What is posting?
How to raise user-defined exception with custom sqlerrm ?