🎴 Flashcard Mode
ClearCase Version Control Quiz
Card1 / 5
Mastered0
Review0
QuestionClick to flip
I am working on manager number field on some table. which is correct usage of nvl function usage....?
AnswerClick to flip back
A
nvl(mgrno,0)
💡 Explanation:
The NVL function in SQL requires both parameters to have compatible data types. Since mgrno is a numeric field, the replacement value must also be numeric. NVL(mgrno, 0) correctly substitutes NULL values with 0, while options with '0' or 'none' are strings that would cause type mismatch errors.