regexp_instr function summary
regexp_instr (string, pattern)
regexp_instr (string, pattern, position)
regexp_instr (string, pattern, position, occurence)
regexp_instr (string, pattern, position, occurence, return-option)
regexp_instr (string, pattern, position, occurence, return-option, parameters)
parameters can be a combination of
* i: to match case insensitively
* c: to match case sensitively
* n: to make the dot (.) match new lines as well
* m: to make ^ and $ match beginning and end of a line in a multiline string
* x: to ignore white spaces.
regexp_instr is an Oracle SQL function that enables regular expressions in queries.
It enhances the 'traditional' instr.
Related examples in the same category
1. | Simple demo for REGEXP_INSTR | | |
2. | regexp_instr (string, pattern, position, occurence, return-option) | | |
3. | Return-option is set to 1 to indicate the end of the found pattern | | |
4. | regexp_instr (string, pattern, position, occurence, return-option, parameters): c: to match case sensitively | | |
5. | 'i': to match case insensitively | | |
6. | regexp_instr (string, pattern) | | |
7. | Returns the position of the second occurrence that matches the letter 'o' starting at position 10 | | |
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) | | |