Rittman Mead - Delivered Intelligence

I had an interesting question put to me at work yesterday, where a colleague was having problems with an outer join in an SQL statement. My collegue was putting together as system that recorded bids for contracts, storing the userid of the system operator, the details of the prospective client, and details of all the [...]

I’ve been trying to get TOra 1.2.4 to connect to an Oracle Database 10g installation, with both client and server on the same Red Hat 9.0 machine. Unfortunately, although TOra starts up, as soon as I try and connect I keep coming up with the error “ORA 12705: invalid or unknown NLS parameter value specified”, [...]

Ever wondered what the difference is between the SORT MERGEs and HASH JOINs found in Explain Plans? Tom Kyte gives us the lowdown…

"Why do so many BI projects fail? For years we ve heard about the potential value of BI, so why are the results often so disappointing in the eyes of key BI project sponsors and stakeholders? A BI project can go quite smoothly from a technical perspective and still fail in the eyes of these [...]

Mark Van De Wiel has advised that the 9.2.0.4 patchset for Oracle Warehouse Builder 9.2 is now available on metalink, using patch ID 3443542. The patch is currently available for Windows and Solaris, with patches for Linux, HP-UX, AIX and Tru-64 expected within the next month. The patchset addresses bugs and issues with the 9.2 [...]