Les Kopari On The Differences Between Oracle And Microsoft SQL

Thursday, November 25th, 2004 by Mark Rittman

Beginning SQL: Differences Between Oracle and Microsoft by Les Kopari : "If you’re new to SQL or just new to Oracle SQL, perhaps coming from a Microsoft SQL Server environment, it may seem like the two versions should be very similar, and they are, to a certain degree, but they are also very different in [...]

A Couple Of Alternative Event 10046 Resource Profilers

Thursday, November 25th, 2004 by Mark Rittman

A couple of alternative event 10046 resource profilers you might want to take a look at. AppsDBA Resource Profiler : "The AppsDBA resource profiler is a perl based event 10046 interval resource profiler. The resource profiler will parse an Oracle event 10046 level 8 or higher trace file and create an interval resource profile for [...]

The Cost Of Database Independence

Wednesday, November 24th, 2004 by Mark Rittman

Reading through the comments following on from my "Is Oracle A Legacy Technology" posting, and in particular Mogens N rgaard’s reference to Jonathan Lewis’ comments about database independence, made me think about another client I recently worked with. This client had an application that, when a transaction was about to take place, would request from [...]

First Oracle Business Intelligence 10g News Item Appears

Sunday, November 21st, 2004 by Mark Rittman

Oracle seeks to broaden BI use with new offering : "Oracle Corp. is poised to make what a company executive calls a "big push" in the business intelligence market in an effort to get customers to take advantage of as much functionality as BI tools have to offer. At next month’s Oracle OpenWorld conference in [...]

Lucas Jellema On Table Functions And The Model Clause

Sunday, November 21st, 2004 by Mark Rittman

Lucas Jellema from Amis has written up an excellent blog article on a real-life use of table functions and the Oracle 10g model clause. "From time to time there is a need in my SQL queries to have access to a table with a specific number of records. Sometimes I want to explode the results [...]

Website Design & Build: tymedia.co.uk