Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.

No, thanks

Reasons why you should upgrade your APEX environment

Discover how APEX 4.x makes your life easier
by

Scott Wesley

on 8 May 2014

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Reasons why you should upgrade your APEX environment

Security
Tabular
Forms

Charts
ApexLib
Websheets
jQuery
Dynamic
Actions

Error
Handling

Mobile
Data Upload
Ptilonorhynchus violaceus
Bower bird
oracle
validations
Marvel 2002
Apex 2.1 2006
HTMLDB 1.5 2004
Apex 3.1 2008
Apex 3.2 2009
Apex 4.0 2010
Apex 4.1 2011
Apex 4.2 2012
bloggers
community
Get active to learn faster
otn apex forums
apexblogs.info
pl/sql challenge
(apex series)
twitter
local user group
apex-plugin.com
custom item types
processes
region types
dynamic actions
security
trees
google visualisations
menus
mapping
cloud labels
super LOV
mobile html5 items
multi media
password
group by lov
reCatpcha
star rating
masks
geocoding
interface to
external APIs
(eg: social media)
jasper report tunnel
security
(mapping x math)
enhanced dialog boxes
nifty tooltips
session time out
interactive report UI
notifications
(fading pop-up post ajax)
(eg: freeze columns / headers)
models
authentication
authorisation
_
dialogs
item components
interactions
mobile
(>= apex 4.2)
(eg: datepicker, tabs,
(drag / drop)
autocomplete)
(modal forms)
non-flash charts
decent
basic html charts
SVG -> AnyChart
blogs
documentation wiki
away from MS Access
pass to the "speakers lounge"
(ahem)
now part of 4.0
feature list
performance
ajax
item attributes
advisor
Sage Computing Services
Reasons why you should
upgrade your APEX environment
Scott Wesley
Systems Consultant & Trainer
AUSOUG Committee Member
Discover how APEX 4.x makes your life easier
quality,
user-friendly
software
productive
supported
happy
latest
libraries
happy
developers
elevator
pitch
Apex 5.0 2013?
Apex 3.0 2007
HTMLDB 1.6 2004
Flows circa 1999
HTMLDB 2.0 2005
themes
Oracle XE 10g
charts,
PDF,
Access
interactive reports
dynamic actions
mobile
error handling
html5 printing modals ?
Mike Hichwa
SkillBuilders
Excel2Collections
modals
Due process
First step:
Backup
Regression
testing
- (5s) Stop APEX Listener
- (19m) Run install script
- (15s) Restart listener -> new images
My laptop:
@apexins.sql apex apex_files TEMP /i/
java -jar apex.war standalone --apex-images \apex4.2\images
http://www.grassroots-oracle.com/2012/10/upgrading-to-apex-42-in-three-steps.html
jQuery differences
Re-theming considerations
Images transfer
Web Listener upgrade?
- Upgrade advisor
- OTN Forums
- Limited jQuery

- Pros out-weigh cons
browser data
SQL & PL/SQL
common
interaction
http://apex.oracle.com/pls/apex/f?p=
24122
any jQuery plug-in + List Templates = lotsa goodies
External table
Pipelined PL/SQL Function
Stage table
- validation completed
http://www.inside-oracle-apex.com/apex-4-1-error-handling-improvements-part-1/
Patrick Wolf
css only
Roel Hartman
common
Sensei Yari
Clarifit
FOEX
plugins
Oracle XE 11g
Scott Spendolini
"APEX Adolescence"
4.1
4.2
5.0
support
no support
2012
2016
2015
2017
I wonder if Forms is
$(jQuery)
extinct?
plug-in
java bean
navigator
modeler
dvt
ADF faces
mobile
struts
martin
minimised harm
pay attention to slides with these:
theme list grows to reduce impact
behavioural
differences
legacy themes were mostly visually different
your CSS skills will improve
APEX applications are


during upgrade
largely untouched
only until you want to change theme
@media
2.x, 3.x
-- 5.h
mobile - jQuery
responsive - CSS
hardware integration plug-ins - culture
feature requests - community
murphy's law
in soviet russia, apex upgrades you!
jDeveloper
apexblogs.info
OTN APEX Forum
#orclapex
=>
4.x
?
2.x, 3.x
=>
4.x
?
unsupported
dynamic actions
plug-ins
:goto documentation
then directly to 4.2.1
!
20cm + 1cm => 128cm
2
diameter
value
Oracle APEX Documentation
Anthony Rayner
Patrick Wolf
enhancements bolted into 3.x
Peter Raganitsch
Denes Kubicek
tiliqua rugosa
bobtail lizard
app
page
+ authorisation scheme
management refurbish
instance (+ more)
+ APEX Listener procedure validation
community
example from skillbuilders
NASA Hubble optical correction
STS-61
$
"forums.oracle.com"
looks good... handles 'typical' cases
Interactive
Reports
e-mail subscription
icon view
detail view
shareable saved reports
+ improved import/export
enhanced filtering
- public only, no inbetween
+ very dynamic
change control
- ripe for further work
- lacks granularity
webinars
user friendly
ROI
training
grassroots
-oracle.com
@swesley_perth
Scott Wesley
SAGE Computing Services
(20 year anniversary approaching!)
UPGRADE
~1/2?
Oracle
Plug-ins
$s('P1_ITEM', 123);
$v('P2_ITEM');
"Page Items to Submit"
"Page Items to Return"
anthonyrayner.blogspot.com
www.danielmcghan.us
dpeake.blogspot.com (david)
deneskubicek.blogspot.com
dgielis.blogspot.com.au (dimitri)
douggault.blogspot.com
insum-apex.blogspot.com.au (francis mignault)
jes.blogs.shellprompt.net (john scott)
joelkallman.blogspot.com
marcsewtz.blogspot.com
oracleinsights.blogspot.com.au (mark lancaster)
michaelhichwa.blogspot.com
www.inside-oracle-apex.com (patrick wolf)
roelhartman.blogspot.com
spendolini.blogspot.com.au (scott)
www.apex-at-work.com (tobias arnhold)
tkyte.blogspot.com (tom)
tylermuth.wordpress.com
www.talkapex.com (martin giffy d'souza)
dbswh.webhop.net( jari laine)
grassroots-oracle (scott wesley)
apexblogs.info
krisrice.blogspot.com
christopherbeck.wordpress.com
chrisonoracle.wordpress.com (neumüller)
jastraub.blogspot.com.au (jason)
c2anton.blogspot.com.au (nielsen)
carlback.blogspot.com.au (backstrom)
nerd.net.au (amanda walsh)
www.apexninjas.com (george & claudiu)
djmein.blogspot.com (duncan)
monkeyonoracle.blogspot.com (håvard kristiansen)
rokitta.blogspot.com (christian)
blog.theapexfreelancer.com (matt nolan)
oraclequirks.blogspot.com (flavio casetta)
daust.blogspot.com (dietmar)
munkyben.wordpress.com (ben burrell)
plsql-challenge.blogspot.com (steven feuerstein)
apexbyg.blogspot.com (marko goricki)
apexjscss.blogspot.com (robert)
jeffkemponoracle.com
apex-plugin.com
Full transcript