regexp_instr function summary : REGEXP_INSTR « Regular Expressions « Oracle PL / SQL






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)