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

Can you sum a count in sql?

1011


Can we use join in subquery?

1095


how to create a test table in your mysql server? : Sql dba

1008


What is materialized view. What are different methods of refresh?

1393


What is sqlcontext?

1084


What is the use of index in sql?

1017


Can a foreign key be a duplicate?

911


What is raid? How does it help storage of databases?

1087


What is a natural join?

1071


What is a constraint?

1022


How do I make sql search faster?

996


What is a variable in sql?

1001


Can dml statements be used in pl/sql?

1080


What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

1003


What are the possible values that can be stored in a boolean data field?

1000