Results for REGEXP_SUBSTR


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


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





Was this page helpful?

Integrated Cloud Applications & Platform Services