Answer / nilesh patil

select * from table_name where nvl(column_name,'#')='#';

Answer / harinadh bolisetti

in case of integer data type column.

select * from emp
where nvl(deptno,1)=1

Answer / ajit

In Case of NUMBER Data Type Column

select comm
from emp
where nvl(to_char(comm),'#') = '#'

Answer / ansupriya

select * from emp where nvl(to_char(comm),'null')='null';

Answer / rahul

Select * from emp where comm is null;
--here i am not used any null function

Answer / debashis mohanty

Select * From Emp where NVL(TO_CHAR(COMM),'NULL VALUE ROW')='NULL VALUE ROW';

Answer / noor

Select Empno, Decode (Comm,Null,0,Comm) Comm From Emp;

Select Empno, Case When Comm Is Null Then 0 Else Comm End Comm From Emp

Answer / ajay

select * from emp
where 1=2

What is Overloading of procedures ?

2 Answers  

How do you use join?

0 Answers  

When are we going to use truncate and delete?

0 Answers  

What is normalization and types of normalization?

22 Answers   Etisbew, F-TEC, Microsoft, TechProcess,

What do you mean by stored procedures? How do we use it?

0 Answers  

How do I partition in sql?

0 Answers  

is it necessary to write group by and order by clause together

3 Answers   HCL, Wipro,

what are the different index configurations a table can have? : Sql dba

0 Answers  

Do we need to create index on primary key?

0 Answers  

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

0 Answers  

How do you optimize a stored procedure in sql?

0 Answers  

How do I enable sql encryption?

0 Answers