zero to sixty with oracle application express bradley d. brown tusc, cto
Post on 19-Dec-2015
214 views
TRANSCRIPT
![Page 1: Zero to Sixty with Oracle Application Express Bradley D. Brown TUSC, CTO](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d2a5503460f949ff4e0/html5/thumbnails/1.jpg)
Zero to Sixty withOracle Application Express
Bradley D. BrownTUSC, CTO
![Page 2: Zero to Sixty with Oracle Application Express Bradley D. Brown TUSC, CTO](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d2a5503460f949ff4e0/html5/thumbnails/2.jpg)
Zero to Sixty withOracle Application Express
• Turn on Your Laptop• http://localhost:8080/apex
• Create a Workspace– Internal, admin, pass– Request a Workspace– Any name, any schema
• Copy the CSVs off my flash drive
• While You’re WaitingLet’s Get Setup for the Class
• By Bradley D. [email protected]
![Page 3: Zero to Sixty with Oracle Application Express Bradley D. Brown TUSC, CTO](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d2a5503460f949ff4e0/html5/thumbnails/3.jpg)
Agenda
• Who am I?• What we could, but aren’t going to talk about• My assumptions• What we’ll talk about today• What we’ll do/develop today• What you’re going to do tomorrow
![Page 4: Zero to Sixty with Oracle Application Express Bradley D. Brown TUSC, CTO](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d2a5503460f949ff4e0/html5/thumbnails/4.jpg)
Who am I?
• Bradley D. Brown– http://bradleydbrown.bl
ogspot.com
• Founder TUSC, IntelliReal, 10+ other companies
• Professor – DU
• TUSC Today– Run TUSC Software– iPerspective
• Cross platform code generator
– ApEx provides a “quick turns” approach to our product
– You’ll see this…
![Page 5: Zero to Sixty with Oracle Application Express Bradley D. Brown TUSC, CTO](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d2a5503460f949ff4e0/html5/thumbnails/5.jpg)
What we’re not going to talk about – today is hands on…
• History of ApEx• Sample ApEx Apps• Product Positioning• Great/Bad for x, y, z• Installation• Configuration• Architecture, Scale
• Integration• Web Services (brief)• Advanced Topics
• The good news is I have Apex presentations on all of these topics – go to www.tusc.com to download
• Or see me at break, after, tomorrow, etc…
![Page 6: Zero to Sixty with Oracle Application Express Bradley D. Brown TUSC, CTO](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d2a5503460f949ff4e0/html5/thumbnails/6.jpg)
My Assumptions
• You know some SQL and PL/SQL, but you'll be OK if you don't - I'll give it to you
• You came here because you think ApEx might be good for your company
• You already have ApEx installed
• Today will get you excited about what you can do with ApEx
![Page 7: Zero to Sixty with Oracle Application Express Bradley D. Brown TUSC, CTO](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d2a5503460f949ff4e0/html5/thumbnails/7.jpg)
What We Are Going to Talk About Today
• Major Components– SQL Workshop– Utilities– Application Builder
• Workspaces• Applications• Regions
• Components– Shared– Items– Processes– Buttons– Branches– ….
![Page 8: Zero to Sixty with Oracle Application Express Bradley D. Brown TUSC, CTO](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d2a5503460f949ff4e0/html5/thumbnails/8.jpg)
Time to Log In
• http://localhost:8080/apex• Workspace– Name you chose
• Username– Your email address
• Password– You set it
![Page 9: Zero to Sixty with Oracle Application Express Bradley D. Brown TUSC, CTO](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d2a5503460f949ff4e0/html5/thumbnails/9.jpg)
Major Components
Application Builder
SQL Workshop
Utilities
![Page 10: Zero to Sixty with Oracle Application Express Bradley D. Brown TUSC, CTO](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d2a5503460f949ff4e0/html5/thumbnails/10.jpg)
SQL Workshop
• Object Browser– Look at emp table and
all of the tabs– Create lookup– Select other object types
– views, …– Other schemas– Create objects too
• SQL Commands• select * from emp where
deptno = :deptno• Show explain plan,
history and saved SQL
• SQL Scripts• Query Builder
![Page 11: Zero to Sixty with Oracle Application Express Bradley D. Brown TUSC, CTO](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d2a5503460f949ff4e0/html5/thumbnails/11.jpg)
Utilities
• Let’s load a file• DB Monitor• Comparisons
![Page 12: Zero to Sixty with Oracle Application Express Bradley D. Brown TUSC, CTO](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d2a5503460f949ff4e0/html5/thumbnails/12.jpg)
ApEx Environment contains Workspaces
ApEx Environment
HR Actg Purch
IT Maint Trans
![Page 13: Zero to Sixty with Oracle Application Express Bradley D. Brown TUSC, CTO](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d2a5503460f949ff4e0/html5/thumbnails/13.jpg)
Workspaces contain Applications
HR Workspace
App 1 App 2 App 3
App 4 App 5 App 6
![Page 14: Zero to Sixty with Oracle Application Express Bradley D. Brown TUSC, CTO](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d2a5503460f949ff4e0/html5/thumbnails/14.jpg)
Applications contain Pages
Application 1
Page 1 Page 2 Page 3
Page 4 Page 5 Page 6
![Page 15: Zero to Sixty with Oracle Application Express Bradley D. Brown TUSC, CTO](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d2a5503460f949ff4e0/html5/thumbnails/15.jpg)
Pages have Regions & Shared Components
![Page 16: Zero to Sixty with Oracle Application Express Bradley D. Brown TUSC, CTO](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d2a5503460f949ff4e0/html5/thumbnails/16.jpg)
Pages have Regions & Shared Components
![Page 17: Zero to Sixty with Oracle Application Express Bradley D. Brown TUSC, CTO](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d2a5503460f949ff4e0/html5/thumbnails/17.jpg)
Application Builder Terminology
Button
Item
Region
Navigation Bar
Tabs
Menu
![Page 18: Zero to Sixty with Oracle Application Express Bradley D. Brown TUSC, CTO](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d2a5503460f949ff4e0/html5/thumbnails/18.jpg)
What We’re Going to Develop(and Do) Today
• An Application from a Comma Delimited File
• An Application from Scratch– Interactive report– Graph– Form with a Report
• Advanced topics– Conditional display– Items– Session state– Templates– Processes– Security
• Monitoring activity
![Page 19: Zero to Sixty with Oracle Application Express Bradley D. Brown TUSC, CTO](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d2a5503460f949ff4e0/html5/thumbnails/19.jpg)
My Sample App
• http://localhost:8080/apex/f?p=104 • Try out the application– Interactive reporting
• Filters• Sorting• Download data• Paging
– Reports, Graphs (Analyze)
![Page 20: Zero to Sixty with Oracle Application Express Bradley D. Brown TUSC, CTO](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d2a5503460f949ff4e0/html5/thumbnails/20.jpg)
Create an Application from a CSV File
• Download the file from my app or use your own
• Home / App Builder• Note Import, Tasks,
Recent, Icons/Details• Click “Create”
• Create from Spreadsheet– Builds an App
• Create Application– Build from Scratch
• Demo Apps
![Page 21: Zero to Sixty with Oracle Application Express Bradley D. Brown TUSC, CTO](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d2a5503460f949ff4e0/html5/thumbnails/21.jpg)
From Scratch
• Design up front• Data already exists or
was loaded in table• Name it• From Scratch• Pick “base” schema
• Start adding pages– Blank– Report
• Table / Query• Interactive / Classic
– Form / Tabular• Table
– Master Detail– Report and Form
![Page 22: Zero to Sixty with Oracle Application Express Bradley D. Brown TUSC, CTO](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d2a5503460f949ff4e0/html5/thumbnails/22.jpg)
Adding Functionality
• Wizard or Scratch• Click “Create”– Page– Region– Control– Shared Component
• Conditional Logic
• Regions– HTML– Report– Form– Chart– Breadcrumb– PL/SQL– Tree– URL
![Page 23: Zero to Sixty with Oracle Application Express Bradley D. Brown TUSC, CTO](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d2a5503460f949ff4e0/html5/thumbnails/23.jpg)
Shared Components
• App Definition / Comments
• Logic – Web Services• Security– Authentication– Authorization
• Navigation– Tabs, Lists, etc,
• User Interface– Themes, LOVs
• Files– CSS– Images
![Page 24: Zero to Sixty with Oracle Application Express Bradley D. Brown TUSC, CTO](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d2a5503460f949ff4e0/html5/thumbnails/24.jpg)
Miscellaneous Functionality
• Export / Import• Tasks– Delete / Copy App– UI Defaults
![Page 25: Zero to Sixty with Oracle Application Express Bradley D. Brown TUSC, CTO](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d2a5503460f949ff4e0/html5/thumbnails/25.jpg)
25
Referencing Items
• Substitution String– #variableName#
• Short Substitution String– &variableName
• PL/SQL– v(‘variableName’)– nv(‘numericValue’)
• Bind Variable– :variableName
• Items can be used to:– Include a substitution string
within a template– Create an item at the
application or page level– Use built-in substitution
strings to achieve a specific type of functionality
![Page 26: Zero to Sixty with Oracle Application Express Bradley D. Brown TUSC, CTO](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d2a5503460f949ff4e0/html5/thumbnails/26.jpg)
26
Implicit Variables
• APP_SESSION • APP_USER • IMAGE_PREFIX • WORKSPACE_IMAGES • APP_IMAGES • BROWSER_LANGUAGE • PRINTER_FRIENDLY • HOME_LINK • PROXY SERVER • REQUEST • SYSDATE_YYYYMMDD• DEBUG
• APP_ID • APP_PAGE_ID • APP SCHEMA OWNER • SQLERRM • AUTHENTICATED_URL_PREFIX • LOGOUT_URL • PUBLIC_URL_PREFIX • CURRENT_PARENT_TAB_TEXT • APP_ALIAS • APP_UNIQUE_PAGE_ID
![Page 27: Zero to Sixty with Oracle Application Express Bradley D. Brown TUSC, CTO](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d2a5503460f949ff4e0/html5/thumbnails/27.jpg)
27
Built-in Monitoring
• Chart activity by application• Chart non internal user views• Chart of developer activity• Chart page views by day• Chart page views by non internal
users (with time filter)• Monthly calendar report
• Page Views by Hour• Page views report aggregated by
workspace• Recent page views (with optional
workspace filter)• Top Browsers• Top External Sites• Top Users• Top Workspaces
![Page 28: Zero to Sixty with Oracle Application Express Bradley D. Brown TUSC, CTO](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d2a5503460f949ff4e0/html5/thumbnails/28.jpg)
Web Services
• iPerspective• Shared Components• Web Services
• Like a remote procedure call
• Calling other systems as if they are on the same system
• Open API• SOAP, XML, JSON
![Page 29: Zero to Sixty with Oracle Application Express Bradley D. Brown TUSC, CTO](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d2a5503460f949ff4e0/html5/thumbnails/29.jpg)
What You’re Going to Do Tomorrow
• Sign up on apex.oracle.com and move your application onto there– Import your app– Let’s export it now
• Work on your laptop• Attend advanced
topics / presentations
• Read, learn, study, play with ApEx
• Have fun!!!!
![Page 30: Zero to Sixty with Oracle Application Express Bradley D. Brown TUSC, CTO](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d2a5503460f949ff4e0/html5/thumbnails/30.jpg)
Questions?
![Page 31: Zero to Sixty with Oracle Application Express Bradley D. Brown TUSC, CTO](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d2a5503460f949ff4e0/html5/thumbnails/31.jpg)
Copyright Information
• Neither TUSC nor the author guarantee this document to be error-free. Please provide comments/questions to [email protected].
• TUSC © 2010. This document cannot be reproduced without expressed written consent from an officer of TUSC.