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
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Why is normalization important?
How to read xml file in oracle pl sql?
How do you exit in sql?
How do I make my sql query run faster?
How many tables can you join in sql?
describe transaction-safe table types in mysql : sql dba
What is composite data type in pl sql?
What is join view in sql?
what is foreign key? : Sql dba
What is pl sql architecture?
how to use case expression? : Sql dba
Write the alter statement to enable all the triggers on the t.students table.
Which tcp/ip port does sql server run?
What is sql partition?
