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 PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Language Fundamentals

ExpressionsAn expression always returns a single value. The simplest expressions, in order of increasing … . Therefore, expressions can be arbitrarily complex. For expression syntax, see \"Expression\". The data … Evaluation Comparison Operators BOOLEAN Expressions CASE Expressions SQL Functions in PL/SQL Expressions

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

What's New in PL/SQL?

PL/SQL Features for Oracle Database 11g Release 1implementation of regular expressions Oracle Database SQL Language Reference for detailed … The PL/SQL features for Oracle Database 11 g Release 1 are: Enhancements to Regular Expression SQL … PL/SQL Expressions Dynamic SQL Enhancements Named and Mixed Notation in PL/SQL Subprogram … Directly Enhancements to Regular

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

PL/SQL Language Fundamentals

CASE Expressionsexpressions are not evaluated. If no selector_value matches selector, the CASE expression returns … result for which boolean_expression is TRUE. Remaining expressions are not evaluated. If no

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

PL/SQL Language Fundamentals

BOOLEAN Expressionsexpressions: NOT boolean_expression boolean_expression relational_operator boolean_expression … BOOLEAN expressions as conditions in control statements (explained in Chapter 4, \"PL/SQL Control … are equivalent. Example 2-49 Equivalent BOOLEAN Expressions DECLARE done BOOLEAN; BEGIN -- These

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

PL/SQL Static SQL

CURSOR Expressionsfunction that accepts a cursor variable parameter (see \"Passing CURSOR Expressions to Pipelined … Database SQL Language Reference for more information about CURSOR expressions, including restrictions

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