adspace


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

display null value rows with out using null function?

Question Posted / harinadh bolisetti

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we rollback truncate?

1083

what are the advantages of sql ? : Sql dba

1153

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2099

What is the current version of sql?

1106

Can delete statement be rollbacked?

1065

how to start mysql server? : Sql dba

1279

What is the best sql course?

1062

how to use regular expression in pattern match conditions? : Sql dba

1125

What is the current version of postgresql?

1188

Does group by remove duplicates?

1120

what are aggregate and scalar functions? : Sql dba

1142

what are all the common sql function? : Sql dba

1141

what is schema? : Sql dba

1163

how many tables will create when we create table, what are they? : Sql dba

1154

what is dbms? : Sql dba

1069