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

Is there a way to automate sql execution from the command-line, batch job or shell script?

937

What are all types of user defined functions?

1021

What is the difference between local and global temporary table?

1007

How to display the current date in sql?

1024

What is oracle sql called?

878

What are the two different parts of the pl/sql packages?

1042

How can we solve sql error: ora-00904: invalid identifier?

1187

How many types of privileges are available in sql?

1305

Which sql statement is used to return only different values?

965

What is sqlite format?

1129

Can variables be used in sql statements?

991

What are user defined functions?

955

how to convert character strings to dates? : Sql dba

1009

What is insert command in sql?

1078

Show the cursor attributes of pl/sql.

1015