22.2. General Discussion of Facet Restrictions
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).
22.2.1. pattern Constraining Facet
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 ...
Get XML Schema Complete Reference, The now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
