How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
Perl-influenced Extensions in Oracle Regular Expressions → Oracle Database regular expression functions and conditions accept a number of Perl-influenced
Table D-3 Perl-influenced Operators in Oracle Regular Expressions → Operator 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
D Oracle Regular Expression Support → Oracle'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
Expressions → An 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
PL/SQL Features for Oracle Database 11g Release 1 → implementation 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
CASE Expressions → expressions 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
BOOLEAN Expressions → expressions: 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
CURSOR Expressions → function that accepts a cursor variable parameter (see \"Passing CURSOR Expressions to Pipelined … Database SQL Language Reference for more information about CURSOR expressions, including restrictions
Examples: Regular Expressions → The 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
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,
Equivalence Class '[= =]' in Regular Expressions → Equivalence Class '[= =]' in R egular Expressions Oracle Database also supports equivalence classes
Character Class '[: :]' in Regular Expressions → In 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 regular … expressions, this approach is not accurate unless a is the first lowercase letter and z is the last
Using Regular Expressions in SQL Statements: Scenarios → Scenarios: Using a Constraint to Enforce a Phone Number Format Using Back References to Reposition Characters
Character Range '[x-y]' in Regular Expressions → locale. 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
Oracle SQL Support for Regular Expressions → Oracle 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
POSIX Operators in Oracle SQL Regular Expressions → Table 3-3 summarizes the POSIX operators defined in the POSIX standard Extended Regular Expression
Collation Element Delimiter '[. .]' in Regular Expressions → regular 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.
Operators in Oracle SQL Regular Expressions → expressions. Caution: The interpretation of metacharacters differs between tools that support regular … expressions. If you are porting regular expressions from another environment to Oracle Database, ensure … Oracle SQL Regular Expressions Oracle SQL Multilingual Extensions
3 Using Regular Expressions in Database Applications → This 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