By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| BANNER | BANNER_FULL | BANNER_LEGACY | CON_ID |
|---|---|---|---|
| Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release | Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release Version 23.2.0.0.0 |
Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release | 0 |
| OBJECT_NAME | POSITION | ARGUMENT_NAME | IN_OUT | DATA_TYPE |
|---|---|---|---|---|
| REGEXP_COUNT | 0 | null | OUT | BINARY_INTEGER |
| REGEXP_COUNT | 1 | SRCSTR | IN | VARCHAR2 |
| REGEXP_COUNT | 2 | PATTERN | IN | VARCHAR2 |
| REGEXP_COUNT | 3 | POSITION | IN | BINARY_INTEGER |
| REGEXP_COUNT | 4 | MODIFIER | IN | VARCHAR2 |
| REGEXP_COUNT | 0 | null | OUT | NUMBER |
| REGEXP_COUNT | 1 | SRCSTR | IN | CLOB |
| REGEXP_COUNT | 2 | PATTERN | IN | VARCHAR2 |
| REGEXP_COUNT | 3 | POSITION | IN | NUMBER |
| REGEXP_COUNT | 4 | MODIFIER | IN | VARCHAR2 |
| REGEXP_INSTR | 0 | null | OUT | BINARY_INTEGER |
| REGEXP_INSTR | 1 | SRCSTR | IN | VARCHAR2 |
| REGEXP_INSTR | 2 | PATTERN | IN | VARCHAR2 |
| REGEXP_INSTR | 3 | POSITION | IN | BINARY_INTEGER |
| REGEXP_INSTR | 4 | OCCURRENCE | IN | BINARY_INTEGER |
| REGEXP_INSTR | 5 | RETURNPARAM | IN | BINARY_INTEGER |
| REGEXP_INSTR | 6 | MODIFIER | IN | VARCHAR2 |
| REGEXP_INSTR | 7 | SUBEXPRESSION | IN | BINARY_INTEGER |
| REGEXP_INSTR | 0 | null | OUT | NUMBER |
| REGEXP_INSTR | 1 | SRCSTR | IN | CLOB |
| REGEXP_INSTR | 2 | PATTERN | IN | VARCHAR2 |
| REGEXP_INSTR | 3 | POSITION | IN | NUMBER |
| REGEXP_INSTR | 4 | OCCURRENCE | IN | NUMBER |
| REGEXP_INSTR | 5 | RETURNPARAM | IN | BINARY_INTEGER |
| REGEXP_INSTR | 6 | MODIFIER | IN | VARCHAR2 |
| REGEXP_INSTR | 7 | SUBEXPRESSION | IN | BINARY_INTEGER |
| REGEXP_LIKE | 0 | null | OUT | BOOLEAN |
| REGEXP_LIKE | 1 | SRCSTR | IN | VARCHAR2 |
| REGEXP_LIKE | 2 | PATTERN | IN | VARCHAR2 |
| REGEXP_LIKE | 3 | MODIFIER | IN | VARCHAR2 |
| REGEXP_LIKE | 0 | null | OUT | BOOLEAN |
| REGEXP_LIKE | 1 | SRCSTR | IN | CLOB |
| REGEXP_LIKE | 2 | PATTERN | IN | VARCHAR2 |
| REGEXP_LIKE | 3 | MODIFIER | IN | VARCHAR2 |
| REGEXP_REPLACE | 0 | null | OUT | VARCHAR2 |
| REGEXP_REPLACE | 1 | SRCSTR | IN | VARCHAR2 |
| REGEXP_REPLACE | 2 | PATTERN | IN | VARCHAR2 |
| REGEXP_REPLACE | 3 | REPLACESTR | IN | VARCHAR2 |
| REGEXP_REPLACE | 4 | POSITION | IN | BINARY_INTEGER |
| REGEXP_REPLACE | 5 | OCCURRENCE | IN | BINARY_INTEGER |
| REGEXP_REPLACE | 6 | MODIFIER | IN | VARCHAR2 |
| REGEXP_REPLACE | 0 | null | OUT | CLOB |
| REGEXP_REPLACE | 1 | SRCSTR | IN | CLOB |
| REGEXP_REPLACE | 2 | PATTERN | IN | VARCHAR2 |
| REGEXP_REPLACE | 3 | REPLACESTR | IN | CLOB |
| REGEXP_REPLACE | 4 | POSITION | IN | NUMBER |
| REGEXP_REPLACE | 5 | OCCURRENCE | IN | NUMBER |
| REGEXP_REPLACE | 6 | MODIFIER | IN | VARCHAR2 |
| REGEXP_REPLACE | 0 | null | OUT | CLOB |
| REGEXP_REPLACE | 1 | SRCSTR | IN | CLOB |
| REGEXP_REPLACE | 2 | PATTERN | IN | VARCHAR2 |
| REGEXP_REPLACE | 3 | REPLACESTR | IN | VARCHAR2 |
| REGEXP_REPLACE | 4 | POSITION | IN | NUMBER |
| REGEXP_REPLACE | 5 | OCCURRENCE | IN | NUMBER |
| REGEXP_REPLACE | 6 | MODIFIER | IN | VARCHAR2 |
| REGEXP_SUBSTR | 0 | null | OUT | VARCHAR2 |
| REGEXP_SUBSTR | 1 | SRCSTR | IN | VARCHAR2 |
| REGEXP_SUBSTR | 2 | PATTERN | IN | VARCHAR2 |
| REGEXP_SUBSTR | 3 | POSITION | IN | BINARY_INTEGER |
| REGEXP_SUBSTR | 4 | OCCURRENCE | IN | BINARY_INTEGER |
| REGEXP_SUBSTR | 5 | MODIFIER | IN | VARCHAR2 |
| REGEXP_SUBSTR | 6 | SUBEXPRESSION | IN | BINARY_INTEGER |
| REGEXP_SUBSTR | 0 | null | OUT | CLOB |
| REGEXP_SUBSTR | 1 | SRCSTR | IN | CLOB |
| REGEXP_SUBSTR | 2 | PATTERN | IN | VARCHAR2 |
| REGEXP_SUBSTR | 3 | POSITION | IN | NUMBER |
| REGEXP_SUBSTR | 4 | OCCURRENCE | IN | NUMBER |
| REGEXP_SUBSTR | 5 | MODIFIER | IN | VARCHAR2 |
| REGEXP_SUBSTR | 6 | SUBEXPRESSION | IN | BINARY_INTEGER |