Skip to content

Instantly share code, notes, and snippets.

@alexanderjsingleton

alexanderjsingleton/oracle_regex_example.sql

Created February 7, 2016 02:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save alexanderjsingleton/49cdcad68fe12c8dfc02 to your computer and use it in GitHub Desktop.
Save alexanderjsingleton/49cdcad68fe12c8dfc02 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle SQL does indeed handle regex.
Raw
oracle_regex_example.sql
SELECT invoice_id,
invoice_number
FROM ap.invoices
WHERE REGEXP_LIKE (invoice_number, '^P(*)');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment