display null value rows with out using null function?
- 8 Answers
- 9135 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / harinadh bolisetti
in case of integer data type column.
select * from emp
where nvl(deptno,1)=1
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
define sql insert statement ? : Sql dba
What is an escape character in sql?
What is an exception in pl/sql?
What are the two different parts of the pl/sql packages?
What is difference between function and trigger?
What is materialized view. What are different methods of refresh?
How many commands are in sql?
Can we use ddl statements in stored procedure sql server?
explain the difference between bool, tinyint and bit. : Sql dba
What is sql clause?
Can a varchar be a primary key?
Does pl sql work in mysql?
what are the differences between char and nchar? : Sql dba
What is normalization sql?
how do you control the max size of a heap table? : Sql dba
