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...

real time applications of nullif?

Answer Posted / babu

nullif basically allows you to compare 2 expressions of
same datatype and return null if both are equal. else it
would return the first expression.eg:
nullif(10,10) returns null

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why does sql need a server?

985


what is the difference between cluster and non cluster index? : Sql dba

952


What is keys and its types?

1018


What is autocommit sql?

922


What is out parameter used for eventhough return statement can also be used in pl/sql?

1013


Can %notfound return null after a fetch?

996


What are the types of operators available in sql?

1006


what is the difference between rownum pseudo column and row_number() function? : Sql dba

1018


What is Collation Sensitivity ? What are the various type ?

901


Which command is used to call a stored procedure?

949


Is sql a scripting language?

921


Why do we need pl sql?

934


What is trigger in pl sql?

954


What are its different types of dbms?

955


How can we implement rollback or commit statement in a trigger?

974