display null value rows with out using null function?
- 8 Answers
- 9190 Views
- Infosys, I also Faced
- E-Mail Answers
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 a recursive join sql?
Why we use cross join?
What is the use of <> sql?
What does 0 mean in sql?
How to create a menu in sqlplus or pl/sql?
what are the difference between clustered and a non-clustered index? : Sql dba
What is the meaning of disabling a trigger?
How is use pl and sql?
What is the difference between distinct and unique in sql?
Define concurrency control. : Transact sql
what are the authentication modes in sql server? How can it be changed? : Sql dba
How do you delete duplicates in sql query using rowid?
Why is a primary key important?
Explain constraints in sql?
What is data abstraction in sql?
