Database software giant Oracle Wednesday will easily meet, or slightly beat its own cautious forecast when it posts results from its fiscal second quarter, according to analysts.

By James Niccolai – Quest Software has consolidated several of its Oracle database management tools into a unified product called Quest Central for Oracle, a move that one analyst said could make life easier for database administrators.

By Sushil Srivastava – Sometimes its quite essential to know and use the database name on which your SQL is being executed.

An IBM-backed Java tools initiative could be yanked back into Sun Microsystems Inc’s sphere of influence, to heal a potential community rift, through efforts lead by Oracle Corp, writes Gavin Clarke.

By Pau Fores – This script uses a hash join — the most efficient way of joining huge tables — to find duplicate rows. It has been tested on Oracle 6.0 to Oracle 9i v2, and it works in all of those versions.

by T.R. Bharath Rajkumar – One common requirement when writing queries is to do a range comparison in DECODE. But DECODE allows only exact comparison. Range comparison can be achieved by making use of the function SIGN in DECODE.

Oracle Corp. and SAP AG are building software to analyze data within their enterprise applications, but some users say the new and enhanced tools will have to prove themselves more effective than existing business intelligence tools from third-party developers.

By Caroline Kvitka – For many businesses and individuals around the globe, computers are just another part of the day—a resource they tap into, just like the electricity they use to brew their coffee, wash their clothes, and light their homes and offices. And, just as electricity is accumulated in p

By David Gibbs – In order for Oracle to use the Cost Based Optimizer (CBO) effectively, schema objects must have current statistics. Instead of analyzing all user objects regularly, which is costly, in 8i and above you can have Oracle monitor table usage.

By Mitch Wagner – Improved Oracle Financials will provide real-time analysis of business performance and add customization features.