Suggested Answer:BD🗳️
Using the COALESCE Function - The advantage of the COALESCE function over the NVL function is that the COALESCE function can take multiple alternate values. If the first expression is not null, the COALESCE function returns that expression; otherwise, it does a COALESCE of the remaining expressions. Using the COALESCE Function - The COALESCE function returns the first non-null expression in the list.
Syntax - COALESCE (expr1, expr2, .. exprn) In the syntax: expr1 returns this expression if it is not null expr2 returns this expression if the first expression is null and this expression is not null exprn returns this expression if the preceding expressions are null Note that all expressions must be of the same data type.
VER VAGUE QUESTION EVEN 1 AND C ARE CORRECT DEPENDS ON THE INTERPRETATION OF THE QUESTION
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
winston
1 year, 5 months ago