Visualizing timelines

I came across a very useful query to show a Gantt chart based on pure oracle sql. As the datamodel I currently work with has a lot of timelines in it, I for one will be using it.