Results for REGEXP_SUBSTR


101 to 160 of 361 results. Prev  Next
Results per page:  20 | 40 |  60 


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

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

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

OLAP DML Functions: A - K

7.3 Functions by CategoryREGEXP_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

Database Administrator's Guide, Release 12.2

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

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 )

Tables and Views for Oracle HCM Cloud

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 HCM

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 )

Tables and Views for Oracle HCM Cloud

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

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 )

Tables and Views for Oracle HCM Cloud

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 )

Tables and Views for Oracle HCM Cloud

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

HRQ_ALL_QSTN_RESPONSES_V

HRQ_ALL_QSTN_RESPONSES_V, regexp_substr (answer_list, '[^,;]+', 1, rn) ANSWER_ID FROM ( SELECT BUSINESS_GROUP_ID … regexp_substr (NVL(answer_list,'dummy'), '[^,]+', 1, rn) IS NOT NULL )

Tables and Views for HCM

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 )

Tables and Views for Oracle HCM Cloud

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 )

Tables and Views for Oracle HCM Cloud

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

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 DML Reference, 12c Release 1 (12.1)

OLAP DML Functions: L - Z

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

OLAP DML Reference, 11g Release 2 (11.2)

REGEXP_INSTR

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

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

Tables and Views for Oracle Supply Chain Management Cloud, 20B

Overview

EGP_EXPLOSIONS_V, To_Number(SUBSTR ( regexp_substr(sys_connect_by_path(DECODE(NVL(PRIOR bcb.obj_name,'EGO_ITEM

Database Globalization Support Guide, Release 20c

Linguistic Sorting and Matching

5.6 Performing Linguistic ComparisonsREGEXP_REPLACE Honors NLS_SORT Honors NLS_SORT Honors NLS_SORT REGEXP_SUBSTR Honors NLS_SORT Honors

Warehouse Builder Transformation Guide, 10g Release 2 (10.2)

Transformations

Character TransformationsNLS_LOWER NLS_UPPER REPLACE REGEXP_INSTR REGEXP_REPLACE REGEXP_SUBSTR RPAD RTRIM SOUNDEX SUBSTR, SUBSTR2

User's Guide and Reference, 10g Release 1 (10.1)

G Frequently Asked Questions About PL/SQL

How Can I Use Regular Expressions with PL/SQL?manipulate strings using the built-in functions REGEXP_INSTR, REGEXP_REPLACE, and REGEXP_SUBSTR. Oracle's

OLAP DML Reference, Release 12.2

OLAP DML Functions: L - Z

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

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 12.2

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

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

Database Development Guide

Using Regular Expressions in Database Applications

Oracle SQL Support for Regular Expressions… country_name: REGEXP_REPLACE(hr.countries.country_name, '(.)', '\\1 ') REGEXP_SUBSTR Function that … returns 'Oracle' because the x option ignores the spaces in the pattern: REGEXP_SUBSTR('Oracle 2010', 'O … : REGEXP_SUBSTR('a'||CHR(10)||'d', 'a.d', 1, 1, 'n') m Specifies multiline mode, where a newline character … invocation

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

Pattern-matching Conditions

REGEXP_LIKE ConditionREGEXP_SUBSTR for functions that provide regular expression support Examples The following query

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

REGEXP_REPLACE

REGEXP_REPLACE, REGEXP_SUBSTR, and REGEXP_LIKE Condition Examples The following example examines phone_number, looking for

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

REGEXP_REPLACE

REGEXP_REPLACE… Refer to REGEXP_COUNT for detailed information. See Also: REPLACE REGEXP_INSTR, REGEXP_SUBSTR, and

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

REGEXP_REPLACE

REGEXP_REPLACE… Refer to REGEXP_COUNT for detailed information. See Also: REPLACE REGEXP_INSTR, REGEXP_SUBSTR, and

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

Pattern-matching Conditions

REGEXP_LIKE Condition, and REGEXP_SUBSTR for functions that provide regular expression support Examples The following

Database SQL Language Reference

Pattern-matching Conditions

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

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

Pattern-matching Conditions

REGEXP_LIKE Condition, and REGEXP_SUBSTR for functions that provide regular expression support Examples The following

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

OLAP DML Reference, Release 20c

Table of Contents

Table of ContentsREGEXP_SUBSTR 8.70 REM 8.71 REMAINDER 8.72 REMBYTES 8.73 REMCHARS 8.74 REMCOLS 8.75 REMLINES 8.76

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

Warehouse Builder User's Guide, 10g Release 2 (10.2)

Transformations

RPADSyntax 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

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

OLAP DML Reference, Release 12.2

OLAP DML Functions: L - Z

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

OLAP DML Reference, 11g Release 2 (11.2)

What's New in the OLAP DML?

New SQL-Like FunctionsREGEXP_REPLACE REGEXP_SUBSTR REMAINDER REPLACE SOUNDEX TO_BINARY_DOUBLE TO_BINARY_FLOAT UPPER VSIZE

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

SQL Language Reference, Release 12.2

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

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 12.2

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

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

SQL Language Reference, Release 12.2

Table of Contents

Table of Contents7.177 REGEXP_COUNT 7.178 REGEXP_INSTR 7.179 REGEXP_REPLACE 7.180 REGEXP_SUBSTR 7.181 REGR_ (Linear


Was this page helpful?