O'Reilly logo

Oracle Regular Expressions Pocket Reference by Peter Linsley, Jonathan Gennick

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required