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 1641 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database SQL Language Reference, 11g Release 1 (11.1)

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 1 (11.1)

Perl-influenced Extensions in Oracle Regular Expressions

Table C-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 1 (11.1)

Oracle Regular Expression Support

C 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

Database Globalization Support Guide, 11g Release 1 (11.1)

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 … - Fundamentals for more information about regular expression syntax Oracle Database SQL Reference for more information about REGEX SQL

Database Advanced Application Developer's Guide, 11g Release 1 (11.1)

Using Regular Expressions in Database Applications

Overview of Regular ExpressionsTopics: What Are Regular Expressions? How Are Regular Expressions Useful? Oracle Database … Implementation of Regular Expressions Oracle Database Support for the POSIX Regular Expression Standard

Database Advanced Application Developer's Guide, 11g Release 1 (11.1)

Using Regular Expressions in Database Applications

What Are Regular Expressions?Regular expressions enable you to search for patterns in string data by using standardized syntax … conventions. You specify a regular expression through the following types of characters … you are searching A regular expression can specify complex patterns of character sequences. For … example, the following

Database Advanced Application Developer's Guide, 11g Release 1 (11.1)

Using Regular Expressions in Database Applications

Metacharacters in Regular ExpressionsExpressions Multilingual Extensions to POSIX Regular Expression Standard PERL-Influenced Extensions to POSIX Regular Expression Standard … This section contains the following topics: POSIX Metacharacters in Oracle Database Regular

Database Globalization Support Guide, 11g Release 1 (11.1)

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 Globalization Support Guide, 11g Release 1 (11.1)

Linguistic Sorting and String Searching

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

Database Advanced Application Developer's Guide, 11g Release 1 (11.1)

Using Regular Expressions in Database Applications

How Are Regular Expressions Useful?Regular expressions are a powerful text processing component of programming languages such as PERL … into a scalar variable as a single string, and then use regular expressions to search for URLs in the … functionality. Oracle Database support of regular expressions enables developers

Database Advanced Application Developer's Guide, 11g Release 1 (11.1)

Using Regular Expressions in Database Applications

Oracle Database Implementation of Regular Expressions… By default, regular expressions must be enclosed in single quotes. If your regular expression … Oracle Database implements regular expression support with a set of Oracle Database SQL functions … VARCHAR2 (but not LONG ). Table 4-1 describes the regular expression functions and conditions

Database Advanced Application Developer's Guide, 11g Release 1 (11.1)

Using Regular Expressions in Database Applications

Using Regular Expressions in SQL Statements: ScenariosThis section contains the following scenarios: Using a Constraint to Enforce a Phone Number Format Using Back References to Reposition Characters

Database Globalization Support Guide, 11g Release 1 (11.1)

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 1 (11.1)

Using Regular Expressions in Database Applications

4 Using Regular Expressions in Database ApplicationsThis chapter explains how to use regular expressions in database applications. Topics: Overview of … Regular Expressions Metacharacters in Regular Expressions Using Regular Expressions in SQL … SQL functions for regular expressions

Database Globalization Support Guide, 11g Release 1 (11.1)

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 10 g. Traditional regular expression engines were … implementation of regular expressions in Oracle Database is based on

Database Globalization Support Guide, 11g Release 1 (11.1)

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 Application Express User's Guide, 11g Release 1 (11.1)

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 Advanced Application Developer's Guide, 11g Release 1 (11.1)

Using Regular Expressions in Database Applications

POSIX Metacharacters in Oracle Database Regular ExpressionsTable 4-2 lists the list of metacharacters supported for use in regular expressions passed to SQL … Metacharacters in Oracle Database Regular Expressions Syntax Operator Name Description Example. Any … classes is supported. Note: In English regular expressions, range expressions

Database Advanced Application Developer's Guide, 11g Release 1 (11.1)

Using Regular Expressions in Database Applications

Oracle Database Support for the POSIX Regular Expression StandardOracle Database implementation of regular expressions conforms to the following standards: IEEE … \" modifier, and so on. Oracle Database supports a set of common metacharacters used in regular expressionsRegular Expressions. Note: The interpretation of metacharacters differs between

Database Advanced Application Developer's Guide, 11g Release 1 (11.1)

Using Regular Expressions in Database Applications

Operator 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