| | | Returns the position of the second occurrence that matches the letter 'o' starting at position 10 |
|
|
SQL>
SQL>
SQL> -- Returns the position of the second occurrence that matches the letter o starting at position 10 using REGEXP_INSTR():
SQL>
SQL> SELECT REGEXP_INSTR('www.java2s.com Oracle', 'o', 10, 2) AS result FROM dual;
RESULT
----------
0
SQL>
SQL>
|
|
|
|
| Related examples in the same category |
| 1. | regexp_instr function summary | | | | 2. | Simple demo for REGEXP_INSTR | | | | 3. | regexp_instr (string, pattern, position, occurence, return-option) | | | | 4. | Return-option is set to 1 to indicate the end of the found pattern | | | | 5. | regexp_instr (string, pattern, position, occurence, return-option, parameters): c: to match case sensitively | | | | 6. | 'i': to match case insensitively | | | | 7. | regexp_instr (string, pattern) | | | | 8. | The simplest regular expression matches letters, letter for letter | | | | 9. | REGEXP_INSTR function in where clause | | | | 10. | Apecify any series of letters and find matches, just like INSTR | | | | 11. | REGEXP_INSTR(description,'ee') > 0 | | | | 12. | REGEXP_INSTR('abc','d',1,1,1) | | | | 13. | REGEXP_INSTR('abc','d?'): include the '?' repetition character | | | | 14. | REGEXP_INSTR('Mississippi', 'si', 1,2,0,'i') | | | | 15. | regexp_instr(comments, '[^ ]+', 1, 9) | | |
|