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-xxx-xxxx

C.
(xxx) xxxxxxx

D.
(xxx) xxx-xxxx

Explanation:



Leave a Reply 0

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