progressive skill n.
Skip this Video
Loading SlideShow in 5 Seconds..
Progressive Skill PowerPoint Presentation
Download Presentation
Progressive Skill

Loading in 2 Seconds...

play fullscreen
1 / 96

Progressive Skill - PowerPoint PPT Presentation

  • Uploaded on

Progressive Skill. Who Are We?. We are a full services Business Consulting and Internet Technology Company. Our mission is to improve business process and or generate net income for our customers.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

Progressive Skill

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
who are we
Who Are We?

We are a full services Business Consulting and Internet Technology Company.

Our mission is to improve business process and or generate net income for our customers.

We focus on database driven solutions leveraging ‘open source code’ models so that our customers are not ‘Hostage’ to the technology.

rapid application development
Rapid Application Development
  • Quick Development of Software Applications
  • Visual Tools for Development
  • Very Little Custom Coding/Programming
  • Easier to Manage Code and Functionality
  • Faster Testing and Debugging
  • Simpler Collaboration among multiple skill sets
  • Shorter Timelines Lower Budgets
  • Greater Flexibility with changing/adding requirements
  • APEX Defined
  • Uses – who, what, when, where, why
  • Building applications with APEX
  • APEX Administration and Monitoring
  • Tips and Techniques
what is apex
Oracle’s answer to “Wizards”

Meta Data (lots of it!)

Dynamic HTML (fast!)

PL/SQL - No Java

Does anything you can do in SQL or PL/SQL

Nice Web-based team development environment

What is APEX?
it s origin
It’s Origin
  • Originated from Tom Kyte’s “ASK TOM” site
  • Used mod_plsql to develop
  • Became “Project Marvel” then HTML DB
  • Now it’s APEX
  • Also referred to as Einstein
you re a good candidate for apex if you fit the following profile
You’re a good candidate for APEX if you fit the following profile
  • You are, or have developers who are, skilled in SQL and PL/SQL
  • Your application is database-centric
  • Your application can be developed using a hosted service
  • You are comfortable with a declarative/4GL programming model
  • You want to migrate an Access / Excel application to Oracle

5,500 active workspaces

Dell 6550 4x2.0 Ghz Xeon Processors


Red Hat AS 2.1

5,500+ schemas

DB Size ~75 GB

SGA(System Global Area) Size ~1.5GB

Average Unique Page Views: 25,000+ per weekday

Average Page View Time: <.5 seconds

1 DBA – manages 15 other DBs

major components
Major Components
  • Administration
  • SQL Workshop
  • Application Builder
SQL Workshop

Interact with your database as with SQL*Plus, but visual

Data dictionary and object browsing, query by example


Manage users

Manage services

Monitor activity

Application Builder

Centerpiece of APEX

Loaded with wizards

Reports, forms and charts

Connect pages using branches

75 pre-defined widgets

Basic HTML, pop-up lists, calendars, etc.

Full data entry validation

more features
Session and State Management

Each user has a session

Valid username/password is required

User Interface Control

Look-and-feel is separate from application logic

Extensive templates

Flexible Authentication and Authorization Schemes

Can use pre-built / built-in methods or custom

More Features
installing apex
Apply for a free account at

Set up other developers / users for testing

Can optionally download and install locally

Run the script on your 9iR2 or better database (also need Apache listener)

Down / Upload your applications to your home system

Continue development on your home system

Oracle 10g Companion CD

Oracle Express Edition

Develop your application (read the Help messages – they really do help!)

Excellent support via OTN discussion forum

“Installing” APEX


Oracle HTTP


Oracle Database


architecture b
Architecture B



Oracle HTTP Server

Oracle Database


Instead of the Oracle HTTP Server, you can use the HTTP Server supplied with Oracle Application Server 9i or 10g

apex uses


Who, What, When,

Where, Why…

what can you do with apex
What can you do with APEX?
  • Select Journal Article review system (developed in 2 weeks)
  • Web Collaboration application (developed in 2 days)
  • General purpose Customer Survey (developed in 1 day)
  • Survey Administration screens (developed in 2 hours)
log into workspace
Log into Workspace
  • Use the Workspace you chose, the username and password emailed to you
home menu
Home Menu
  • You’re ready to begin
    • Build Applications
    • Work in SQL
    • Work with Data
    • Manage users
migrate data
Migrate Data
  • Import data from Spreadsheets, XML or Delimited Files
load northwinds
Load Northwinds?
  • I loaded the Northwinds Database from SQL Server
  • Used Periscope to load/copy data
  • Once loaded, view data using SQL Workshop
drill and create
Drill and Create
  • Can
    • Drill into data
    • Count rows
    • Insert/Edit rows
    • Query by Example
    • View components
    • Much more…
use the wizards
Use the Wizards
  • APEX’s many wizards will simplify your life – use them!
  • Reports, Charts, Forms, Calendars, Trees, etc.
building an application from scratch in 5 simple steps
Building an application “from scratch” – in 5 simple steps
  • Login with developer privileges
  • Use the SQL tools to make your tables, constraints, triggers, procedures etc.
  • Start a new application (use the wizard)
  • Customize the application (check each change as you make it)
  • Deploy to the users!
example hardware inventory app
ExampleHardware Inventory App
  • Record and view hardware inventory
  • Searchable report
  • Present analysis graphically as well as numerically
  • Design for novice users
  • Remote users with access to Internet
converting data
Converting Data
  • Previously, data was stored in an Excel spreadsheet
  • Conveniently, this can be made into an Oracle table by simply copying and pasting into the APEX create table wizard
  • Select Region
  • Copy from Excel
create lookup table
Create Lookup Table
  • Select column for look up
  • Specify lookup table specifics
add report and form based on hardware table
Add Report and Form based on Hardware table
  • Notice inclusion of Analysis pages
instant application
Instant Application!
  • Searchable report
  • Links to edit individual rows
instant application1
Instant Application!
  • Edit form with
    • Calendar widget
    • Picklist based off lookup table
instant application2
Instant Application!
  • Analysis Chart and Report
good start but improvements can be made
Good start but improvements can be made
  • Makes “codes” more meaningful
  • Format output

Edit page through edit link

elements of a page
Elements of a Page
  • Shared Components
    • Tabs
    • Navigation bar
    • Templates
  • Regions
    • Items
    • Labels
    • Buttons
    • Widgets
most things are created through wizards
Most things are created through WIZARDS
  • Step by step
  • Collect essential info
everything has attributes and almost everything has an edit page
EVERYTHINGhas attributes and almost everything has an edit page

All of the basic attributes collected through the wizards, and many more detailed attributes are editable through an elements attribute/edit page. All of this information is called Meta Data.

attribute edit pages
Attribute/Edit Pages
  • Attributes in regions by logical groups
  • Quick navigation to each region
  • Many items are select lists
  • Almost all have context sensitive help
reuse of shared components
Reuse of Shared Components

LOV used for both report and edit

easy data validation
Easy Data Validation
  • Some validation created automatically based on database.
  • Others easily created with wizard.
validation wizard
Validation Wizard
  • Choose the item
  • Specify the validation type
validation wizard1
Validation Wizard
  • Choose subtype
  • Specify sequence and where error message is to be displayed
validation wizard2
Validation Wizard
  • Depending on method, provide validation details
  • Specify error message
  • Always look for help provided
    • Examples
    • Item lookups
most things can be conditional
MOST things can beCONDITIONAL!
  • Many, many different types of conditions available.
  • Item is displayed or processed depending on the outcome of the condition.
  • Message displayed by item, central location or both
  • Navigation not allowed until validations pass
  • Two levels
    • Authentication, controls initial access to the application
    • Authorization, can control access to tabs, pages, regions, items, buttons, read/write vs read only, …..
  • Use APEX built in functionality, totally custom or somewhere in between.
deployment process




(Periodic Refresh)



Deployment Process
apex administration
APEX Administration
  • Administrator controls Workspaces
  • Workspaces control developer access and provide resources.
apex administration1
APEX Administration
  • Workspaces can be requested.
  • Workspaces are “provisioned”
  • Initial users are created, more can be created by the “workspace” administrator
  • Workspaces/Applications can be monitored.
workspace administration
Workspace Administration
  • Workspace administrator manages services
  • Creates and alters workspace / application users
  • Monitors Activity
workspace administration1
Workspace Administration

Many reports and charts are available to monitor workspace activity.

Many application reports are also available (to developers also)

sample applications
Sample Applications
  • The Sample Applications have great examples
  • Take some time to understand the applications
  • Standard Sample – Common Concepts
spend time on analysis design
Spend Time onAnalysis/Design
  • Time Well Spent
    • Follows standard design principals
    • Storyboard approach makes it a visual process
  • Pay me now or pay me more later…
    • Poor design, results in a poor application
      • Important to understand Web development to design
storyboard design

Home Page










Storyboard Design
  • Take the time to map our your tabs, menus, layout and design
  • To view the current value of any object (if you’re a developer), you can click on the session button at any time
  • The online help that is available is very well written as a reference
  • The OTN Discussion Forum is very helpful!

creating a popup
Creating a Popup
  • You can specify a TARGET=NEW for an href if you want the URL / Link to pop up a new page when clicked
  • This is useful when referencing other sites
adding images
Adding Images
  • To add images, static HTML / Docs and CSS files to the application, click on
    • Shared Components
      • Images
      • CSS
      • Static Files
advanced topics
Advanced Topics
  • Debugging
  • Using Collections
  • Authentication & Authorization
  • Administration
  • Deployment Process
  • Available Functions & APIs
  • Monitoring Activity
  • Run any page in your application
  • Turn on debug mode by clicking on Debug in the developer toolbar
  • Timing is processor time, not rendering time
  • Append &p_trace=YES to your URL to generate SQL Trace File

using collections
Using Collections
  • Enable you to temporarily capture rows and columns of data
  • Data is persistent throughout a users unique session
  • Examples of when to use a collection:
    • A wizard with more than one page
    • A shopping cart application
authentication authorization
Authentication & Authorization
  • Establish User Identity Through Authentication
  • Provide Security Through Authorization
  • An HTML DB Administrator’s main task is to manage the instance of HTML DB
  • Monitor Activity to ensure good performance
  • Some common tasks include
    • Approving Service & Change Requests
    • Managing Schema to Workspace Mappings
    • Managing Schemas & Tablespaces
    • All Other Associated DBA functions

apex summary
APEX Summary
  • For additional information, check out:
  • Externally Hosted Instance
      • OTN Discussion Forums
      • HTML DB “How To” Documents
  • &variableName is used when you need to substitute a variable as when you are building a link to another page
  • You often need to place a period at the end of the name
  • For example:
    • f?p=&app_id.:2:&session

Relatively Easy



Really works


where to get more information
Where to Get More Information
  • Oracle Press, “Oracle HTML DB Handbook” by Lawrence C Linnemeyer and Bradley D. Brown