I learned the following important facts:
- REGEXP_SUBSTR is a great Oracle function. There are some quirks with it that need to be considered, but all in all, I'm trying to always use it instead of SUBSTR. One of the limitations in REGEXP_SUBSTR is that for now, there's no support for look behind or look ahead functions. To work around this, I had to take a REGEXP_SUBSTR of my REGEXP_SUBSTR.
- Pattern matching requires its own mindset. You must not only keep the end result of the pattern you want in your mind, but you must also consider what the pattern is on the way to becoming what you want.
- TIMTOWTDI is a blessing and a curse. There may be more than one way to do it, but there can also be more than one way to almost do it. This can be dangerous.
As I continue to grow and develop as a programmer, I chase after "The Better Way". Because SQL has a well structured set of instructions, that better way is often subtle, and involves understanding things like profile optimizers, and indexed searches. Every day I respect, and like SQL more.