Which three tasks can be performed using SQL functions built into Oracle Database?
A.
Displaying a date in a nondefault format
B.
Finding the number of characters in an expression
C.
Substituting a character string in a text expression with a specified string
D.
Combining more than two columns or expressions into a single column in the output
Shouldn’t D be also correct because of the LISTAGG function?
No, forget it. I was thinking in combining more than two rows. Anyway, this option tries to confuse you with the CONCAT function, which doesn’t work with more than two columns/expressions.
Nice explanation Leandro 🙂