Fun with Oracle and the Dow Jones
I have written an article describing my explorations in the world of Oracle. I actually started learning Oracle two days before I wrote this article. So if you find that some of the things in it are not done in the best way, you can leave a comment. Before starting you will need of course an Oracle server. You can get the free version - Oracle XE. You might also want to install Oracle SQL Developer. A good knowledge of general SQL is also necessary.
The main question I explore is can we use Oracle to tell us when the financial crisis started?
The main question I explore is can we use Oracle to tell us when the financial crisis started?
p.s. Of course, the PostgreSQL fans can try and repeat the steps from the article in PostgreSQL, you will need 8.4dev though in order to use the analytical functions support.
p.s. PostgreSQL fans are actually out of luck, because the implementation of analytical functions does not allow for arbitrary ranges...
p.s. PostgreSQL fans are actually out of luck, because the implementation of analytical functions does not allow for arbitrary ranges...
| Permalink | | links to this post 
