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 to get a list of all tables in a database? : Sql dba

918


What is before and after trigger?

890


What does partition by mean in sql?

908


Does user triggers have entry for trigger with compilation errors?

973


What are all the different normalizations?

970


What is a temp table?

948


What is relationship? How many types of relationship are there?

1070


How do you rename a table in sql?

1029


How many developers work on postgresql?

915


How to use sql*plus built-in timers?

1095


How can the performance of a trigger be improved?

991


Do prepared statements prevent sql injection?

897


What version is sql?

964


Why is a primary key important?

967


define sql update statement ? : Sql dba

1049