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 user in sql?

0 Answers  


What is a schema? How is it useful in sql servers?

0 Answers  


What is the purpose of the primary key?

0 Answers  


IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????

8 Answers   rsystems,


hi this is nakka i have been looking for 1+ exp in oracle sql,plsql developer positions also have knoledge on d2k i am not getting proper walkins how to know it? where can i find it?

5 Answers  






What is AUTH_ID and AUTH_USER in pl/sql ?

0 Answers   INDUS,


What is a dirty read sql?

0 Answers  


What is the difference between sql and mysql?

0 Answers  


What is the purpose of the sql select top clause?

0 Answers  


What are the events on which a database trigger can be based?

0 Answers  


What are the various levels of constraints?

0 Answers  


How do I run a query in pl sql developer?

0 Answers  


Categories