September 2003
Intermediate to advanced
64 pages
1h 25m
English
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.
Read now
Unlock full access