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 Exhibit and examine the details of the EMPLOYEES table.Evaluate the following SQL statement:SELECT phone_number
-
- Site Admin
- Posts: 899559
- Joined: Mon Aug 02, 2021 8:13 am