Code Listing 2: Increasing the constraints on the phone number pattern

SQL> SELECT park_name, description 

  2  FROM michigan_park
  3  WHERE REGEXP_LIKE(description, '[0-9]{3}[-.][0-9]{4,4}');

Mackinac Island State Park
Michigan's first state park encompasses approximately 1800 acres

of Mackinac Island. The centerpiece is Fort Mackinac, built in 1780 by
the British to protect the Great Lakes Fur Trade. For information by
phone, dial 800-44-PARKS or 517-373-1214.

Fort Wilkens State Park
Located almost at the very tip of the Keewenaw Peninsula,

Fort Wilkens is a restored army fort built during the copper rush.
Camping is available. For the modern campground, phone (800) 447-2757. For
group-camping, phone 906.289.4215. For information on canoe, kayak, and
other boat rentals, call the concession office at (906) 289-4210.

Porcupine Mountains State Park
Michigan's largest state park consists of some 60,000 acres

of mostly virgin timber. Over 90 miles of trails are available
to backpackers and hikers. Downhill skiing is available in winter.
Rustic cabins are available. To reserve a cabin, call (906) 885-5275.

Tahquamenon Falls State Park
One of the largest waterfalls east of the Mississippi is found
within this park's 40,000+ acres. Upper Tahquamenon Falls is some 50 feet
high, 200 feet across, and supports a flow that has been known to reach

50,000 gallons/second. The park phone is 906.492.3415.

Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy