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?

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

Show Hint

Leave a Reply 5

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

Mike

Mike

Combining more than two columns or expressions into a single column in the output. ¿ What happen with CONCAT function ? ¿ Why D. option doesn’t works ?

Reply

Monic

Monic

A – TO_CHAR (datetime)
B ? this sentence is for me quite ambiguous. If “the number of characters” means number of specified characters or number of only characters (not numbers) then we should use REGEXP_COUNT or sth like LENGTH(REGEXP_REPLACE(name,'[a-zA-Z]’,”))
C – REPLACE
D – CONCAT

So in my opinion answer is A,C,D

Reply

Monic

Monic

sorry, it should be “LENGTH(REGEXP_REPLACE(name,'[0-9]’,”))” 🙂

Reply