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 are different joins used in sql?

0 Answers  


What is replication id?

0 Answers  


what is meant by tuning and tk proof?

2 Answers  


How do you rename a table in sql?

0 Answers  


what is the differnce between procedure and function? in both dml operations can work and in procedure through out parameter you can return value ,then what is the differce?

3 Answers   3i Infotech,


How do I order columns in sql?

0 Answers  


What is compilation error in pl sql?

0 Answers  


How will you delete a particular row from a Table?

7 Answers   Cap Gemini,


What is a primary key called that is made up of more than one field?

0 Answers  


what are the demerits of sql?

1 Answers  


Why is a trigger used?

0 Answers  


What is the maximum number of rows in sql table?

0 Answers  


Categories