960 likes | 1.23k Views
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.
E N D
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 • 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
Agenda • APEX Defined • Uses – who, what, when, where, why • Building applications with APEX • APEX Administration and Monitoring • Tips and Techniques
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 • 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 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
APEX.oracle 5,500 active workspaces Dell 6550 4x2.0 Ghz Xeon Processors 6 GB RAM 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 Scalable?
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 Administration 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 Components
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
Apply for a free account at apex.oracle.com 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
Architecture Browser Oracle HTTP Server Oracle Database APEX
Architecture B Browser Firewall Oracle HTTP Server Oracle Database APEX Instead of the Oracle HTTP Server, you can use the HTTP Server supplied with Oracle Application Server 9i or 10g
APEXUses Who, What, When, Where, Why…
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)
Creating an APEX Application Generally speaking
Log into Workspace • Use the Workspace you chose, the username and password emailed to you
Home Menu • You’re ready to begin • Build Applications • Work in SQL • Work with Data • Manage users
Migrate Data • Import data from Spreadsheets, XML or Delimited Files
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 • Can • Drill into data • Count rows • Insert/Edit rows • Query by Example • View components • Much more…
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 • 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!
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 • 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 • Select column for look up • Specify lookup table specifics
Add Report and Form based on Hardware table • Notice inclusion of Analysis pages