Results for REGEXP_SUBSTR


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


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

SQL Language Reference, Release 20c

Single-Row Functions

7.2.2 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

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

Tables and Views for CX Sales and B2B Service, 20A

Overview

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,

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 19c

Single-Row Functions

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

SQL Language Reference, Release 20c

Pattern-matching Conditions

6.7.2 REGEXP_LIKE Condition… See Also: LIKE Condition REGEXP_INSTR, REGEXP_REPLACE, and REGEXP_SUBSTR for functions that provide

Tables and Views for Engagement, 19D

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 20c

REGEXP_INSTR

REGEXP_INSTRsubexpr is zero. See Also: INSTR and REGEXP_SUBSTR REGEXP_REPLACE and REGEXP_LIKE Condition Appendix C

OLAP DML Reference, Release 20c

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 20c

REGEXP_REPLACE

Column 1 contains regular expression operators and column 2 describes Oracle Database support of each…REGEXP_COUNT. Refer to REGEXP_COUNT for detailed information. See Also: REPLACE REGEXP_INSTR, REGEXP_SUBSTR

Database Administrator's Guide, Release 20c

Scheduling Jobs with Oracle Scheduler

30.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 HCM, 20A

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 20c

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 19c

Pattern-matching Conditions

6.7.2 REGEXP_LIKE Condition… See Also: LIKE Condition REGEXP_INSTR, REGEXP_REPLACE, and REGEXP_SUBSTR for functions that provide

Database Development Guide, Release 20c

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, 19D

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 20c

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 20c

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 19c

REGEXP_INSTR

REGEXP_INSTRsubexpr is zero. See Also: INSTR and REGEXP_SUBSTR REGEXP_REPLACE and REGEXP_LIKE Condition Appendix C

OLAP DML Reference, Release 20c

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

SQL Language Reference, Release 20c

Table of Contents

Table of ContentsREGEXP_INSTR 7.192 REGEXP_REPLACE 7.193 REGEXP_SUBSTR 7.194 REGR_ (Linear Regression) Functions 7.195

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…, REGEXP_SUBSTR, and REGEXP_LIKE Condition Appendix C in Oracle Database Globalization Support Guide for the

Tables and Views for HCM, 20A

Overview

HWM_INTERACT_SET_QSNR_PCPT_V(RTRIM ( REGEXP_SUBSTR(Qpart.SUBJECT_ID, 'SRC', 1,1), '>' ), 'SRC', 1,1), '>' ), 'QID', 1,1

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

Database Administrator's Guide, Release 20c

Appendixes

Blockchain Tables ReferenceREGEXP_REPLACE(REGEXP_SUBSTR(DUMP(bank_name, 16), '[^ ]+',1, 3), ',', '') \"Data Value\" FROM

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 )

SQL Language Reference, Release 12.2

Single-Row Functions

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

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

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

OLAP Expression Syntax Reference, Release 20c

Row Functions

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

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, 19D

Overview

HWM_INTERACT_SET_QSNR_PCPT_V, Qresp.SUBMITTED_DATE_TIME AS SUBMITTED_DATE_TIME_RESP, Ltrim (RTRIM ( REGEXP_SUBSTR(Qpart.SUBJECT_ID, 'SRC

OLAP DML Reference, Release 20c

OLAP DML Functions: A - K

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

OLAP Expression Syntax Reference, Release 20c

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 20c

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

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

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 20c

OLAP DML Functions: A - K

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

SQL Language Reference, Release 19c

Table of Contents

Table of Contents7.180 REGEXP_COUNT 7.181 REGEXP_INSTR 7.182 REGEXP_REPLACE 7.183 REGEXP_SUBSTR 7.184 REGR_ (Linear

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

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 CX Sales and B2B Service, 20B

Overview

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,

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

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 Engagement

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,

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

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,

Tables and Views for Engagement

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,

Text Application Developer's Guide, Release 20c

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 20c

Table of Contents

Table of ContentsREGEXP_COUNT 3.63 REGEXP_REPLACE 3.64 REGEXP_INSTR 3.65 REGEXP_SUBSTR 3.66 REMAINDER 3.67 REPLACE 3.68 ROUND

SQL Language Reference, Release 20c

SELECT

Table 19-1 Row Pattern Elements, position pls_integer) return varchar2 SQL_MACRO(Scalar) is begin return q'{ regexp_substr(replace

SQL Language Reference, Release 18c

Pattern-matching Conditions

REGEXP_LIKE Condition… See Also: LIKE Condition REGEXP_INSTR, REGEXP_REPLACE, and REGEXP_SUBSTR for functions that provide

SQL Language Reference, Release 12.2

Pattern-matching Conditions

6.7.2 REGEXP_LIKE Condition… See Also: LIKE Condition REGEXP_INSTR, REGEXP_REPLACE, and REGEXP_SUBSTR for functions that provide


Was this page helpful?