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 are different types of functions in sql?
What do you understand by exception handling in pl/sql?
Explain what is a view?
What is linq to sql?
What is the difference between microsoft access and sql?
Can we commit in trigger?
What type of database is cloud sql?
Explain what is sql*plus?
What is file based approach?
Can we use update in sql function?
difference between anonymous blocks and sub-programs.
how to drop an existing table in mysql? : Sql dba
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
What is primary key secondary key alternate key candidate key?
Is json a nosql?