Results for REGEXP_SUBSTR


21 to 80 of 316 results. Prev  Next
Results per page:  20 | 40 |  60 


OLAP Expression Syntax Reference

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 DML Reference

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

Database SQL Reference, 10g Release 2 (10.2)

REGEXP_SUBSTR

REGEXP_SUBSTRSyntax Description of the illustration regexp_substr.gif Purpose REGEXP_SUBSTR extends the … . 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', 'http://([[:alnum:]]+\\.?){3,4}/?')

SQL Language Reference, Release 18c

Single-Row Functions

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

Tables and Views for Engagement, 19C

Overiew

Name, ti.stripe_cd, to_number(NVL(REGEXP_SUBSTR(ti.path, '[^\\]+', 1, 10),categ)) LVL0_CAT_ID, to_number(NVL … (REGEXP_SUBSTR(ti.path, '[^\\]+', 1, 9),categ)) LVL1_CAT_ID, to_number(NVL(REGEXP_SUBSTR(ti.path … , '[^\\]+', 1, 8),categ)) LVL2_CAT_ID, to_number(NVL(REGEXP_SUBSTR(ti.path, '[^\\]+', 1, 7),categ … )) LVL3_CAT_ID,

SQL Language Reference, Release 19c

Pattern-matching Conditions

REGEXP_LIKE Condition-sensitive. See Also: LIKE Condition REGEXP_INSTR, REGEXP_REPLACE, and REGEXP_SUBSTR for functions that

Tables and Views for Engagement, 19B

Overiew

Name, ti.stripe_cd, to_number(NVL(REGEXP_SUBSTR(ti.path, '[^\\]+', 1, 10),categ)) LVL0_CAT_ID, to_number(NVL … (REGEXP_SUBSTR(ti.path, '[^\\]+', 1, 9),categ)) LVL1_CAT_ID, to_number(NVL(REGEXP_SUBSTR(ti.path … , '[^\\]+', 1, 8),categ)) LVL2_CAT_ID, to_number(NVL(REGEXP_SUBSTR(ti.path, '[^\\]+', 1, 7),categ … )) LVL3_CAT_ID,

SQL Language Reference, Release 19c

REGEXP_INSTR

REGEXP_INSTRREGEXP_SUBSTR REGEXP_REPLACE and REGEXP_LIKE Condition Appendix C in Oracle Database Globalization

OLAP DML Reference, Release 19c

OLAP DML Functions: L - Z

8.68 REGEXP_REPLACEthat substring with another substring. See Also: REGEXP_COUNT, REGEXP_INSTR, and REGEXP_SUBSTR

SQL Language Reference, Release 19c

REGEXP_REPLACE

Column 1 contains regular expression operators and column 2 describes Oracle Database support of each…detailed information. See Also: REPLACE REGEXP_INSTR, REGEXP_SUBSTR, and REGEXP_LIKE Condition Appendix C

Database Administrator's Guide, Release 19c

Scheduling Jobs with Oracle Scheduler

29.2.2.10 Techniques for External Jobs(50); BEGIN SELECT regexp_substr(additional_info,'job[_0-9]*') INTO log_id FROM

Tables and Views for Oracle Engagement Cloud, 19A

SVC_CATEGORIES_CF_V

Query, ti.stripe_cd, to_number(NVL(REGEXP_SUBSTR(ti.path, '[^\\]+', 1, 10),categ)) LVL0_CAT_ID, to_number(NVL … (REGEXP_SUBSTR(ti.path, '[^\\]+', 1, 9),categ)) LVL1_CAT_ID, to_number(NVL(REGEXP_SUBSTR(ti.path … , '[^\\]+', 1, 8),categ)) LVL2_CAT_ID, to_number(NVL(REGEXP_SUBSTR(ti.path, '[^\\]+', 1, 7),categ … )) LVL3_CAT_ID,

Tables and Views for HCM, 19C

Overview

HRQ_ALL_QSTN_RESPONSES_V, QSTNR_QUESTION_ID, ANSWER_TEXT, ANSWER_CLOB, regexp_substr (answer_list, '[^,;]+', 1, rn) ANSWER_ID FROM ( SELECT … BY level <= max_value ) WHERE regexp_substr (NVL(answer_list,'dummy'), '[^,]+', 1, rn) IS NOT NULL )

OLAP DML Reference, Release 19c

OLAP DML Functions: L - Z

8.67 REGEXP_INSTRinput character set. See Also: REGEXP_COUNT, REGEXP_REPLACE, and REGEXP_SUBSTR Return Value When the

SQL Language Reference, Release 18c

Pattern-matching Conditions

REGEXP_LIKE Condition-sensitive. See Also: LIKE Condition REGEXP_INSTR, REGEXP_REPLACE, and REGEXP_SUBSTR for functions that

SQL Language Reference, Release 19c

Table of Contents

Table of ContentsRATIO_TO_REPORT RAWTOHEX RAWTONHEX REF REFTOHEX REGEXP_COUNT REGEXP_INSTR REGEXP_REPLACE REGEXP_SUBSTR

Database Development Guide, Release 19c

Using Regular Expressions in Database Applications

Oracle SQL Support for Regular Expressions, '(.)', '\\1 ') REGEXP_SUBSTR Function that is like REGEXP_INSTR except that instead of returning … the pattern: REGEXP_SUBSTR('Oracle 2010', 'O r a c l e', 1, 1, 'x') Table 10-2 describes the pattern … only because the n option is specified: REGEXP_SUBSTR('a'||CHR(10)||'d', 'a.d', 1, 1, 'n') m Specifies … (described in Table

Tables and Views for HCM, 19B

Overview

HRQ_ALL_QSTN_RESPONSES_V, QSTNR_QUESTION_ID, ANSWER_TEXT, ANSWER_CLOB, regexp_substr (answer_list, '[^,;]+', 1, rn) ANSWER_ID FROM ( SELECT … BY level <= max_value ) WHERE regexp_substr (NVL(answer_list,'dummy'), '[^,]+', 1, rn) IS NOT NULL )

SecureFiles and Large Objects Developer's Guide, Release 19c

SQL Semantics and LOBs

CLOBs and NCLOBs Do Not Follow Session Collation Settingsand NVARCHAR2 values. REGEXP_LIKE REGEXP_REPLACE REGEXP_INSTR REGEXP_SUBSTR REGEXP_COUNT Note

SQL Language Reference, Release 19c

Oracle Support for Optional Features of SQL/Foundation

Table C-2 Oracle Support for Optional Features of SQL/Foundationspelling differences. F844, SUBSTRING_REGEX function Oracle's equivalent is REGEXP_SUBSTR. Oracle's pattern … , Regular expressions substring functions Oracle provides the REGEXP_SUBSTR function to perform

SQL Language Reference, Release 18c

REGEXP_INSTR

REGEXP_INSTRREGEXP_SUBSTR REGEXP_REPLACE and REGEXP_LIKE Condition Appendix C in Oracle Database Globalization

OLAP DML Reference, Release 19c

OLAP DML Functions: L - Z

match_parameterstatement REGEXP_SUBSTR('7 W 96th St, New York, New York', 'new york', 10, 2, 'i') starts searching at the … statement REGEXP_SUBSTR('parsley, sage, rosemary, thyme', ',[^,]+,', 1) matches the first substring

OLAP DML Reference, Release 18c

OLAP DML Functions: L - Z

source_charThe 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

SQL Language Reference, Release 18c

REGEXP_REPLACE

Column 1 contains regular expression operators and column 2 describes Oracle Database support of each…detailed information. See Also: REPLACE REGEXP_INSTR, REGEXP_SUBSTR, and REGEXP_LIKE Condition Appendix C

Database Administrator's Guide, Release 18c

Scheduling Jobs with Oracle Scheduler

29.2.2.10 Techniques for External Jobs(50); BEGIN SELECT regexp_substr(additional_info,'job[_0-9]*') INTO log_id FROM

Tables and Views for Oracle HCM Cloud, Release 12

HRQ_ALL_QSTN_RESPONSES_V

HRQ_ALL_QSTN_RESPONSES_V, QSTNR_QUESTION_ID, ANSWER_TEXT, ANSWER_CLOB, regexp_substr (answer_list, '[^,;]+', 1, rn) ANSWER_ID FROM ( SELECT … BY level <= max_value ) WHERE regexp_substr (NVL(answer_list,'dummy'), '[^,]+', 1, rn) IS NOT NULL )

Tables and Views for Oracle HCM Cloud, Release 9

HRQ_ALL_QSTN_RESPONSES_V

HRQ_ALL_QSTN_RESPONSES_V, QSTNR_RESPONSE_ID, QSTN_RESPONSE_ID, QSTNR_QUESTION_ID, ANSWER_TEXT, regexp_substr (answer_list … HRQ_QSTN_RESPONSES ) ) CONNECT BY level <= max_value ) WHERE regexp_substr (NVL(answer_list,'dummy'), '[^,]+', 1, rn) IS NOT NULL )

Tables and Views for Oracle HCM Cloud, 19A

HRQ_ALL_QSTN_RESPONSES_V

Query, QSTNR_QUESTION_ID, ANSWER_TEXT, ANSWER_CLOB, regexp_substr (answer_list, '[^,;]+', 1, rn) ANSWER_ID FROM ( SELECT … BY level <= max_value ) WHERE regexp_substr (NVL(answer_list,'dummy'), '[^,]+', 1, rn) IS NOT NULL )

OLAP Expression Syntax Reference, Release 19c

Row Functions

3.1 Row Functions in Alphabetical OrderREGEXP_INSTR REGEXP_REPLACE REGEXP_SUBSTR REMAINDER REPLACE ROUND (date) ROUND (number) ROWIDTOCHAR

OLAP DML Reference, Release 18c

OLAP DML Functions: L - Z

source_charthat substring with another substring. See Also: REGEXP_COUNT, REGEXP_INSTR, and REGEXP_SUBSTR

SQL Language Reference, Release 18c

Table of Contents

Table of ContentsRAWTONHEX REF REFTOHEX REGEXP_COUNT REGEXP_INSTR REGEXP_REPLACE REGEXP_SUBSTR REGR_ (Linear Regression

Database Development Guide, Release 18c

Using Regular Expressions in Database Applications

Oracle SQL and POSIX Regular Expression Standard, '(.)', '\\1 ') REGEXP_SUBSTR Function that is like REGEXP_INSTR except that instead of returning … the pattern: REGEXP_SUBSTR('Oracle 2010', 'O r a c l e', 1, 1, 'x') Table 10-2 describes the pattern … only because the n option is specified: REGEXP_SUBSTR('a'||CHR(10)||'d', 'a.d', 1, 1, 'n') m Specifies … (described in Table

OLAP DML Reference, Release 19c

OLAP DML Functions: A - K

7.2 Functions: Alphabetical ListingREGEXP_COUNT REGEXP_INSTR REGEXP_REPLACE REGEXP_SUBSTR REM REMAINDER REMBYTES REMCHARS REMCOLS

OLAP DML Reference, Release 19c

Changes in Previous Releases

D.1.1 Statements Added in Oracle Database 11g(11.2) REGEXP_INSTR function (11.2) REGEXP_REPLACE function (11.2) REGEXP_SUBSTR function (11.2

OLAP Expression Syntax Reference, Release 19c

Row Functions

3.2 Row Functions By CategoryNLSSORT REGEXP_REPLACE REGEXP_SUBSTR REPLACE RPAD RTRIM SOUNDEX SUBSTR TRANSLATE TRIM UPPER 3.2.3 NLS

OLAP DML Reference, Release 18c

OLAP DML Functions: L - Z

source_charinput character set. See Also: REGEXP_COUNT, REGEXP_REPLACE, and REGEXP_SUBSTR Return Value When the

SecureFiles and Large Objects Developer's Guide, Release 18c

SQL Semantics and LOBs

CLOBs and NCLOBs Do Not Follow Session Collation Settingsand NVARCHAR2 values. REGEXP_LIKE REGEXP_REPLACE REGEXP_INSTR REGEXP_SUBSTR REGEXP_COUNT Note

OLAP Expression Syntax Reference, Release 18c

Row Functions

REMAINDERREGEXP_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,

SQL Language Reference, Release 18c

Oracle Support for Optional Features of SQL/Foundation

Table C-2 Oracle Support for Optional Features of SQL/Foundationspelling differences. F844, SUBSTRING_REGEX function Oracle's equivalent is REGEXP_SUBSTR. Oracle's pattern … , Regular expressions substring functions Oracle provides the REGEXP_SUBSTR function to perform

OLAP DML Reference, Release 18c

OLAP DML Functions: L - Z

REMfollowing statement REGEXP_SUBSTR('7 W 96th St, New York, New York', 'new york', 10, 2, 'i') starts … quotes The following statement REGEXP_SUBSTR('parsley, sage, rosemary, thyme', ',[^,]+,', 1) matches the

OLAP DML Reference, Release 19c

OLAP DML Functions: A - K

7.3 Functions by CategoryREGEXP_COUNT REGEXP_INSTR REGEXP_REPLACE REGEXP_SUBSTR REMBYTES REMCHARS REMCOLS REMLINES REPLACE

MySQL, Release 5.5

Appendix C Indexes

regexp_stack_limit system variable, Server System VariablesREGEXP_SUBSTR(), Regular Expression Functions and Operators regexp_time_limit system variable, Server System Variables

Tables and Views for Oracle Sales Cloud, Release 13 (update 18C)

SVC_CATEGORIES_CF_V

Query, ti.stripe_cd, to_number(NVL(REGEXP_SUBSTR(ti.path, '[^\\]+', 1, 10),categ)) LVL0_CAT_ID, to_number(NVL … (REGEXP_SUBSTR(ti.path, '[^\\]+', 1, 9),categ)) LVL1_CAT_ID, to_number(NVL(REGEXP_SUBSTR(ti.path … , '[^\\]+', 1, 8),categ)) LVL2_CAT_ID, to_number(NVL(REGEXP_SUBSTR(ti.path, '[^\\]+', 1, 7),categ … )) LVL3_CAT_ID,

Tables and Views for Oracle Sales Cloud

SVC_CATEGORIES_CF_V

SVC_CATEGORIES_CF_V, ti.stripe_cd, to_number(NVL(REGEXP_SUBSTR(ti.path, '[^\\]+', 1, 10),categ)) LVL0_CAT_ID, to_number(NVL … (REGEXP_SUBSTR(ti.path, '[^\\]+', 1, 9),categ)) LVL1_CAT_ID, to_number(NVL(REGEXP_SUBSTR(ti.path … , '[^\\]+', 1, 8),categ)) LVL2_CAT_ID, to_number(NVL(REGEXP_SUBSTR(ti.path, '[^\\]+', 1, 7),categ … )) LVL3_CAT_ID,

Tables and Views

SVC_CATEGORIES_CF_V

Query, ti.stripe_cd, to_number(NVL(REGEXP_SUBSTR(ti.path, '[^\\]+', 1, 10),categ)) LVL0_CAT_ID, to_number(NVL … (REGEXP_SUBSTR(ti.path, '[^\\]+', 1, 9),categ)) LVL1_CAT_ID, to_number(NVL(REGEXP_SUBSTR(ti.path … , '[^\\]+', 1, 8),categ)) LVL2_CAT_ID, to_number(NVL(REGEXP_SUBSTR(ti.path, '[^\\]+', 1, 7),categ … )) LVL3_CAT_ID,

Tables and Views for Oracle Sales Cloud, Release 13 (update 18B)

SVC_CATEGORIES_CF_V

Query, ti.stripe_cd, to_number(NVL(REGEXP_SUBSTR(ti.path, '[^\\]+', 1, 10),categ)) LVL0_CAT_ID, to_number(NVL … (REGEXP_SUBSTR(ti.path, '[^\\]+', 1, 9),categ)) LVL1_CAT_ID, to_number(NVL(REGEXP_SUBSTR(ti.path … , '[^\\]+', 1, 8),categ)) LVL2_CAT_ID, to_number(NVL(REGEXP_SUBSTR(ti.path, '[^\\]+', 1, 7),categ … )) LVL3_CAT_ID,

Tables and Views for Oracle Sales Cloud

SVC_CATEGORIES_CF_V

SVC_CATEGORIES_CF_V(REGEXP_SUBSTR(ti.path, '[^\\]+', 1, 10),categ)) LVL0_CAT_ID, to_number(NVL(REGEXP_SUBSTR(ti.path … , '[^\\]+', 1, 9),categ)) LVL1_CAT_ID, to_number(NVL(REGEXP_SUBSTR(ti.path, '[^\\]+', 1, 8),categ … )) LVL2_CAT_ID, to_number(NVL(REGEXP_SUBSTR(ti.path, '[^\\]+', 1, 7),categ)) LVL3_CAT_ID, to_number(NVL … (REGEXP_SUBSTR(ti.path,

Tables and Views for Oracle Sales Cloud

SVC_CATEGORIES_CF_V

Query, ti.stripe_cd, to_number(NVL(REGEXP_SUBSTR(ti.path, '[^\\]+', 1, 10),categ)) LVL0_CAT_ID, to_number(NVL … (REGEXP_SUBSTR(ti.path, '[^\\]+', 1, 9),categ)) LVL1_CAT_ID, to_number(NVL(REGEXP_SUBSTR(ti.path … , '[^\\]+', 1, 8),categ)) LVL2_CAT_ID, to_number(NVL(REGEXP_SUBSTR(ti.path, '[^\\]+', 1, 7),categ … )) LVL3_CAT_ID,

OLAP Expression Syntax Reference, Release 18c

Row Functions

Row Functions By CategoryREGEXP_REPLACE REGEXP_SUBSTR REMAINDER REPLACE ROUND (date) ROUND (number) ROWIDTOCHAR ROWIDTONCHAR RPAD RTRIM

Text Application Developer's Guide, Release 19c

Using Oracle Text Name Search

12.2 Name Search Examples(REGEXP_SUBSTR(c1.PHONE, '\\d\\d\\d\\d($|\\s)'), ' '); dbms_lob.writeappend(tlob, length(phone), phone); end if

OLAP Expression Syntax Reference, Release 19c

Table of Contents

Table of Contents3.62 REGEXP_COUNT 3.63 REGEXP_REPLACE 3.64 REGEXP_INSTR 3.65 REGEXP_SUBSTR 3.66 REMAINDER 3.67

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

Single-Row Functions

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

Database SQL Language Reference

Single-Row Functions

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

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

Single-Row Functions

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

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

About SQL Functions

Character Functions Returning Character ValuesLTRIM NLS_INITCAP NLS_LOWER NLSSORT NLS_UPPER REGEXP_REPLACE REGEXP_SUBSTR REPLACE RPAD RTRIM SOUNDEX SUBSTR TRANSLATE TREAT TRIM UPPER

SecureFiles and Large Objects Developer's Guide, Release 19c

SQL Semantics and LOBs

SQL Functions and Operators Supported for Use with LOBsFunctions - Regular Expressions REGEXP_SUBSTR This function returns the actual substring matching

Oracle OLAP Java API Reference, Release 19c

FunctionDescriptorCatalog (Oracle OLAP Java API Reference)

Class FunctionDescriptorCatalogFunctionDescriptor REGEXP_SUBSTR A static constant FunctionDescriptor representing the function REGEXP_SUBSTR. static … REGEXP_REPLACE. REGEXP_SUBSTR public static final FunctionDescriptor REGEXP_SUBSTR A static constant … FunctionDescriptor representing the function REGEXP_SUBSTR. REPLACE public static

OLAP Expression Syntax Reference, Release 18c

Table of Contents

Table of ContentsPOWER RAWTOHEX REGEXP_COUNT REGEXP_REPLACE REGEXP_INSTR REGEXP_SUBSTR REMAINDER REPLACE ROUND (date

OLAP Expression Syntax Reference, Release 18c

Row Functions

ABSREGEXP_REPLACE REGEXP_SUBSTR REPLACE RPAD RTRIM SOUNDEX SUBSTR TRANSLATE TRIM UPPER NLS Character Functions

OLAP DML Reference, Release 18c

OLAP DML Functions: A - K

Functions by CategoryREGEXP_COUNT REGEXP_INSTR REGEXP_REPLACE REGEXP_SUBSTR REM REMAINDER REMBYTES REMCHARS REMCOLS





Was this page helpful?

Integrated Cloud Applications & Platform Services