You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for regular expressions


1 to 20 of 1960 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database SQL Language Reference, 11g Release 2 (11.2)

Perl-influenced Extensions in Oracle Regular Expressions

Perl-influenced Extensions in Oracle Regular ExpressionsOracle Database regular expression functions and conditions accept a number of Perl-influenced

Database SQL Language Reference, 11g Release 2 (11.2)

Perl-influenced Extensions in Oracle Regular Expressions

Table D-3 Perl-influenced Operators in Oracle Regular ExpressionsOperator Description \\d A digit character. \\D A nondigit character. \\w A word character. \\W A nonword character. \\s A whitespace character. \\S A non-whitespace character. \\A Matches only at the beginning of a string, or before a newline character at the end of a string. \\Z Matches only at the end of a string. *? Matches the preceding pattern element 0 or more times (nongreedy). +? Matches

Database SQL Language Reference, 11g Release 2 (11.2)

Oracle Regular Expression Support

D Oracle Regular Expression SupportOracle's implementation of regular expressions conforms with the IEEE Portable Operating System … Syntax Regular Expression Operator Multilingual Enhancements Perl-influenced Extensions in Oracle Regular Expressions … Interface (POSIX) regular expression standard and to the Unicode Regular

Application Express SQL Workshop and Utilities Guide, 11g Release 2 (11.2)

Using SQL Scripts

Searching and Replacing Text or Regular Expressionsof the page. Use these fields to search for and replace text strings and JavaScript regularexpressions within a script. To exit Find mode, click Find again. Description of the illustration … Case Match Whole Words Match Regular Expression To exit Find mode, click Find.

Database Globalization Support Guide, 11g Release 2 (11.2)

Linguistic Sorting and String Searching

Examples: Regular ExpressionsThe following examples show regular expression matches. Example 5-12 Case-Insensitive Match Using … the NLS_SORT Value Case sensitivity in an Oracle Database regular expression match is determined at … Guide for more information about regular expression syntax Oracle Database SQL Language Reference for more information about REGEX SQL

Database Advanced Application Developer's Guide, 11g Release 2 (11.2)

Using Regular Expressions in Database Applications

Overview of Regular Expressions: http: https: ftp: ftps: Regular expressions are a powerful text-processing component of the … A regular expression specifies a search pattern, using metacharacters (which are, or belong to … pattern can be complex. For example, this regular expression matches any string that begins with … the preceding element,

Database Globalization Support Guide, 11g Release 2 (11.2)

Linguistic Sorting and String Searching

Equivalence Class '[= =]' in Regular ExpressionsEquivalence Class '[= =]' in R egular Expressions Oracle Database also supports equivalence classes

Database Globalization Support Guide, 11g Release 2 (11.2)

Linguistic Sorting and String Searching

Character Class '[: :]' in Regular ExpressionsIn English regular expressions, the range expression can be used to indicate a character class. For … example, [a-z] can be used to indicate any lowercase letter. However, in non-English regularexpressions, this approach is not accurate unless a is the first lowercase letter and z is the last

Database Advanced Application Developer's Guide, 11g Release 2 (11.2)

Using Regular Expressions in Database Applications

Using Regular Expressions in SQL Statements: ScenariosScenarios: Using a Constraint to Enforce a Phone Number Format Using Back References to Reposition Characters

Database Globalization Support Guide, 11g Release 2 (11.2)

Linguistic Sorting and String Searching

Character Range '[x-y]' in Regular Expressionslocale. Therefore, ranges in regular expressions are meant to be linguistic ranges, not byte value … According to the POSIX standard, a range in a regular expression includes all collation elements … expressions as specified by the NLS_SORT parameter to determine the collation elements covered by a

Database Advanced Application Developer's Guide, 11g Release 2 (11.2)

Using Regular Expressions in Database Applications

Oracle SQL Support for Regular ExpressionsOracle SQL support for regular expressions lets application developers implement complex pattern … server-side regular expressions to enforce constraints, you avoid duplicating validation logic on … multiple clients. Oracle SQL supports regular expressions with the pattern-matching condition

Database Advanced Application Developer's Guide, 11g Release 2 (11.2)

Using Regular Expressions in Database Applications

POSIX Operators in Oracle SQL Regular ExpressionsTable 3-3 summarizes the POSIX operators defined in the POSIX standard Extended Regular Expression

Database Globalization Support Guide, 11g Release 2 (11.2)

Linguistic Sorting and String Searching

Collation Element Delimiter '[. .]' in Regular Expressionsregular expression syntax does not allow the user to define ranges involving multicharacter collation … semantic error in the regular expression. For example, [.ab.] is considered invalid if ab is not a defined multicharacter collating element.

Database Advanced Application Developer's Guide, 11g Release 2 (11.2)

Using Regular Expressions in Database Applications

Operators in Oracle SQL Regular Expressionsexpressions. Caution: The interpretation of metacharacters differs between tools that support regularexpressions. If you are porting regular expressions from another environment to Oracle Database, ensure … Oracle SQL Regular Expressions Oracle SQL Multilingual Extensions

Database Advanced Application Developer's Guide, 11g Release 2 (11.2)

Using Regular Expressions in Database Applications

3 Using Regular Expressions in Database ApplicationsThis chapter describes regular expressions and explains how to use them in database applications … . Topics: Overview of Regular Expressions Oracle SQL Support for Regular Expressions Oracle SQL and … POSIX Regular Expression Standard Operators in Oracle SQL Regular

Database Globalization Support Guide, 11g Release 2 (11.2)

Linguistic Sorting and String Searching

SQL Regular Expressions in a Multilingual EnvironmentRegular expressions provide a powerful method of identifying patterns of strings within a body of … support regular expressions in Oracle Database. Traditional regular expression engines were designed … implementation of regular expressions in Oracle Database is based

Database Advanced Application Developer's Guide, 11g Release 2 (11.2)

Using Regular Expressions in Database Applications

Table 3-4 POSIX Operators and Multilingual Operator RelationshipsOperator POSIX BRE Syntax POSIX ERE Syntax Multilingual Enhancement \\ Yes Yes -- * Yes Yes -- + -- Yes -- ? -- Yes -- | -- Yes -- ^ Yes Yes Yes $ Yes Yes Yes. Yes Yes Yes [ ] Yes Yes Yes ( ) Yes Yes -- {m} Yes Yes -- {m,} Yes Yes -- {m,n} Yes Yes -- \\n Yes Yes Yes [..] Yes Yes Yes [::] Yes Yes Yes [==] Yes Yes Yes Multilingual data might have multibyte characters. Oracle Database lets you enter

Database Advanced Application Developer's Guide, 11g Release 2 (11.2)

Using Regular Expressions in Database Applications

Oracle SQL PERL-Influenced Extensions to POSIX Standardoperating system, whereas Oracle SQL regular expressions are based on the language-specific data of … Oracle SQL supports some commonly used PERL regular expression operators that are not included in … the database. In general, you cannot expect a regular expression involving locale data to produce the same results in

Database Advanced Application Developer's Guide, 11g Release 2 (11.2)

Using Regular Expressions in Database Applications

Table 3-7 Explanation of the Regular Expression Elements in Example 3-3Regular Expression Element Description ^ Matches the beginning of the string. $ Matches the end of

Database Advanced Application Developer's Guide, 11g Release 2 (11.2)

Using Regular Expressions in Database Applications

Table 3-6 Explanation of the Regular Expression Elements in Example 3-1Regular Expression Element Matches... ^ The beginning of the string. \\( A left parenthesis. The