16 August 2003

Update on the posting about Analytic Workspace Manager : The 9.2.0.4.0x patch will come out at the same time as the AWM, and this will be the one that OWB needs to enable the OLAP functionality. I notice also that the 9.2.0.4.0 patchset is now available as patch 3095277 on metalink, for Unix/Linux and Windows, which is the preceeding patch for the one we want. Fifteen days to go... 9:31:43 PM

This has got to be one of the funniest oracle-related threads on usenet for some time. 7:19:09 PM

The last new feature for Oracle 10G Database that I noticed from the upcoming Oracleworld presentations, is a new set of SQL capabilities including support for regular expressions, native numbers, and enhancements to how LOBs are handled. Regular Expressions are an advanced way to handle and search strings, and are probably most familiar to developers working on a Unix platform. Oracle 10G will have native regular expression support, which will most probably be used for searching and indexing textual data. The new 'native numbers' feature is a floating point datatype useful for Java programmers, which should improve performance, meet the IEEE 754 standard, and reduce storage requirements. LOB (Large Object) performance has been improved and their maximum size has been increased from 4Gb to multi-terabyte. Lastly, there have been improvements to the way that Oracle deals with collections, particularly useful when dealing with nested datatypes such as with XML. All of these new SQL features are being unveiled in a presentation by Peter Linsley, Technical Staff Principle Member (that's a mouthful) at this presentation at Openworld. 6:39:13 PM