display null value rows with out using null function?

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

More SQL PLSQL Interview Questions

What is CYCLE/NO CYCLE in a Sequence?

2 Answers  


What is normalization in a database?

0 Answers  


What is difference between sql and mysql?

0 Answers  


What will be the output for the below Query Select 'High' from dual where null = null;

12 Answers   Infosys, Satyam,


How many times can we commit in a loop?

0 Answers  


cursor types? explain with example programs?

1 Answers   HP,


Is sql harder than python?

0 Answers  


What are expressions?

0 Answers  


Can we debug stored procedure?

0 Answers  


What are the advantages of normalization?

0 Answers  


What are the uses of sysdate and user keywords?

0 Answers  


what is data integrity? : Sql dba

0 Answers  


Categories