Saturday, August 23rd, 2003 by Mark Rittman
If you’re looking for some background reading on Oracle development, particulary to do with business intelligence and datawarehousing on Oracle 9i, i’ve put together a recommended reading list which you might find useful.
Friday, August 22nd, 2003 by Mark Rittman
Ameed Taylor, Chair of the E-Business Suite Customization and Extension SIG within the Oracle Applications User Group, has started up a weblog on Oracle development.
Ameed’s aim is to try to keep his SIG members, and others with an interest in Oracle development, up to speed on the latest news etc relating to Oracle Development. Take [...]
Thursday, August 21st, 2003 by Mark Rittman
Oracle Discoverer is the primary query and reporting tool that I use on data warehousing projects, and the latest version, Oracle 9iAS Discoverer, comes bundled with the Oracle 9i Application Server. With release 2 of 9iAS, Discoverer uses the Single Sign-on server (known as SSO) within 9iAS to provide authentication and security. One thing that [...]
Wednesday, August 20th, 2003 by Mark Rittman
Update on the 9i OLAP Spreadsheet Addin that was mentioned in a previous post.
Aneel Shenker has announced on OTN that a 9i OLAP Spreadsheet Addin will indeed be produced, and it’s due for release in beta form in October 2003. Functionality will be similar to the Express Excel Addin (i.e. it’ll feature a selector) but [...]
Wednesday, August 20th, 2003 by Mark Rittman
SQL Plus has a useful command called COPY that until now I had no idea about. It’s an alternative to the IMP and EXP commands that lets you copy data between two SQL*Net connected databases.
Using the syntax
COPY FROM database TO database action – destination_table (column_name, column_name…) USING query
You can quickly copy data from one database [...]
