Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / shivaindu
In Oracle/PLSQL, the NVL function lets you substitute a
value when a null value is encountered.
The syntax for the NVL function
-------------------------------
NVL( string1, replace_with )
Example #1:
----------
select NVL(supplier_city, 'n/a' or ‘0’)
from suppliers;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a sql instance vs database?
Are dml statements autocommit?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
Is sql a programming?
What are pl/sql cursor exceptions?
how to shut down the server with 'mysqladmin'? : Sql dba
In what condition is it good to disable a trigger?
What are the differences between implicit and explicit cursors?
What is nosql example?
what is a field in a database ? : Sql dba
How do I find duplicates in a single column in sql?
Is pl sql a programming language?
Are subqueries faster than joins?
What is sql partition function?
How many sql commands are there?
