in case of integer data type column. select * from emp where nvl(deptno

display null value rows with out using null function?

Question Posted / harinadh bolisetti

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

Please Help Members By Posting Answers For Below Questions

What is sql resultset?

979

how to enter numeric values as hex numbers? : Sql dba

1057

what is a trigger? : Sql dba

1020

what's the difference between a primary key and a unique key? : Sql dba

1038

How many indexes can be created on a table in sql?

1041

Can procedure in package be overloaded?

1075

What is recursive stored procedure?

1095

what are the features and advantages of object-oriented programming? : Sql dba

998

How does one load ebcdic data? : aql loader

1159

What does trigger mean in psychology?

958

Why do we need pl sql?

966

what is online transaction processing (oltp)? : Sql dba

991

What is trigger explain it?

1006

How to add a column ‘salary’ to a table employee_details?

1005

What is the difference between having and a where in sql?

1094