September 2002
Intermediate to advanced
1008 pages
22h 3m
English
This section details the general design issues and possible implementations of facet restrictions that vary little with respect to the XML Schema datatype. Each of the constraining facets can be implemented as either table check constraints or triggers (detailed in Section 22.4 later in this chapter).
pattern constraints, in general, cannot be represented in SQL or PL/SQL. SQL has a built-in operator for single-character and multiple-character wildcards. In addition, SQL has functions that can be used to determine whether some patterns have been violated. You can add more general mechanisms by using Java stored procedures.
SQL has the LIKE operator that can be ...
Read now
Unlock full access