View the Exhibit and examine the details of the EMPLOYEES table.Evaluate the following SQL statement:SELECT phone_number
Posted: Wed Jun 07, 2023 6:11 am
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
- View The Exhibi 1 (377 KiB) Viewed 166 times
B. (xxx) xxxxxxx
C. (xxx) xxx-xxxx
D. xxx-(xxx)-xxxx