Inside Oracle APEX by Patrick Wolf

Creating a Gantt-chart in SQL

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!

Continue reading...

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

Continue reading...

Setting SYSDATE to a fixed value

Continue reading...