By Scott Robinson – Consultants with Oracle expertise will likely find themselves working with an ERP implementation. Here’s a look at two common situations that you’ll address: working with Oracle’s database link and setting up embedded transactions.

IOUG Live! 2003 is the conference for Oracle users, by Oracle users, delivering tested tips and techniques in over 200 technical sessions. Focus areas include: DBA, Architecture & Infrastructure, Data Warehousing & Business Intelligence, Application Server & Web Services; and eBusiness & Application

By Peter Choi – This script is useful for determining the hit ratio of your database. The hit ratio determines if Oracle is performing more physical reads to retrieve the data. If the data being queried is found in the buffer cache, the hit ratio will be higher than if the data is not cached a Oracl

by Claudiu Ariton – The purpose of this code is to provide an example of the new pipelined and parallel PL/SQL table functions available in Oracle9i Database.

By Barbara Darrow – Some might say Benny Souder’s title, vice president of distributed database development at Oracle, is an oxymoron. After all, Oracle sure seems wants everything in the world to be in one huge (Oracle) database. At least that’s what Microsoft and IBM say. That’s even what O

Learn how to suspend or resume operations using the new RESUME option in Oracle 9i.

Tom Birch makes a case for coding when he explores both the power and the limits of Oracle’s Cross Tab query for turning data in a report from vertical to horizontal. For coverage on the full range of Oracle SQL features, check out O’Reilly’s Mastering Oracle SQL.

By Alan Joch – More-sophisticated, integrated business intelligence tools and technology give an increasingly wider ranger of businesses new, immediate competitive powers.

By FRANK PANTALEO – This script is very useful for DBAs who want to use Perl for doing hot backups. Perl DBI/DBD provides very close integration and control of the state of the database. It also allows real time queries that allow the script to be self-learning about what dbf’s are in the database.

By Paula Rooney – Oracle remains on track to ship realtime communications features in its collaboration suite in mid-2003 and is unfazed–at least publicly–by the entry of AOL and Yahoo into the corporate instant messaging market.