Transcript Introduction to APEX

Introduction to APEX
Slide 1
Agenda
• Introduction to Apex
• Architecture/Workspace
• Highlights
• Roles
• Example
• Build Report
• Examples of Flexibility
• Summary
Slide 2
Introduction to APEX
•
•
•
Oracle Application Express is a rapid Web
application development tool for the Oracle
database.
Using only a Web browser and limited
programming experience, you can develop
professional applications that are both fast and
secure.
From the end user’s perspective, the deployed
applications require only a browser and access to
an Oracle database running Application Express.
Slide 3
Architecture
Slide 4
Workspace
• A workspace is a virtual private database
allowing multiple users to work within the
same Oracle Application Express installation
while keeping their objects, data and
applications private.
Slide 5
Workspace
Slide 6
APEX Highlights
•
•
•
•
•
•
•
•
Free(Licensed with Enterprise Database)
With 10G Oracle Enterprise manager is built with
APEX
New Metalink (My Oracle Support) also built in
APEX
Installed on EBS database (No Database user layer)
Easy and Quick to use
Powerful
Professional look
Export to excel
Slide 7
APEX Highlights
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
Reporting
Forms
Charting
PDF Printing
Web Services
Spreadsheet Upload into database
Session State Management
User Interface Themes
Flow Control & Navigation
Conditionality on all Components
External Interfaces & Extensibility
SQL Workshop Tools
Supporting Objects Utility
Performance
Packaged Applications
Hosted Development
Slide 8
APEX
•
•
•
Does not use EBS security by default
Require some technical knowledge/training
Reports requiring specific layout
(Payslip/Invoice) – outbound documents
Slide 9
Roles
• Administrator
– Administers users/workspace
• Developer
– Creates applications/reports
• User
– No development privileges
Slide 10
APEX
• Application Builder
– Reports
– Forms etc.
• SQL Workshop
– Use the SQL Workshop to access tools for viewing and
managing database objects.
• Utilities
– Use Utilities to load and unload data from the database,
generate DDL, view object reports, restore dropped
database objects, and monitor the database.
Slide 11
Application Builder
• Reports
– Create simple report
•
•
•
•
Template
Regions
TABS
Attributes
– Headings
– Sorting
– Totals
• Export to excel
• Person Type Report – adding paramaters
Slide 12
Application Builder
• Adding Reports as URL
– Can add URL as a menu item to a EBS
responsibility
•
•
•
•
•
Sample Application
Absence Report (in development)
XXTEST Pivot
MS WCA
MS TCOE Variance
Slide 13
Summary
• Rapid Report Deployment
• Empower your Company
• Turnaround time
– Email a script
• Ability to copy existing reports and modify
Slide 14