Which three tasks can be performed using SQL functions built into Oracle Database?

Which three tasks can be performed using SQL functions built into Oracle Database? (Choose
three.)

Which three tasks can be performed using SQL functions built into Oracle Database? (Choose
three.)

A.
Combining more than two columns or expressions into a single column in the output

B.
Displaying a date in a nondefault format

C.
Substituting a character string in a text expression with a specified string

D.
Finding the number of characters in an expression



Leave a Reply 4

Your email address will not be published. Required fields are marked *


terra

terra

all are correct i believe

Ritam Tiwari

Ritam Tiwari

Option A is wrong…
we can combine two or more columns by using || symbol but there is no inbuilt SQL function .

riccia

riccia

‘concat’ function can be operated only on 2 variables or columns, while ‘concat’ operation can be
done for any number of variables or columns.

andrews

andrews

Why option A is wrong.You can combine two or more columns using nested CONCAT

concat(concat(string1,string2),string3))