Cool Apex Integration with AJAX, YUI, Google Maps, and more. (5.65MB) Presented by: Brad Brown Date: 03/14/2008 Abstract: Years ago I used to discuss performing asynchronous activities with the hidden JavaScript page. With the improvements to JavaScript and our use of XML, Asynchronous JavaScript and XML (AJAX) provides functionality we've been using for years, but it's much easier to implement now. This presentation will cover AJAX in a variety of forms. Oracle Application Express (Apex) provides a little known secret called the "On Demand" feature...which allows for AJAX calls back to the database. Google and other companies provide AJAX functionality that you can use for application integration. In this presentation you'll learn how to write your own AJAX server side code and how to make use of existing server side AJAX code. This presentation will also discuss and demonstrate how you can take a series of latitudes and longitudes and turn them into a visual map containing your data using AJAX.

How IntelliReal uses Web Services to Enable Customers to Better Service their Clients (3.80MB) Presented by: Brad Brown Date: 03/20/2007 Abstract: IntelliReal (www.intellireal.com) is a real property market intelligence company. IntelliReal utilizes advanced technology and data aggregation to provide significantly enhanced data mining, accuracy, speed and reduced cost delivering valuation solutions. The Service Oriented Architecture (SOA) provides the foundation for IntelliReal's business-to-business delivery. IntelliReal's customers are able to seemly access the IntelliReal core technology as if that technology is running in their own IT environment. This presentation will include a demonstration of the SOA application in action. IntelliReal uses Oracle Application Express (APEX) as the "sales" tool, but typically delivers their solution from business-to-business using the SOA solutions. This presentation will cover the SOA and how it can change how you work to deliver applications to your customers (and other internal groups).

How IntelliReal used Oracle Application Express to Rapidly Build their Production Environment (4.38MB) Presented by: Brad Brown Date: 03/20/2007 Abstract: IntelliReal's user interface was developed using Oracle Application Express (APEX). With most any technical presentation that you've attended, you're likely always thinking about how to relate your environment to what the speaker is discussing and building a real world application using the tool. This presentation covers a specific business problem that was solved using APEX: delivering a rich user interface for "show." IntelliReal's primary customer base are businesses. Most of the customers actually access the IntelliReal systems using SOA. The APEX application uses the SOA components too. This presentation will discuss the functional requirements, how the application continues to be extended, the net results and cost savings. This presentation will include an online demo and discussion of the components.

APEX Advanced Topics (1.33MB) Presented by: Larry Linnemeyer 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 by: Larry Linnemeyer 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.