Session 1- 10:15 - 11:45
Track A
Improved Charts
Hilary Farrell, Oracle Corporation
Hilary Farrell from the Oracle Application Express development team will discuss how you can enhance your Oracle Application Express (Oracle APEX) 4.0 applications, by graphically representing data using interactive and great looking flash charts. This session will provide an overview of the enhanced charting capabilities built into Oracle APEX 4.0, using AnyChart 5, and include a live demonstration of how to create and customize charts, including Gantts and custom Maps, in your application.
Track B
PL/SQL for APEX
Steven Feuerstein, PL/SQL Evangelist
Application Express generates applications built on the PL/SQL language. APEX developers write additional PL/SQL code to handle complex requirements. There is always a tendency when writing code within a UI-driven environment to treat that code rather casually; after all, it is not the main part of the application. That is a big mistake because this custom code must be maintained and enhanced. If you don't write it well, that maintenance becomes a nightmare. In this session, Steven Feuerstein will provide recommendations on establishing a solid foundation for custom PL/SQL development in APEX, covering error management, tracing, and key performance techniques.
Back to top
Session 2- 12:00 - 1:30
Track A
Dynamic Actions
Anthony Rayner, Oracle Corporation
Application Express 4.0 introduces 'Dynamic Actions', a new and easy way to define client-side behaviour in your applications, declaratively.
In this session, you will learn everything you need to know about 'Dynamic Actions', directly from the developer of this feature. We will start with some simple, common examples, moving on to more advanced scenarios such as extending and integrating 'Dynamic Actions' with 'APEX Plug-ins'. We will also look at a few other common use-cases, where currently you have to use custom code to get around certain limitations with the framework (and also how we plan to minimise these limitations in the future).
By the end of the session, you will have a good appreciation for what is possible with 'Dynamic Actions', understand how you can benefit from using them and be able to start giving your application a richer Web 2.0 feel, all with a few clicks of the mouse.
Track B
Increase Scalability
John Scott, APEX Evangelist
Oracle Application Express makes it incredibly easy to quickly develop applications, however what can you do if those applications need to scale to support large numbers of users? This session will focus on the many different areas (both inside and outside of the application itself) which you can leverage to increase the scalability of your application. This session is not just of interest to those people looking to build large applications, even the smallest of application can benefit from some of these techniques too!
Back to top
Session 3- 2:30 - 4:00
Track A
Mastering Plugins
Patrick Wolf, Oracle Corporation
Track B
Breaking Limits with the Database JVM
Carsten Czarski, Oracle Corporation
As most developers know the PL/SQL function library is very comprehensive and there
are packages for almost every task a developer has to accomplish.
But there are still requirements wfor which no PL/SQL package is avaliable - examples
are:
* Retrieve directory listings from the database server's filesystem
* Create or Unpack ZIP archives
* Retrieving Mails from a IMAP or POP3 server
* Transferring LOB data from a remote database
The presentation shows how the database-internal JVM can be used in order to
accomplish these tasks. The JVM will be introduced, the differences between the
database JVM and a "normal" JVM and finally an example how to create a java
stored procedure and access it from SQL and PL/SQL will be shown.
Back to top
Session 4- 4:15 - 5:45
Track A
Migrating from APEX 3.x to 4.0
Dimitri Gielis, APEX Evangelist
In this session I'll do a live migration from an APEX 3.2 application to APEX 4.0. I'll show how you can make use of the new features in APEX 4.0, what "errors" you'll probably have and the solutions to get arround them.
I'll also discuss how the life of a developer will change with APEX 4.0 and where you'll spend your time compared to developing in APEX 3.x.
Track B
Migrating Oracle Forms and MS Access to APEX @ Union Investment
Niels De Bruijn, MT AG
Within four months, our APEX team @ MT AG has migrated 160 dialogs from both MS Access as well as Oracle Forms to APEX. Learn in this session why our customer chose APEX, how we realize it and what experiences we made. Does APEX really have what it takes to handle such migrations?
Back to top
Thursday, October 28, 2010
Session 5- 8:30 - 10:00
Track A
Debugging with Oracle Application Express and Oracle SQL Developer
Dimitri Gielis, APEX Evangelist
Every developer has a problem in his application some time. If you follow best practices to instrument your code and know how to debug your Oracle Application Express application and database packages the correct way, it takes you near to no time to track the problem. This session will show you how you can debug your Oracle Application Express application using just Oracle Application Express or, if you need more debug information, through remote debugging with Oracle SQL Developer. It will also show how to debug your PL/SQL packages in Oracle SQL Developer and give tips about the most common pitfalls to get debugging to work.
Track B
APEX Application Lifecycles: Managing the Change
Dietmar Aust, Opal-Consulting
Every application changes over time. Keeping track of the different software versions in multiple environments (development, test, and production) quickly becomes a nontrivial task which every developer has to solve. This session details best practices for the configuration management of an APEX application. It covers a proven file system layout, automated DDL extraction, generation of documentation, a completely script based deployment approach, and the integration with Subversion.
Back to top
|
