« Vacation, Sweet Vacation | Main | Overdue Orders Report Enhancement »
August 31, 2006
Oracle Analytics
Dale and I had a shortened time today, but we did manage to review a nice introduction on Oracle Analytics. Analytics allow you to use plain SQL (as opposed to PL/SQL) to gather data on row sets. There are about 20 or so Analytics functions, and they are similar to existing SQL functions such as sum and count except they can return multiple rows.
Today we managed to determine what Analytics is and also got some further research materials lined up. We feel that Analytics will help us to replace a lot of PL/SQL code with these advanced SQL functions for increased efficiency. The next step is to identify a real world problem and see if we can solve it using Analytic functions.
Posted by rossm at August 31, 2006 11:40 AM
Comments
Post a comment
Thanks for signing in, . Now you can comment. (sign out)
(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)