I was recently invited by Sandro Saitta, who runs the Data Mining Research blog (http://www.dataminingblog.com/), to write a guest blog post for him. The topic for this guest post was Can Database Developers do Data Mining ? The original post is available at - Can Database Developers do Data Mining – Here is the main body of the post Over ...
n AS time_id,
TO_CHAR(to_date(n,'SSSSS'),'HH24') AS hour,
TO_CHAR(to_date(n,'SSSSS'),'MI') AS minute,
TO_CHAR(to_date(n,'SSSSS'),'SS') AS second
CONNECT BY LEVEL <= 86400
One of the questions that regularly comes up in the forums, or during presentations on Oracle data integration products, is on the future of Oracle Warehouse Builder and Oracle Data Integrator. People wonder which tool to use for new projects? What should be done with existing implementations? In this article we will first compare the features and functionalities of both ...
ODI, Oracle Data Integrator, Knowledge Module, IKM
The script below will create a date dimension in just one SQL statement. We don't use performance-killer nonsense such as cursors, functions etc. We just pick a start date and the number of days we want to create and with a bit of magic of the Connect By clause and the NUMTODSINTERVAL function we do the whole thing in 14 ...