Too many Oracle shops start from scratch when beginning PL/SQL development, learning the hard way from novice developers, books, bugs and expensive trial and error. We will look in-depth at an open source framework that can save you 4 to 8 weeks of development time, and months of future refactoring and maintenance enhancements. It can…

This presentation examines real-world techniques for improving the speed of SQL queries with a focus on the new Oracle11g SQL tuning features. The topics will include the new SQL workload replay, fully automatic SQL tuning, the “result cache” hint, new Oracle parameters that affect SQL performance, and changes to the new Oracle11g CBO costing approach.…

Sometimes, answering simple questions that can be stated clearly in plain English can require pretty convoluted SQL to answer in Oracle. This session tackles some common needs (and a few uncommon situations, too), providing a few building block techniques along the way. A session that is sure to appeal to wonks at all levels!

This presentation introduces the Oracle 11gR2 editions feature. Editions allows for the ability to do application upgrades with no downtime, including changing tables structures, updating data, and doing this with multiple versions of an applications simultaneously accessing the database. We will attempt to give a basic example, explain how to get started, and give references…

Sometimes, answering simple questions that can be stated clearly in plain English can require pretty convoluted SQL to answer in Oracle. This session tackles some common needs (and a few uncommon situations, too), providing a few building block techniques along the way. A session that is sure to appeal to wonks at all levels!

There are many code debugging tools available to Oracle developers. Some require more effort than others. The author will walk the audience through a debugging session using SQL Developer and how it's used with XML Documents.

This presentation examines real-world techniques for improving the speed of SQL queries with a focus on the new Oracle11g SQL tuning features. The topics will include the new SQL workload replay, fully automatic SQL tuning, the “result cache” hint, new Oracle parameters that affect SQL performance, and changes to the new Oracle11g CBO costing approach.…

There are many code debugging tools available to Oracle developers. Some require more effort than others. The author will walk the audience through a debugging session using SQL Developer and how it's used with XML Documents.

Many times during a project life cycle, new technology is introduced that presents first time challenges. The author will describe a project using Oracle XML DB and discuss why XML DB was chosen, how XML DB was used, and the technical issues encountered. The author will provide several examples using XMLTYPE, CLOBs, XML DB methods,…

Fusion Apps are built with components trusted by over 90,000 customers – Fusion Middleware, the strategic Oracle Technology platform. In this session we examine usage of Fusion Middleware components in building Fusion Applications. Using different Fusion Apps modules we highlight how application functionality was implemented using middleware components such as Application Development Framework (ADF), SOA…