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
D is incorrect. Function CONCAT can concatenate only 2 columns.
C is correct – there is function REPLACE