Results for REGEXP_SUBSTR


41 to 100 of 326 results. Prev  Next
Results per page:  20 | 40 |  60 


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

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

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…, 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 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 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 )

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

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

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

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

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

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

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

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

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

SQL Language Reference, Release 12.2

REGEXP_INSTR

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

Database Development Guide, 12c Release 1 (12.1)

Using Regular Expressions in Database Applications

Table 8-2 Pattern-Matching Options for Oracle SQL Pattern-Matching Condition and Functionsstring and search pattern match only because the n option is specified: REGEXP_SUBSTR('a'||CHR(10 … : REGEXP_SUBSTR('ab'||CHR(10)||'ac', '^a.', 1, 2, 'm') x Ignores whitespace characters in the search pattern … . By default, whitespace characters match themselves. This function invocation returns abcd: REGEXP_SUBSTR('abcd', 'a b c d',

SQL Language Quick Reference, Release 19c

SQL Functions

Syntax for SQL Functions] ] ] ] ) REGEXP_SUBSTR REGEXP_SUBSTR ( source_char, pattern [, position [, occurrence [, match_param [, subexpr

OLAP Expression Syntax Reference

Row Functions

3.2.2 Character Functions That Return CharactersLTRIM NLS_CHARSET_NAME NLS_INITCAP NLS_LOWER NLS_UPPER NLSSORT REGEXP_REPLACE REGEXP_SUBSTR REPLACE RPAD RTRIM SOUNDEX SUBSTR TRANSLATE TRIM UPPER

OLAP DML Reference, 11g Release 2 (11.2)

REGEXP_REPLACE

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

OLAP DML Reference, 12c Release 1 (12.1)

OLAP DML Functions: L - Z

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

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

Row Functions

Character Functions That Return CharactersLTRIM NLS_CHARSET_NAME NLS_INITCAP NLS_LOWER NLS_UPPER NLSSORT REGEXP_REPLACE REGEXP_SUBSTR REPLACE RPAD RTRIM SOUNDEX SUBSTR TRANSLATE TRIM UPPER

OLAP DML Reference

OLAP DML Functions: L - Z

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

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

Row Functions

Character Functions That Return CharactersLTRIM NLS_CHARSET_NAME NLS_INITCAP NLS_LOWER NLS_UPPER NLSSORT REGEXP_REPLACE REGEXP_SUBSTR REPLACE RPAD RTRIM SOUNDEX SUBSTR TRANSLATE TRIM UPPER

OLAP DML Reference, Release 12.2

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 12.2

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

OLAP DML Reference, Release 18c

OLAP DML Functions: A - K

ABSREGEXP_COUNT REGEXP_INSTR REGEXP_REPLACE REGEXP_SUBSTR REMBYTES REMCHARS REMCOLS REMLINES REPLACE

Database Administrator's Guide

Scheduling Jobs with Oracle Scheduler

External jobs run external executables. An external executable is an operating system executable that…output DECLARE my_clob clob; log_id varchar2(50); BEGIN SELECT regexp_substr(additional_info,'job[_0-9

Database Administrator's Guide, 12c Release 1 (12.1)

Scheduling Jobs with Oracle Scheduler

External jobs run external executables. An external executable is an operating system executable that…output DECLARE my_clob clob; log_id varchar2(50); BEGIN SELECT regexp_substr(additional_info,'job[_0-9


Was this page helpful?