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 is user in sql?
What is a schema? How is it useful in sql servers?
What is the purpose of the primary key?
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??????
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?
What is AUTH_ID and AUTH_USER in pl/sql ?
What is a dirty read sql?
What is the difference between sql and mysql?
What is the purpose of the sql select top clause?
What are the events on which a database trigger can be based?
What are the various levels of constraints?
How do I run a query in pl sql developer?