Example Data

Many of the example SQL statements in this book execute against the following table:

CREATE TABLE park (
    park_name NVARCHAR2 (40),
    park_phone NVARCHAR2 (15),
    country VARCHAR2 (2),
    description NCLOB
);

This table contains information on a variety of state, provincial, and national parks from around the world. Much of the information is in free-text form within the description column, making this table an ideal platform on which to demonstrate Oracle’s regular expression capabilities.

You can download a script to create the park table and populate it with data from http://oreilly.com/catalog/oracleregexpr.

Get Oracle Regular Expressions Pocket Reference now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.