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 |
Can we write dml inside a function in sql server?
What are crud methods?
What is cte sql?
What will you get by the cursor attribute sql%rowcount?
Is vs as in pl sql?
What is linq to sql?
What is cursor and why it is required?
how do u call in & out parameters for stored procedures?
10 Answers A1 Technology, TCS, Techicon,
how to shutdown mysql server? : Sql dba
Write the order of precedence for validation of a column in a table ?
What is a temporal table?
Does oracle roll back the transaction on an error?