|
Code Listing 1: Finding phone numbers in the park descriptions
SQL> SELECT park_name, description
2 FROM michigan_park
3 WHERE REGEXP_LIKE(description, '...-....');
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.
Muskallonge Lake State Park
A 217-acre park located on the site of an old lumber town, Deer Park.
Shower and toilet facilities are available, as are campsites with
electricity.
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.
|