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
Is it possible to create the following trigger: before or after update trigger for each row?
What is offset and limit in sql?
What is attribute indicator in pl sql?
What is not equal in sql?
discuss about myisam index statistics collection. : Sql dba
What is trigger in sql?
What is a database event trigger?
What is the unique index?
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
How exception handling is done in advance pl/sql?
Can delete statement be rollbacked?
Why do we use set serveroutput on?
How do I view tables in mysql?
What are the advantages of normalization?
What is keys and its types?
