Results for REGEXP_SUBSTR


61 to 80 of 357 results. Prev  Next
Results per page:   20  | 40 | 60


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

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


Was this page helpful?