A few days ago Lucas Jellema from AMIS posted a real nice SQL statement to generate a character based Gantt-chart.
I think it’s a good demonstration of the possibilities and the power of SQL. Have a look!
Category Archives: Tips & Tricks
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
Setting SYSDATE to a fixed value
Dietmar Aust just blogged about a very interesting trick to modify SYSDATE which I didn’t know so far.