SQL based String Tokenizer – another approach using CONNECT BY

Just read a nice SQL puzzle on the AMIS blog called Writing a pure SQL based String Tokenizer and because Lucas wrote

Please share with me your thoughts on this – but I will share my attempt with you anyway

That’s why I thought I have to train my brain a little bit with a nice SQL statement… and here is my result using CONNECT BY instead of CUBE.
Continue reading