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 |