display null value rows with out using null function?

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / harinadh

8 Answers
10326 Views
Infosys, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

display null value rows with out using null function?..

Answer / nilesh patil

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

Is This Answer Correct ?

6 Yes

1 No

display null value rows with out using null function?..

Answer / 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

display null value rows with out using null function?..

Answer / ajit

In Case of NUMBER Data Type Column

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

Is This Answer Correct ?

3 Yes

0 No

display null value rows with out using null function?..

Answer / ansupriya

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

Is This Answer Correct ?

3 Yes

1 No

display null value rows with out using null function?..

Answer / rahul

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

Is This Answer Correct ?

2 Yes

0 No

display null value rows with out using null function?..

Answer / debashis mohanty

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

Is This Answer Correct ?

0 Yes

0 No

display null value rows with out using null function?..

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

Is This Answer Correct ?

0 Yes

0 No

display null value rows with out using null function?..

Answer / ajay

select * from emp
where 1=2

Is This Answer Correct ?

1 Yes

8 No

Post New Answer