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
How long will it take to learn pl sql?
How exception handling is done in advance pl/sql?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
What are the types of dbms?
How do you modify a trigger?
What is the sql case statement?
Explain the components of sql?
what are the differences between char and varchar? : Sql dba
What is package in pl sql with an examples?
Is sql a oracle?
Give the order of sql select?
How do I partition in sql?
Is vs as in pl sql?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
How many commands are in sql?