How to use REGEXP_INSTR.
REGEXP_INSTR is used to get multiple values positions in a string.
For Example:
let say we need to find the position of (-) and (*) in single string.
SELECT REGEXP_INSTR (
'ABC-CDE&'
, '(-|&)'
)
FROM DUAL;
This will return you 4.
REGEXP_INSTR is used to get multiple values positions in a string.
For Example:
let say we need to find the position of (-) and (*) in single string.
SELECT REGEXP_INSTR (
'ABC-CDE&'
, '(-|&)'
)
FROM DUAL;
This will return you 4.
No comments:
Post a Comment