Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

display null value rows with out using null function?

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

What are the differences between in and exists clause?

1048


Why is sharding used?

940


What is oracle pl sql developer?

934


What is full form of rtm?

953


What are the different parts of a package?

1041


What does := mean in pl sql?

990


What are sql constraints?

1125


mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

990


What is sap sql anywhere?

972


How can you tell the difference between an index and a view?

870


Can a procedure in a package be overloaded?

982


what is myisam? : Sql dba

1000


How do I run a sql query?

968


How do I enable sql encryption?

966


what is the different between now() and current_date()? : Sql dba

934