(Robert McMillan) Some Oracle customers using the Windows operating system will have to wait another two weeks to receive a critical software update to their database software, thanks to a glitch that came up in testing the company’s latest patches.

(Brian Peasland) I want to generate the unique ID based on records in the table. If I have any record in the table then I’m able to fire a query like “select max(id) from table” but the first time, when there is no record, then what should I do? (R)

(Sam) With the extended usage of Self Service Web Applications(SSWA) in Oracle Applications, the mechanism of cache invalidation assumes significant importance. In the process of supporting Oracle Application i am sure most of you would have already come across the cache invalidation mechanism and p

(Coskan Gundogar) In todays world data is controlled by time and if you don’t know how to control the time, you can’t have enough control over your data. Thanks Larry Ellison and his employees for building Oracle with powerful time manipulating functions and datatypes which you have to know to admin

(Bob Watkins) I had the privilege last month of hearing Rich Niemiec of TUSC speak about performance tuning at the Dallas Oracle Users Group. One tip he gave us was just too good not to pass on, so here it is: STATSPACK is still alive and well in Oracle 10g.

(yas) I was trying to decrease the number of parses for a 9.2.0.7 production database when I realized that the top parsing sql was coming from another database through a database link. This sql has a parse/execute ratio of 1 meaning it is parsed every time it is called. I have searched the bug datab

(John Charles Olamendy) This article is intended to show how to access the Oracle database using ADO.NET programming model and Oracle Data Provider for .NET (ODP.NET) that Oracle makes available.

(Raymond de Vries) Oracle recently released its official version of the Oracle BI Suite Enterprise Edition – 10gR3 (10.1.3.2.0 – also known as the Maui release). This version is based on the Siebel Analytics application stack, which Oracle obtained with the Siebel acquisition. The release is differe

(Philip Howard) In its recent quarterly results Oracle announced that its database and middleware division had grown by 17% in terms of new licence revenues. What are we to make of this? Well, it sounds (and is) very impressive. However, Larry subsequently commented that the middleware component of

(René Nyffenegger) There are a few things in PL/SQL that I am really missing. One of these things is printf. I am not aware of any built-in functionality that remotely resembles the elegance of printf. Ok, lpad and rpad and to_char come to mind. But these functions are, IMHO, tedious to use, especia