Results for REGEXP_SUBSTR


1 to 20 of 316 results. Prev  Next
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





Was this page helpful?

Integrated Cloud Applications & Platform Services