Tuesday, February 24th, 2004 by Mark Rittman
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 company’s sites, [...]
Tuesday, February 24th, 2004 by Mark Rittman
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”, [...]
Tuesday, February 24th, 2004 by Mark Rittman
Ever wondered what the difference is between the SORT MERGEs and HASH JOINs found in Explain Plans? Tom Kyte gives us the lowdown…
Tuesday, February 24th, 2004 by Mark Rittman
"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 [...]
Monday, February 23rd, 2004 by Mark Rittman
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 release, and the
resultant upgraded 9.2.0.4 version [...]
