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
Why do we use cursors?
how tsql statements can be written and submitted to the database engine? : Transact sql
What is trigger in pl sql?
Can we commit inside a trigger?
Are sql database names case sensitive?
How does join work in sql?
Write the alter statement to enable all the triggers on the t.students table.
What trigger means?
What is sql table?
How do I make sql search faster?
What is the difference between partitioning and sharding?
What are the different set operators available in sql?
What does (+) mean in sql joins?
What is an emotional trigger?
Differentiate between syntax and runtime errors.