APEX Advanced Topics (1.33MB) Presented at: Utah Oracle Users Group (UTOUG) Date: 03/20/2007 Abstract: Now that you have figured out just how easily APEX can be used to quickly develop and deploy critical applications, this session will help you to take your APEX development work to the next level. In this session, we will explore advanced topics that utilize APEX APIs, JavaScript, XML and more. Some of the areas we will explore include: - Creating custom popup LOV windows that can perform advance searches, display more than just a single value and return any number of values to the calling page - Multiple master detail reports on a single page that highlight current rows in master reports - Utilizing JavaScript and XML to interact with the server without resubmitting the page. - Creating, populating and processing multiple dynamic checkboxes. - A package approach to doing manual tabular forms that handles display, validation, correction and processing using apex_item and apex_application. - Using dynamic SQL to render and process a form page that is totally dynamic as far as the number and types of fields that are on the page. The purpose of this session will be to introduce you to these advanced topics and provide you with actual code examples that will allow you to implement these techniques yourself.

Hands-on Oracle Application Express Full Day Session (3.56MB) Presented at: Utah Oracle Users Group (UTOUG) Date: 03/20/2007 Abstract: In this full day hands on session, you'll learn to use Application Express from concept to delivery to support. We'll start with an existing database (i.e. an Excel spreadsheet) and build an application from the ground up. The exercises will build on each other and expose the student to the different components of the Application Express development environment. Application Express is a declarative web-based application development & deployment environment. It's a powerful and easy way to quickly develop a database-centric Web application. You can install Application Express on your own machines or run in a hosted environment on Oracle's site. All development (construction of pages) is done through the browser interface. You can use the SQL Workshop to run SQL and add data to your environment. This easy-to-use tool will impress you in no time at all! This presentation gives the participants a good introduction and great hands on experience with the Application Express development environment and a good idea of the power that it contains to create quick powerful Web application in a very short time.