SQL> ALTER TABLE michigan_park

  2  ADD (CONSTRAINT phone_number_format
  3       CHECK (REGEXP_LIKE(park_phone,
  4       '^\([[:digit:]]{3}\) [[:digit:]]{3}-[[:digit:]]{4}$')));

Table altered.


SQL> INSERT INTO michigan_park (park_name, park_phone)
  2     VALUES ('Warren Dunes State Park','616.426.4013');
INSERT INTO michigan_park (park_name, park_phone)
*
ERROR at line 1:

ORA-02290: check constraint (TK32VP.PHONE_NUMBER_FORMAT) violated

SQL> INSERT INTO michigan_park (park_name, park_phone)
  2     VALUES ('Warren Dunes State Park','(616) 426-4013');