Which option would be the correct format in the output?

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?

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



Leave a Reply 1

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