Showing posts with label positive lookahead. Show all posts
Showing posts with label positive lookahead. Show all posts

Saturday, November 7, 2015

Using Regex with positive lookahead in Oracle

There are times where you need to query data from the database that matches a particular regular expression. Depending on your requirements, you might need to use a positive look ahead in your regex.

Generate a unique N letters word sequence (by using relationship between Factoradic base system and Lexicographic Permutation Order of a String)

Lets say that you want to generate a unique 3 letters code sequence to be used as a primary key for some data recodes. Also let assume ...