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

What is nvl function?

Answer Posted / raveendran

In Oracle/PLSQL, the NVL function lets you substitute a
value when a null value is encountered.

The syntax for the NVL function is:

NVL( string1, replace_with )

string1 is the string to test for a null value.

replace_with is the value returned if string1 is null.

Is This Answer Correct ?    20 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are sql procedures?

1018


How do you explain an index?

1281


Is oracle sql free?

981


What are the different types of triggers?

1130


What is the difference between partition and index?

981


Is there a 64 bit version of ssms?

958


Can we use insert statement in function?

997


How much does a sql dba make? : SQL DBA

939


What language is oracle sql developer?

1005


how to create a new table by selecting rows from another table in mysql? : Sql dba

1086


Is a view faster than a stored procedure?

958


What is the default isolation level in sql server? : Transact sql

1023


What is pl sql collection?

962


What is difference between mysql and postgresql?

1148


Why use truncate instead of delete?

1013