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 |
How does postgresql compare to mysql?
What is an index in sql with example?
What are the two types of exceptions.
How do you concatenate in sql?
List the various privileges that a user can grant to another user?
Why use subqueries instead of joins?
What is a database event trigger?
How run sql*plus commands that are stored in a local file?
How do you create a unique index?
oracle is compiler or interpretter,can any one tell me the answer?
describe transaction-safe table types in mysql : sql dba
Is json a nosql?