René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback


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.