display null value rows with out using null function?
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
What is difference between primary and secondary key?
What is exit statement?
Can a varchar be a primary key?
When are we going to use truncate and delete?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
How many sql commands are there?
What makes a good primary key?
What is bulk collect in pl sql?
what is a relationship and what are they? : Sql dba
How to get help at the sql prompt?
What is transaction control language (tcl)?
What is union?
What is a trigger in sql?
what are all the different normalizations? : Sql dba
what is the difference between blob and text? : Sql dba