(Aradhana Puri) Oracle Portal, part of Oracle Fusion Middleware, is a Web-based tool for building, deploying, and maintaining self-service and integrated enterprise portals. It also provides services that enable you to perform configuration and administrative tasks. To perform most configuration and

Oracle has announced Oracle Daily Business Intelligence for Compliance, an embedded compliance management reporting system for Oracle E-Business Suite.

(Bob Watkins) Numbers, text strings, and dates are three common datatypes used in tables. Although you would expect the PL/SQL package DBMS_RANDOM to be able to generate random numbers—and it does—it is also capable of generating random text and date values as well.

(Keshav Chennakeshav) Here is a tip to compute totals and percentages using the GROUPING and ROLLUP functions in summary queries. To get the correct percentage, the WHERE clause in the runtime table (designated with the alias “ts” below) should match the WHERE clause of the query. The output can be

(Roger Schrag) Oracle maintains its own buffer cache inside the system global area (SGA) for each instance. A properly sized buffer cache can usually yield a cache hit ratio over 90%, meaning that nine requests out of ten are satisfied without going to disk.

(Penny Lunt Crosman) Calling business intelligence "a new leg of our business," Oracle president Charles Phillips announced the Oracle BI Suite in March and claimed Oracle would be able to leapfrog other longtime players in the BI space.

(Lewis R Cunningham) I recently wrote about getting the XML out of your database using a less preferred method (UTL_FILE). Today, I am going to show you how to do it via one of my preferred methods. Of course the easiest method is just to return an XMLType from a stored procedure and let the calling

(Warren Nash) The following tip will calculate both the number of log switches per day and the average per month for the last couple of months.

(Tarry Singh) In part 10, we covered an important topic called security. I think with the world (IT and likewise) gearing up for Utility Computing that virtualization will play greater role in helping utility computing become reality. There is a lot of talk of hosting applications from distant serve

(Mike Miley) A global employment services company with more than 4,300 offices in 72 countries has compelling reasons to leverage a global IT infrastructure for both e-commerce applications and back-office financials. For starters, its clients need standardized global online access to the multicount