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 REGEXP_SUBSTR


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


SQL Language Reference, Release 19c

REGEXP_SUBSTR

REGEXP_SUBSTRSyntax Description of the illustration regexp_substr.eps Purpose REGEXP_SUBSTR extends the … the collation determination rules, which define the collation REGEXP_SUBSTR uses to compare … returns the substring, including the leading and trailing commas. SELECT REGEXP_SUBSTR('500 Oracle … slash ( / ) or the end of the string. SELECT

SQL Language Reference, Release 18c

REGEXP_SUBSTR

REGEXP_SUBSTRSyntax Description of the illustration regexp_substr.eps Purpose REGEXP_SUBSTR extends the … the collation determination rules, which define the collation REGEXP_SUBSTR uses to compare … returns the substring, including the leading and trailing commas. SELECT REGEXP_SUBSTR('500 Oracle … slash ( / ) or the end of the string. SELECT

SQL Language Reference, Release 12.2

REGEXP_SUBSTR

REGEXP_SUBSTRSyntax Description of the illustration regexp_substr.eps Purpose REGEXP_SUBSTR extends the … the collation determination rules, which define the collation REGEXP_SUBSTR uses to compare … returns the substring, including the leading and trailing commas. SELECT REGEXP_SUBSTR('500 Oracle … slash ( / ) or the end of the string. SELECT

OLAP DML Reference, Release 19c

OLAP DML Functions: L - Z

8.69 REGEXP_SUBSTRThe REGEXP_SUBSTR function searches a string for a substring of a specified pattern and returns … Syntax REGEXP_SUBSTR( source_char, pattern [, position [, occurrence [, match_parameter ]]]) Parameters

OLAP Expression Syntax Reference, Release 19c

Row Functions

3.65 REGEXP_SUBSTRREGEXP_SUBSTR searches a string for a pattern and returns the matching string. Return Value CHAR … | NCHAR | VARCHAR2 | NVARCHAR Syntax REGEXP_SUBSTR(source_char, pattern [, position [, occurrence … default, it is not. x: Ignore whitespace characters. Examples REGEXP_SUBSTR('7 W 96th St, New York … a case-insensitive match. REGEXP_SUBSTR('parsley,

OLAP Expression Syntax Reference, Release 18c

Row Functions

REGEXP_SUBSTR) searches the string Mississippi for the third instance of the letter i, beginning the search at the first letter. It returns the value 8. REGEXP_SUBSTR

OLAP DML Reference, Release 18c

OLAP DML Functions: L - Z

REGEXP_SUBSTR', '( ){2,}', ' ') eliminates extra spaces and returns the following string 500 Oracle Parkway, Redwood Shores, CA REGEXP_SUBSTR

Database SQL Language Reference

REGEXP_SUBSTR

REGEXP_SUBSTRSyntax Description of the illustration regexp_substr.eps Purpose REGEXP_SUBSTR extends the … the collation determination rules, which define the collation REGEXP_SUBSTR uses to compare … returns the substring, including the leading and trailing commas. SELECT REGEXP_SUBSTR('500 Oracle … slash ( / ) or the end of the string. SELECT

Database SQL Language Reference, 12c Release 1 (12.1)

REGEXP_SUBSTR

REGEXP_SUBSTRSyntax Description of the illustration ''regexp_substr.gif'' Purpose REGEXP_SUBSTR extends the … . Oracle returns the substring, including the leading and trailing commas. SELECT REGEXP_SUBSTR('500 Oracle … slash ( / ) or the end of the string. SELECT REGEXP_SUBSTR('http://www.example.com/products', 'http … ://([[:alnum:]]+\\.?){3,4}/?')

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

REGEXP_SUBSTR

REGEXP_SUBSTRSyntax Description of the illustration regexp_substr.gif Purpose REGEXP_SUBSTR extends the … the substring, including the leading and trailing commas. SELECT REGEXP_SUBSTR('500 Oracle Parkway … ( / ) or the end of the string. SELECT REGEXP_SUBSTR('http://www.example.com/products', 'http … ://([[:alnum:]]+\\.?){3,4}/?') \"REGEXP_SUBSTR\"

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

REGEXP_SUBSTR

REGEXP_SUBSTRSyntax Description of the illustration ''regexp_substr.gif'' Purpose REGEXP_SUBSTR extends the … . Oracle returns the substring, including the leading and trailing commas. SELECT REGEXP_SUBSTR('500 Oracle … slash ( / ) or the end of the string. SELECT REGEXP_SUBSTR('http://www.example.com/products', 'http … ://([[:alnum:]]+\\.?){3,4}/?')

SQL Reference, 10g Release 1 (10.1)

REGEXP_SUBSTR

REGEXP_SUBSTRSyntax regexp_substr::= Description of the illustration regexp_substr.gif Purpose REGEXP_SUBSTR … . SELECT REGEXP_SUBSTR('500 Oracle Parkway, Redwood Shores, CA', ',[^,]+,') "REGEXPR_SUBSTR" FROM DUAL … between http:// and either a slash ( / ) or the end of the string. SELECT REGEXP_SUBSTR('http … ://www.oracle.com/products',

OLAP Expression Syntax Reference, 12c Release 1 (12.1)

Row Functions

REGEXP_SUBSTR| VARCHAR2 | NVARCHAR Syntax REGEXP_SUBSTR(source_char, pattern [, position [, occurrence [, match_parameter … is not. x: Ignore whitespace characters. Examples REGEXP_SUBSTR('7 W 96th St, New York, NEW YORK … -insensitive match. REGEXP_SUBSTR('parsley, sage, rosemary, thyme', 's[^,]+e', 1, 2) starts searching at

OLAP Expression Syntax Reference, 11g Release 2 (11.2)

REGEXP_SUBSTR

REGEXP_SUBSTR| VARCHAR2 | NVARCHAR Syntax REGEXP_SUBSTR(source_char, pattern [, position [, occurrence [, match_parameter … is not. x: Ignore whitespace characters. Examples REGEXP_SUBSTR('7 W 96th St, New York, NEW YORK … -insensitive match. REGEXP_SUBSTR('parsley, sage, rosemary, thyme', 's[^,]+e', 1, 2) starts searching at

Warehouse Builder User's Guide, 10g Release 2 (10.2)

Transformations

REGEXP_SUBSTR, Redwood Shores, CA','( ){ 2, }', ' ') FROM DUAL; REGEXP_REPLACE -------------------------------------- 500 Oracle Parkway, Redwood Shores, CA REGEXP_SUBSTR

OLAP DML Reference, 11g Release 2 (11.2)

REGEXP_SUBSTR

REGEXP_SUBSTRThe REGEXP_SUBSTR function searches a string for a substring of a specified pattern and returns … Syntax REGEXP_SUBSTR( source_char, pattern [, position [, occurrence [, match_parameter ]]]) Parameters

OLAP DML Reference, 12c Release 1 (12.1)

OLAP DML Functions: L - Z

REGEXP_SUBSTRThe REGEXP_SUBSTR function searches a string for a substring of a specified pattern and returns … Syntax REGEXP_SUBSTR( source_char, pattern [, position [, occurrence [, match_parameter ]]]) Parameters

Warehouse Builder Transformation Guide, 10g Release 2 (10.2)

Transformations

REGEXP_SUBSTRSyntax regexp_substr:=REGEXP_SUBSTR(source_string, pattern, position, occurance, match_parameter … ) Purpose REGEXP_SUBSTR extends the functionality of the SUBSTR function by letting you search a string … commas. SELECT REGEXP_SUBSTR('500 Oracle Parkway, Redwood Shores, CA',',[^,]+,')FROM DUAL … :// and either

SQL Language Reference, Release 19c

Single-Row Functions

Character Functions Returning Character ValuesLPAD LTRIM NCHR NLS_INITCAP NLS_LOWER NLS_UPPER NLSSORT REGEXP_REPLACE REGEXP_SUBSTR REPLACE RPAD

OLAP DML Reference, 11g Release 2 (11.2)

REGEXP_SUBSTR

source_charsubstring The following statement REGEXP_SUBSTR('7 W 96th St, New York, New York', 'new york', 10, 2 … in single quotes The following statement REGEXP_SUBSTR('parsley, sage, rosemary, thyme