display null value rows with out using null function?
Answers were Sorted based on User's Feedback
Answer / nilesh patil
select * from table_name where nvl(column_name,'#')='#';
Is This Answer Correct ? | 6 Yes | 1 No |
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 |
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 |
Answer / ansupriya
select * from emp where nvl(to_char(comm),'null')='null';
Is This Answer Correct ? | 3 Yes | 1 No |
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 |
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 |
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 |
What are different joins used in sql?
What is replication id?
what is meant by tuning and tk proof?
How do you rename a table in sql?
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?
How do I order columns in sql?
What is compilation error in pl sql?
How will you delete a particular row from a Table?
What is a primary key called that is made up of more than one field?
what are the demerits of sql?
Why is a trigger used?
What is the maximum number of rows in sql table?