The PL/SQL Challenge: 15 Key Tips Everyone Must Know (4.47MB) Presented at: Collaborate Presented by: Joe Trezzo Date: 04/13/2008 Abstract: This presentation will cover 15 top Oracle PL/SQL tips and features. There are many features and tips that have presented in various presentations throughout the years. There are many features that have been incorporated into Oracle PL/SQL over the past 15 years. This presentation takes 15 of the top features and tips and educates the attendees on the usefulness and power of these top 15. They are all covered with examples throughout the presentation.

Catapult to the New PL/SQL: 10gR1 and 10gR2 Key Features (3.24MB) Presented at: Collaborate Presented by: Joe Trezzo Date: 04/13/2008 Abstract: This presentation will cover the new key PL/SQL related features specific to Oracle10g release 1 and release 2. The new features covered include the following: new conditional compilation, new PL/SQL commands (regular expressions), new and enhanced Oracle supplied packages (dbms_output, dbms_ddl wrap procedure, dbms_warning, dbms_stats), new functions, new enhanced SQL commands (flashback table, etc.), etc. Each of the features covered will include example code to enforce the new features capabilities and usefulness.

Take the Plunge: Top New 11g PL/SQL Features (3.87MB) Presented at: Collaborate Presented by: Joe Trezzo Date: 04/13/2008 Abstract: This presentation will cover the new key PL/SQL related features specific to Oracle 11g. The new features covered include the following: new conditional compilation, new PL/SQL commands, new and enhanced Oracle supplied packages, new functions, new enhanced SQL commands, etc. Each of the features covered will include example code to enforce the new features capabilities and usefulness.

Scheduled Queries (171KB) Presented at: Article Presented by: Brad Brown Date: 09/07/2007 Abstract: For any database application environment, you may wish to run a query and return the results to a list of people on a scheduled basis. This document describes exactly how you can accomplish this goal through scheduled queries. This process is a universally applicable database application. Each example in this paper is driven by data (i.e. queries) in the database.

Integration: Using OracleAS Portal to 'Bring It All Together' (1.05MB) Presented at: Collaborate Presented by: Chris Ostrowski Date: 04/18/2007 Abstract: As systems become more and more complex, end-users are faced with increasingly complicated and varying user interfaces. There is an urgent need for IS depatments to integrate systems and provide consistency between these applications. OracleAS Portal provides the means to integrate Oracle and non-Oracle-based systems into a visually consistent environment that end-users can access easily and administrators can maintain securely.

The PL/SQL Challenge: 20 Key Tips Everyone Must Know (4.62MB) Presented at: Collaborate Presented by: Joe Trezzo Date: 04/17/2007 Abstract: This presentation will cover 20 top Oracle PL/SQL tips and features. There are many features and tips that have been presented in various presentations throughout the years. There are many features that have been incorporated into Oracle PL/SQL over the past 15 years. This presentation takes 20 of the top features and tips and educates the attendees on the usefulness and power of these top 20. They are all covered with examples throughout the presentation.

Advanced APEX DB Tips and Techniques (1.84MB) Presented at: Collaborate Presented by: Brad Brown Date: 04/15/2007 Abstract: HTML DB (APEX) is a powerful and comprehensive tool. Numerous advanced tips and techniques will be covered in this presentation. These topics include: pop-up windows; complex searches; document management; indexing and searching; "tool tip" or hints; email links; page 0; help text; background jobs; "add to my calendar" feature; saving contacts (VCF); sending mass emails; and more.

How IntelliReal used Oracle Application Express to Rapidly Build their Production Environment (4.38MB) Presented at: Utah Oracle Users Group (UTOUG) 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 at: Utah Oracle Users Group (UTOUG) 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 at: Utah Oracle Users Group (UTOUG) 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.

Advanced APEX DB Tips and Techniques (1.84MB) Presented at: Rocky Mountain Oracle Users Group (RMOUG) Presented by: Brad Brown Date: 02/14/2007 Abstract: HTML DB (APEX) is a powerful and comprehensive tool. Numerous advanced tips and techniques will be covered in this presentation. These topics include: pop-up windows; complex searches; document management; indexing and searching; "tool tip" or hints; email links; page 0; help text; background jobs; "add to my calendar" feature; saving contacts (VCF); sending mass emails; and more.

Quick Web Development using JDeveloper 10g (2.14MB) Presented at: Rocky Mountain Oracle Users Group (RMOUG) Presented by: Brad Brown Date: 11/17/2006 Abstract: JDeveloper 10g is an amazing development environment. Each new version gets closer to rivaling Oracle Forms. Now with the Oracle Application Developer Framework (ADF), which includes TopLink and Struts, you can quickly and easily develop a GUI/HTML-based Web application using this point-and-click, drag-and-drop development tool. This presentation will show you how to: Map a database object into an ADF Business Component - a persistent business object using BC4J An ADF Business Component view object - providing the data access An ADF Business Component Application Module - providing the business services The ADF Data Bindings and Control components - the "Model" in MVC The Struts Controller - the "Controller" in MVC The Java Server Page - the "View" in MVC In one hour you'll learn how to quickly develop an application using JDeveloper 10g.

High-Availability Development Methodology: What Do You Need To Be Successful? (1.44MB) Presented at: Oracle Open World (OOW) Presented by: Shaun O'brien Date: 10/21/2006 Abstract: High-availability (HA) development brings with it some unique requirements and, by extension, some unique challenges that need to be adequately addressed when attempting to deliver rigorous guaranteed levels of uptime. In this session, you hear the basics of HA, what it means, what some of its challenges are, and the specifics of an HA development methodology that addresses these challenges. The methodology presented is a TUSC-recommended methodology that is based on industry standards. Included in the presentation are insights provided from a case study based on implementation of this methodology with one of the leading U.S. university hospital and medical organizations.

New Oracle 10g & 9i Features For Developers (115KB) Presented at: Midwest Oracle Users Group (MOUG) Presented by: Tony Catalano Date: 09/08/2006 Abstract: This presentation covers the following: Internal PL/SQL Enhancements PL/SQL Compile Time Warnings DBMS_DDL DML Error Logging Merge Statement Flashback Query Flashback Table DBMS_METADATA Multi-Table Inserts Native Dynamic SQL Global Temporary Tables Bulk Binds with Collections

New 10g and 9i Features for Developers (369KB) Presented at: Collaborate Presented by: Tony Catalano Date: 04/26/2006 Abstract: As the new database versions roll out, so do some exciting new features. This presentation discusses the new Oracle 10g, Oracle9i and Oracle8i features that enhance the developer's ability to develop mission critical Web-based applications. Using the new features demonstrated in this presentation add reliability, stability, speed and flexibility to any application. Just a few of the topics featured in the presentation are: PL/SQL compilation, Merge, multi-table inserts, bulk binds, triggers on system events, and Native Dynamic SQL. Attendees gain an understanding of the features; learn when to use them and learn the design considerations associated with each.

Using JDeveloper to Create and Deploy Portlets (592KB) Presented at: Collaborate Presented by: Chris Ostrowski Date: 04/25/2006 Abstract: The OracleAS Portal wizards are extremely powerful, but there many reasons for needing greater control of your portlets than the OracleAS Portal wizards can give you. Oracle JDeveloper gives you total control over your Portlet development. Previous versions of JDeveloper used an arduous process for developing and deploying portlets. This presentation will focus on the ease with which developers can develop and deploy portlets in the latest versions of JDeveloper and the Oracle Application Server.

The PL/SQL Grid: Time to Expand to 10g R1 and 10g R2 (899KB) Presented at: Collaborate Presented by: Joe Trezzo Date: 04/24/2006 Abstract: This presentation will cover the new PL/SQL related features specific to Oracle10g release 1 and release 2. The new features covered include the following: new conditional compilation, new PL/SQL commands (regular expressions), new and enhanced Oracle supplied packages (dbms_output, dbms_ddl wrap procedure, dbms_warning, dbms_stats), new functions, new enhanced SQL commands (flashback table, etc.), etc. Each of the features covered will include example code to enforce the new features capabilities and usefulness.

Beginner Tuning Tips for Developers (3.19MB) Presented at: Collaborate Presented by: Rich Niemiec Date: 04/24/2006 Abstract: This is a beginner level presentation on developer tuning. This presentation is focused on developers who are relatively new to Oracle. It will focus on some basic tuning tips and techniques that you can use to tune your code. After a brief look at how Oracle works and where a query fits into the process. We will look at how to find the problem queries in your system. We will also look at various indexes that can be built and things to watch out for with certain indexes. We'll review how to use explain plan and Autotrace. Lastly, we'll look at using hints to tune queries and joining tables. Overview of how Oracle works and where queries fit into the process Finding the problem queries Your indexing arsenal Using Explain Plan and Autotrace Hints that can help Joins and the Driving Table Partitioning Basics

Spatially Enabling Your BI Applications with Oracle Spatial and Mapviewer (3.02MB) Presented at: Collaborate Presented by: Matt Topper Date: 04/24/2006 Abstract: Almost every data warehouse is litered with spatial information. Customer addresses, store locations, competitor locations, etc. All of this data has great potential to add value to your Business Intelligence products. This presentation will cover how to spatially enable your data and include it in your BI dashboards. I will show the Oracle Locator and Geocoder and how to transform address information to latitude and longitude numbers. Using the database data I we will show how to create store territories based on real customer data. Now that the territories have been made we can display the information utilizing Oracle Mapviewer to visualize the data. Lastly, we will turn the map created in Oracle Mapviewer and add it to a Portal BI Dashboard.

How to use Regular Expression Functions in 10g (339KB) Presented at: Collaborate Presented by: Kevin Loney Date: 04/24/2006 Abstract: As of Oracle Database 10g, you can use the regular expression functions to perform very complex searches. This presentation will show the formats for the functions along with examples of searches. Examples include case-insensitive searches and searches for classes of characters (such as all numbers, or all uppercase letters). As a bonus, case-insensitive search options that do not use the regular expressions will also be shown.