Results for REGEXP_SUBSTR


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


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

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 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 DML Reference, Release 18c

Changes in Previous Releases

OLAP DML Statement Changes for Oracle Database 10g(11.2) REGEXP_SUBSTR function (11.2) REMAINDER function (11.0.0.0) REMOVE_CUBE_MODEL program (11.2

Text Application Developer's Guide, Release 18c

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

Database Globalization Support Guide, Release 19c

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

SQL Language Reference, Release 12.2

Table of Contents

Table of ContentsREGEXP_SUBSTR REGR_ (Linear Regression) Functions REMAINDER REPLACE ROUND (date) ROUND (number) ROW_NUMBER

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

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

Pattern-matching Conditions

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

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

SecureFiles and Large Objects Developer's Guide, Release 18c

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

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

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

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

SQL Language Quick Reference, Release 18c

SQL Functions

Syntax for SQL Functions[, replace_string [, position [, occurrence [, match_param ] ] ] ] ) REGEXP_SUBSTR REGEXP_SUBSTR

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

What's New in PL/SQL?

PL/SQL Features for Oracle Database 11g Release 1REGEXP_INSTR and REGEXP_SUBSTR have increased functionality. A new regular expression SQL function … descriptions of the REGEXP_INSTR, REGEXP_SUBSTR, and REGEXP_COUNT functions SIMPLE_INTEGER, SIMPLE_FLOAT, and

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

Tuning PL/SQL Applications for Performance

Avoiding CPU Overhead in PL/SQL Code, such as REGEXP_SUBSTR. You can search for regular expressions using the SQL operator REGEXP_LIKE. See … , REGEXP_REPLACE, and REGEXP_SUBSTR. Regular expression features use characters like '.', '*', '^', and

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

What's New in PL/SQL?

New PL/SQL Features for 11g Release 1 (11.1)regular expression built-in functions REGEXP_INSTR and REGEXP_SUBSTR have increased functionality. A … Database SQL Language Reference for detailed descriptions of the REGEXP_INSTR, REGEXP_SUBSTR, and

Database Development Guide, 12c Release 1 (12.1)

Using Regular Expressions in Database Applications

8.2 Oracle SQL Support for Regular Expressions… country_name: REGEXP_REPLACE(hr.countries.country_name, '(.)', '\\1 ') REGEXP_SUBSTR Function that is … 'Oracle' because the x option ignores the spaces in the pattern: REGEXP_SUBSTR('Oracle 2010', 'O r a

Database SQL Language Reference

REGEXP_INSTR

REGEXP_INSTRREGEXP_SUBSTR REGEXP_REPLACE and REGEXP_LIKE Condition Appendix C in Oracle Database Globalization

Database SQL Language Reference

REGEXP_REPLACE

REGEXP_REPLACEdetailed information. See Also: REPLACE REGEXP_INSTR, REGEXP_SUBSTR, and REGEXP_LIKE Condition Appendix C

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

REGEXP_INSTR

REGEXP_INSTRsubexpr is zero. See Also: INSTR and REGEXP_SUBSTR REGEXP_REPLACE and REGEXP_LIKE Condition Examples The

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

REGEXP_INSTR

REGEXP_INSTRsubexpr is zero. See Also: INSTR and REGEXP_SUBSTR REGEXP_REPLACE and REGEXP_LIKE Condition Examples The

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

REGEXP_INSTR

REGEXP_INSTR… See Also: INSTR and REGEXP_SUBSTR REGEXP_REPLACE and REGEXP_LIKE Condition Examples The following

OLAP DML Reference, Release 12.2

OLAP DML Functions: L - Z

match_parameter,}', ' ') eliminates extra spaces and returns the following string 500 Oracle Parkway, Redwood Shores, CA 8.69 REGEXP_SUBSTR

OLAP Expression Syntax Reference

Row Functions

3.1 Row Functions in Alphabetical OrderREGEXP_REPLACE REGEXP_SUBSTR REMAINDER REPLACE ROUND (date) ROUND (number) ROWIDTOCHAR ROWIDTONCHAR RPAD RTRIM

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

Row Functions

Row Functions in Alphabetical OrderREGEXP_REPLACE REGEXP_SUBSTR REMAINDER REPLACE ROUND (date) ROUND (number) ROWIDTOCHAR ROWIDTONCHAR RPAD RTRIM

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

Row Functions

Row Functions in Alphabetical OrderREGEXP_REPLACE REGEXP_SUBSTR REMAINDER REPLACE ROUND (date) ROUND (number) ROWIDTOCHAR ROWIDTONCHAR RPAD RTRIM

Application Developer's Guide - Fundamentals, 10g Release 1 (10.1)

12 Using Regular Expressions With Oracle Database

Oracle Database SQL Functions for Regular ExpressionsReference for syntax details on the REGEXP_INSTR function. REGEXP_SUBSTR This function returns the actual … substring matching the regular expression pattern you specify. See the Oracle Database SQL Reference for syntax details on the REGEXP_SUBSTR function.

OLAP DML Reference, 12c Release 1 (12.1)

OLAP DML Functions: L - Z

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

Java Example Code

hadoop.hive.table (Oracle NoSQL Database Examples)

Appendix A: Create and Populate 'rmvTable' with Example Data In order to run any of the example Hive…REGEXP_SUBSTR, or Oracle SQL JSON Operators such as JSON_QUERY and JSON_EXISTS (or a combination). For … ].*'); SQL> SELECT firstname,lastname,address,REGEXP_SUBSTR(VEHICLEINFO, '\\{([[:alnum:]\":,\\.]+){1,3 … }\\}',1,1) \"Primary make: GM\" FROM rmvTable WHERE REGEXP_LIKE (REGEXP_SUBSTR(VEHICLEINFO … ,REGEXP_SUBSTR(VEHICLEINFO,

Java Example Code

hadoop.hive.table (Oracle NoSQL Database Examples)

Appendix A: Create and Populate 'rmvTable' with Example Datacan employ either Oracle Regular Expression Functions such as REGEXP_LIKE and REGEXP_SUBSTR, or … firstname,lastname,address,REGEXP_SUBSTR(VEHICLEINFO, '\\{([[:alnum:]\":,\\.]+){1,3}\\}',1,1 … ) \"Primary make: GM\" FROM rmvTable WHERE REGEXP_LIKE (REGEXP_SUBSTR(VEHICLEINFO, '\\{([[:alnum … :]\":,\\.]+){1,3}\\}',1,1), '\"make\":\"GM\"');

Java Example Code, Release 19.3

hadoop.hive.table (Oracle NoSQL Database Examples)

Appendix A: Create and Populate 'rmvTable' with Example Datacan employ either Oracle Regular Expression Functions such as REGEXP_LIKE and REGEXP_SUBSTR, or … firstname,lastname,address,REGEXP_SUBSTR(VEHICLEINFO, '\\{([[:alnum:]\":,\\.]+){1,3}\\}',1,1 … ) \"Primary make: GM\" FROM rmvTable WHERE REGEXP_LIKE (REGEXP_SUBSTR(VEHICLEINFO, '\\{([[:alnum … :]\":,\\.]+){1,3}\\}',1,1), '\"make\":\"GM\"');

Java Example Code

hadoop.hive.table (Oracle NoSQL Database Examples)

Appendix A: Create and Populate 'rmvTable' with Example Data In order to run any of the example Hive…REGEXP_SUBSTR, or Oracle SQL JSON Operators such as JSON_QUERY and JSON_EXISTS (or a combination). For … ].*'); SQL> SELECT firstname,lastname,address,REGEXP_SUBSTR(VEHICLEINFO, '\\{([[:alnum:]\":,\\.]+){1,3 … }\\}',1,1) \"Primary make: GM\" FROM rmvTable WHERE REGEXP_LIKE (REGEXP_SUBSTR(VEHICLEINFO … ,REGEXP_SUBSTR(VEHICLEINFO,

NoSQL Database, Release 2 (12.1.2.1.24)

hadoop.hive.table (Oracle NoSQL Database Examples)

Appendix A: Create and Populate 'rmvTable' with Example DataRegular Expression Functions such as REGEXP_LIKE and REGEXP_SUBSTR, or Oracle SQL JSON Operators … ,REGEXP_SUBSTR(VEHICLEINFO, '\\{([[:alnum:]\":,\\.]+){1,3}\\}',1,1) \"Primary make: GM\" FROM rmvTable … WHERE REGEXP_LIKE (REGEXP_SUBSTR(VEHICLEINFO, '\\{([[:alnum:]\":,\\.]+){1,3}\\}',1,1), '\"make … \":\"GM\"'); SQL> SELECT firstname,lastname,address,REGEXP_SUBSTR(VEHICLEINFO,

Java Example Code

hadoop.hive.table (Oracle NoSQL Database Examples)

Appendix A: Create and Populate 'rmvTable' with Example Datacan employ either Oracle Regular Expression Functions such as REGEXP_LIKE and REGEXP_SUBSTR, or … firstname,lastname,address,REGEXP_SUBSTR(VEHICLEINFO, '\\{([[:alnum:]\":,\\.]+){1,3}\\}',1,1 … ) \"Primary make: GM\" FROM rmvTable WHERE REGEXP_LIKE (REGEXP_SUBSTR(VEHICLEINFO, '\\{([[:alnum … :]\":,\\.]+){1,3}\\}',1,1), '\"make\":\"GM\"');

Database Administrator's Guide, 11g Release 1 (11.1)

Using Jobs

Creating External Jobsselect regexp_substr(additional_info,'job[_0-9]*') into log_id from user_scheduler_job_run_details

MySQL, Release 5.5

12.5.2 Regular Expressions

Go To Previous Pagewith emoji and other 4-byte characters when REGEXP_SUBSTR() or a similar function begins searching … character data is misaligned. mysql> SELECT REGEXP_SUBSTR('周周周周', '.*', 2 … ); +----------------------------------------+ | REGEXP_SUBSTR('周周周周', '.*', 2) | +----------------------------------------+ | 周周周 … | +----------------------------------------+





Was this page helpful?

Integrated Cloud Applications & Platform Services