You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for REGEXP_REPLACE


1 to 20 of 358 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


SQL Language Reference, Release 19c

REGEXP_REPLACE

Column 1 contains regular expression operators and column 2 describes Oracle Database support of each…Syntax Description of the illustration regexp_replace.eps Purpose REGEXP_REPLACE extends the … the collation REGEXP_REPLACE uses to compare characters from source_char with characters from pattern … pattern xxx. xxx. xxxx. Oracle reformats this pattern with ( xxx ) xxx - xxxx. SELECT REGEXP_REPLACE … ') \"REGEXP_REPLACE\"

SQL Language Reference, Release 18c

REGEXP_REPLACE

Column 1 contains regular expression operators and column 2 describes Oracle Database support of each…Syntax Description of the illustration regexp_replace.eps Purpose REGEXP_REPLACE extends the … the collation REGEXP_REPLACE uses to compare characters from source_char with characters from pattern … pattern xxx. xxx. xxxx. Oracle reformats this pattern with ( xxx ) xxx - xxxx. SELECT REGEXP_REPLACE … ') \"REGEXP_REPLACE\"

SQL Language Reference, Release 12.2

REGEXP_REPLACE

Column 1 contains regular expression operators and column 2 describes Oracle Database support of each…Syntax Description of the illustration regexp_replace.eps Purpose REGEXP_REPLACE extends the … the collation REGEXP_REPLACE uses to compare characters from source_char with characters from pattern … pattern xxx. xxx. xxxx. Oracle reformats this pattern with ( xxx ) xxx - xxxx. SELECT REGEXP_REPLACE … ') \"REGEXP_REPLACE\"

OLAP DML Reference, Release 19c

OLAP DML Functions: L - Z

8.68 REGEXP_REPLACEThe REGEXP_REPLACE function searches a string for a substring with a specified pattern and replaces … Return Value VARCHAR2 Syntax REGEXP_REPLACE( source_char, pattern [, replace_string [, position [, occurrence [, match_parameter ]]]]) Parameters

OLAP Expression Syntax Reference, Release 19c

Row Functions

3.63 REGEXP_REPLACEREGEXP_REPLACE searches a string for a regular pattern and replaces it with another string. By … replaced with replace_string. Return Value CHAR | NCHAR | VARCHAR2 | NVARCHAR2 Syntax REGEXP_REPLACEREGEXP_REPLACE('500 Oracle Parkway, Redwood Shores, CA', '( ){2,}', ' ') eliminates extra spaces and returns the string 500 Oracle Parkway,

OLAP DML Reference, Release 18c

OLAP DML Functions: L - Z

REGEXP_REPLACEMississippi for the third instance of the letter i, beginning the search at the first letter. It returns the value 8. REGEXP_REPLACE

OLAP Expression Syntax Reference, Release 18c

Row Functions

REGEXP_REPLACE('Mississippi', 'i', 1) searches the string Mississippi for the letter i, beginning the search at the first letter. It returns the value 4. REGEXP_REPLACE

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

REGEXP_REPLACE

REGEXP_REPLACESyntax Description of the illustration ''regexp_replace.gif'' Purpose REGEXP_REPLACE extends the … xxx. xxx. xxxx. Oracle reformats this pattern with ( xxx ) xxx - xxxx. SELECT REGEXP_REPLACE … (phone_number, '([[:digit:]]{3})\\.([[:digit:]]{3})\\.([[:digit:]]{4})', '(\\1) \\2-\\3') \"REGEXP_REPLACE … \" FROM employees ORDER BY

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

REGEXP_REPLACE

REGEXP_REPLACESyntax Description of the illustration regexp_replace.gif Purpose REGEXP_REPLACE extends the … REGEXP_REPLACE(phone_number, '([[:digit:]]{3})\\.([[:digit:]]{3})\\.([[:digit:]]{4})', '(\\1) \\2-\\3 … ') \"REGEXP_REPLACE\" FROM employees ORDER BY \"REGEXP_REPLACE\"; REGEXP_REPLACE … after each non-

Database SQL Language Reference

REGEXP_REPLACE

REGEXP_REPLACESyntax Description of the illustration regexp_replace.eps Purpose REGEXP_REPLACE extends the … the collation REGEXP_REPLACE uses to compare characters from source_char with characters from pattern … pattern xxx. xxx. xxxx. Oracle reformats this pattern with ( xxx ) xxx - xxxx. SELECT REGEXP_REPLACE … ') \"REGEXP_REPLACE\"

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

REGEXP_REPLACE

REGEXP_REPLACESyntax Description of the illustration ''regexp_replace.gif'' Purpose REGEXP_REPLACE extends the … xxx. xxx. xxxx. Oracle reformats this pattern with ( xxx ) xxx - xxxx. SELECT REGEXP_REPLACE … (phone_number, '([[:digit:]]{3})\\.([[:digit:]]{3})\\.([[:digit:]]{4})', '(\\1) \\2-\\3') \"REGEXP_REPLACE … \" FROM employees ORDER BY

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

Transformations

REGEXP_REPLACE][[:alpha:]]{ 6 }', 3, 2, 1, 'i') FROM DUAL; REGEXP_INSTR------------28 REGEXP_REPLACE

OLAP DML Reference, 12c Release 1 (12.1)

OLAP DML Functions: L - Z

REGEXP_REPLACEThe REGEXP_REPLACE function searches a string for a substring with a specified pattern and replaces … Return Value VARCHAR2 Syntax REGEXP_REPLACE( source_char, pattern [, replace_string [, position [, occurrence [, match_parameter ]]]]) Parameters

OLAP DML Reference, 11g Release 2 (11.2)

REGEXP_REPLACE

REGEXP_REPLACEThe REGEXP_REPLACE function searches a string for a substring with a specified pattern and replaces … Return Value VARCHAR2 Syntax REGEXP_REPLACE( source_char, pattern [, replace_string [, position [, occurrence [, match_parameter ]]]]) Parameters

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

Transformations

REGEXP_REPLACESyntax regexp_replace:=REGEXP_REPLACE(source_string, pattern, replace_string, position, occurance … , match_parameter) Purpose REGEXP_REPLACE extends the functionality of the REPLACE function by letting … . Oracle reformats this pattern with (xxx) xxx-xxxx. SELECT REGEXP_REPLACE(phone_number, '([[:digit … :]]{3})\.([[:digit:]]{3})\.([[:digit:]]{4})',

SQL Reference, 10g Release 1 (10.1)

REGEXP_REPLACE

REGEXP_REPLACESyntax regexp_replace::= Description of the illustration regexp_replace.gif Purpose REGEXP_REPLACEREGEXP_REPLACE(phone_number, '([[:digit:]]{3})\.([[:digit:]]{3})\.([[:digit:]]{4})', '(\1) \2-\3 … ') "REGEXP_REPLACE" FROM employees; REGEXP_REPLACEREGEXP_REPLACE(country_name,

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

REGEXP_REPLACE

REGEXP_REPLACEreplace_string. Return Value CHAR | NCHAR | VARCHAR2 | NVARCHAR2 Syntax REGEXP_REPLACE(source_char, pattern … character). By default, it is not. x: Ignore whitespace characters. Example REGEXP_REPLACE('500

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

Row Functions

REGEXP_REPLACEreplace_string. Return Value CHAR | NCHAR | VARCHAR2 | NVARCHAR2 Syntax REGEXP_REPLACE(source_char, pattern … character). By default, it is not. x: Ignore whitespace characters. Example REGEXP_REPLACE('500

SQL Language Reference, Release 19c

Single-Row Functions

Character Functions Returning Character ValuesLPAD LTRIM NCHR NLS_INITCAP NLS_LOWER NLS_UPPER NLSSORT REGEXP_REPLACE REGEXP_SUBSTR REPLACE RPAD

OLAP DML Reference, 11g Release 2 (11.2)

REGEXP_REPLACE

source_charfollowing statement REGEXP_REPLACE('500 Oracle Parkway, Redwood Shores, CA', '( ){2,}', ' ') eliminates