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 ...