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 |
Explain the advantages and disadvantages of stored procedure?
Why is partition used in sql?
what is the command used to fetch first 5 characters of the string? : Sql dba
how to find the second highest salary from emp table?
211 Answers CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar,
What is secondary key?
What is aggregate function in sql?
Which is faster truncate or drop?
Can we use ddl statements in stored procedure sql server?
How do I enable sql encryption?
What is correlated sub-query?
How many types of privileges are available in sql?
What is indexing oracle sql?