Rittman Mead - Delivered Intelligence

Someone recently asked me to recommend a good book for Oracle Reports, and I thought it worth jotting down my thoughts in this area, as it’s something I’ve been asked about a few times in the past.
Oracle Reports has traditionally ‘fallen between the cracks’ when it comes to books, usually getting bundled in with Oracle […]

“You’re writing a query that returns computed column values. As input to your calculations, you need values from multiple rows. What do you do? This is actually a fairly common problem. Solutions to it often involve inscrutable combinations of self-joins and subqueries.
Oracle Database 10g enables a new approach. Using the SELECT statement’s new MODEL clause, […]

Jonathan Lewis recently posted a guide on comp.databases.oracle.server to the best online resources for answering Oracle questions. A couple of them were new to me, so I thought it worth mentioning them here.

The Co-operative Oracle Users’ FAQ - a whole list of Oracle frequently asked questions hosted on Jonathan’s site
Steve Adams’ Ixora Web Site - […]

You’ve probably noticed that the site has gone through a makeover in time for the New Year. It’s largely been driven by the move to Moveable Type as the engine behind the site, but I’ve taken the opportunity to add a few new features as well, including category archives, a better search engine, and listings […]

Well that’s it for 2003. I’m going to spend the next week or so eating too many mince pies, helping my son open his presents, and watching too much television. Have an excellent Christmas and New Year, and see you all in January!

“It really does appear that Oracle has done enough to make the grid built out of commodity servers a practical and economic reality. As a by-product it has made the management of smaller systems easier as well.” writes Peter Abrahams for The Register.

One of my New Year Resolutions is to move my work laptop over to Linux, to be more in sync with Oracle’s development effort and to benefit from the extra performance that you get from running Oracle on a Unix platform. One of the things that’s put me off in the past is the thought […]

I’ve just come back from an initial couple of days at a client site, where we’re looking at tuning up their data warehouse. I’d previously mentioned one of the areas we’d looked at (function-based indexes), and having done a bit more research, I thought it worth mentioning one of the sites I’d come across that looked […]

“When using Discoverer 9iAS (the one that comes with 9iASr2) and public connections, the row-level security i’d set up on the Oracle database doesn’t work any more. How can we integrate the SSO logins and discoverer logins such that our database row-level security now works?“

I had a similar situation happen with a recent client, and this […]

If you’re looking to use the web-based Design Browser that comes with OWB 9.0.4 and 9.2, and want to deploy it using the new built-in OC4J instance, there’s a new Metalink note No. 237367.1 that goes through all the steps required to set it up.
In the past, to use the Design Browser you had to […]