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

How do I order columns in sql?

1069


How to call a javascript function from pl sql?

1183


How can I speed up sql query?

1003


Explain how exception handling is done in advance pl/sql?

1043


Is primary key an index?

1032


what is difference between delete and truncate commands? : Sql dba

1165


Can there be more than one function with a similar name in a pl/sql block?

1036


What is a full join?

1041


How does cross join work in sql?

1071


What do we need to check in database testing?

1059


What are the types of keys?

1060


Explain what is an index?

1102


Can you join views in sql?

992


What is %type in pl sql?

1003


Why do we need cursor in pl sql?

1182