Answer Posted / winnie
In NVL function , it allows to replace with a value when a
null value is encountered.
The syntax is
SELECT NVL(EMP_NAME,'ABC') FROM EMP;
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
which operator is used in query for pattern matching? : Sql dba
what is csv? : Sql dba
What is using in sql?
What does joining a thread mean?
Explain raise_application_error.
Write a sql query to get the third highest salary of an employee from employee_table?
What is coalesce sql?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
Which is better join or inner query?
What plvcmt and plvrb does in pl/sql?
Name the operator which is used in the query for pattern matching?
what are date and time intervals? : Sql dba
What is PL/SQL Records?
What are the properties of a transaction?
What mean sql?