Results for REGEXP_REPLACE


1 to 20 of 380 results. Prev  Next
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 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

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

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

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

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})',

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

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





Was this page helpful?

Integrated Cloud Applications & Platform Services