View the Exhibit and examine the details of the EMPLOYEES table.
Evaluate the following SQL statement:
SELECT phone_number,
REGEXP_REPLACE(phone_number,'([[: digit: ]]{3})\.([[: digit: ]]{3})\.([[: digit: ]]{4})’, ,(\1)\2-\3′)
“PHONE NUMBER”
FROM employees;
The query was written to format the PHONE_NUMBER for the employees. Which option would be
the correct format in the output?
A.
xxx-xxx-xxxx
B.
(xxx) xxxxxxx
C.
(xxx) xxx-xxxx
D.
xxx-(xxx)-xxxx
C