Insert Picture Here Oracle SQL Developer Oracle Application

<Insert Picture Here> Oracle SQL Developer & Oracle Application Express Future Direction David Peake Principal Product Manager – Database Tools

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

Agenda • Introduction to the Tools • SQL Developer Modeling • Oracle Application Express • Forms Conversion (3. 2) • Websheets (4. 0) <Insert Picture Here>

Improve Developer Productivity • Improving developer productivity over each phase of the database application development life cycle • Improving developer productivity with new tools: SQL Developer, and Application Express • Introducing database data modeling

Oracle SQL Developer Today SQL & PL/SQL IDE Lightweight, graphical interface that simplifies and enhances database development tasks. © 2008 Oracle Corporation – Proprietary Future Migrations One-step migration of DB objects and data to Oracle. Translation of Sybase and SQL Server T-SQL to Oracle PL/SQL. Migrate from Access and My. SQL Data Modeling Logical, Relational and Physical DB modeling serving Data Architects, DBA’s, Developers and Users. Unit Testing Simplify the automation of SQL and PL/SQL unit testing and code coverage with performance reporting and trending

Oracle Application Express (APEX) Future Today RAD Development Unique Rapid Application Development (RAD) tool for the Oracle Database. SQL Centric Application Development. © 2008 Oracle Corporation – Proprietary Internet / Intranet Cloud Allows DBA to host a development service on the internet or intranet. One DB services 100 s of applications. Reduces administration time and resources saving money. Web 2. 0 Bring self-service web applications to nonprogrammers, with innovative interactive reporting, web service integration and flash charting. Forms Conversion Transition Forms customers to Web 2. 0. Leverage existing developer skills.

<Insert Picture Here> Oracle SQL Developer Data Modeling

Oracle SQL Developer • Database Development IDE • Popular • Most downloaded Oracle tool • 1. 5 m users • #1 Oracle database development IDE • Distribution (No Cost) • With Database – All Editions • OTN download • Benefits • Productivity • Ease of use Introduced March 2006

SQL Developer Momentum • Product is robust and gaining momentum • March 2006: SQL and PL/SQL Development • December 2006: Session Management, XQuery, Master Detail Reporting • June 2007: Integrated Migration Workbench, Heterogeneous Database Support, Oracle APEX support • May 2008: Version Control, DB Docs, Schema Compare

Oracle SQL Developer Data Modeling

Multi-Dimensional Modeling • Modeling of Cubes, Dimensions, Levels and Hierarchies, Measures and slices • Start from ROLAP, Cube Views, XMLA or from scratch • Generate Oracle Analytical Workspaces

Working with Data Flow Diagrams • Data Flow • External Agents • Processes • Primitive • Composite • Transformation • Information Flow • Information Store

Viewer Provides Developers Full Read Access to Data Model

Repository • File Based • All metadata and diagrams stored in local XML Files • Can be placed under source code control • May merge with repository • Repository • Significant customer demand for relational repository • Single location, easy for impact analysis • Run relational queries and reports • Concurrent access and team collaboration • Enhanced security

D E M O N S T R A T I O N Oracle SQL Developer Modeling Data

Oracle Data Modeling • Why is Oracle releasing this tool? • Data Modeling is SQL Developer’s top new feature request • As the industries #1 database, Oracle needs a world class database data modeling tool • Part of our commitment to provide full life cycle of application development tools • Addresses a deficiency in our current database tools • Why will customers adopt it? • Need better control over enterprise data architecture • Multiple database support - Oracle Database, Microsoft SQL Server and IBM DB 2 • Facilitates collaboration between architects and developers • Many Oracle customers prefer Oracle Tools • Eases upgrades, migrations, data warehousing and ETL development

<Insert Picture Here> Oracle Application Express

Oracle Application Express (APEX) Database-centric Web application development tool • Unique Rapid Application Development (RAD) tool for the Oracle Database • Browser based for Development, Deployment & Use • Declaratively build professional Web 2. 0 applications that are fast and secure • Leverages full Oracle database capabilities and existing SQL & PL/SQL skills • Standard component of the database • Fully supported, “no-cost” option with all editions of the Oracle Database Easy to develop • Easy to deploy • Easy to manage

Oracle APEX Typical Use Examples Data Driven Applications • Commercial telecommunications management - Paetec Software Corp • Physical store sales tracking - Deutsche Telecom • Standard corporate development tool – WAMU • Database management and monitoring – Online Reporting Mountain Iron • Tournament Purse Management and Payment System – PGA Golf • Microsoft Access and Microsoft Excel consolidation – Lansing Community College Access Replacement • Training & safety registration applications - CERN • Computer assets tracking – University of San Diego • Ask. Tom Discussion Forum – Tom Kyte, Oracle

Oracle Application Express Momentum • #3 Oracle OTN Forum behind SQL and General Database • 2. 7 m views / week on apex. oracle. com • 38 Sessions at OOW 08 • More internal Oracle applications are built using Application Express than any other development tool • Enthusiastic user community with over 50 active blogs • Developer community estimated at 250, 000

Oracle APEX Roadmap • APEX 3. 1. 2 • Latest Production Release • Introduced Interactive Reports • Basis for Audit Vault Reporting • APEX 3. 2 • Forms Conversion • Due soon • APEX 4. 0 • Websheets • Oracle APEX Listener • Improved Tabular Forms • Dynamic Actions

<Insert Picture Here> Oracle Application Express 3. 2 Forms Conversion

Why move off Oracle Forms? • Oracle Forms is NOT going away! • Forms is an aging pre-client server technology from mid 80’s. Forms runs a Java applet invoked from a browser, not HTML • Forms is not consistent with today’s modern browser apps

Why Move to Oracle APEX? • Moves you to modern Web 2. 0 based computing • Modernizes applications with innovative capabilities • “Out of the box” Interactive Reporting & Flash Charting… • Easy skill transition for existing Forms developers • Both are declarative wizard driven tools with no 3 GL compilation • Both are RAD SQL and PL/SQL centric development tools • Oracle APEX is a no cost Database feature • Requires only the Database

Oracle APEX Forms Conversion • Conversion Is • A way to Jumpstart an Oracle Forms to APEX modernization project • Automatic conversion of forms components that can be automatically converted to native APEX components • An easy way to browser your Forms application logic • A convenient tool to track manual conversion of Trigger and other non-convertible logic • Conversion Is Not • A “Silver Bullet” • A forms emulator • Hard to maintain computer generated code ** Oracle Forms is not going away and is still a valid platform for some customers

The Forms to APEX Conversion Project • Need to treat as a formal project • Prototype representative Forms • Create project plan • Analysis Scope • Design Refine business processes • Convert Iteratively as required • Post-Generation Build Web components • User Acceptance • Training • Utilize Application Express Annotations • Low-level assignment, tracking, progress reports

Forms to Oracle APEX Conversion Process

D E M O N S T R A T I O N Oracle Application Express Forms Conversion Demo

<Insert Picture Here> Oracle Application Express 4. 0

Oracle Application Express Listener

Oracle APEX Websheets • NOT a spreadsheet • Designed for Business Users • No Developers required • IT Administrator configures Workspace • Websheets saved as Metadata not Tables • Incorporates comprehensive “sharing” model • Includes validations, LOVs, column typing • No defined upper limits on number of rows • Can convert to APEX Application

D E M O N S T R A T I O N Oracle Application Express Websheet Demo

Next Steps Information: http: //otn. oracle. com/apex Hosted Development: http: //apex. oracle. com

Q& A