Introducing 

Prezi AI.

Your new presentation assistant.

Refine, enhance, and tailor your content, source relevant images, and edit visuals quicker than ever before.

Loading…
Transcript

WORKSHOP

Spice up your APEX application

Scott Wesley

with third party plug-ins

Consulting

yes, you may just listen in

APEX

Forms

Laptop with

Wireless access to

PL/SQL

Reports

SQL

ADF

(

)

Training

OR

AND

APEX 4.2

Supporting files

wifi: sage workshop/sage13

goo.gl/yMEPd

url: floyd:8080/apex

Today's menu

Butter chicken

Easy to install, quick win

Tikka masala

Simple yet elegant

Jungle curry

Robust & productive

Unicorn meat

What is a 'plug-in'

Install it yesterday

thinkgeek.com

PL/SQL

* SQL Dev extension

* MS Word add-in

* Browser extension

* Mobile application

Item plug-ins

Before this happens...

  • Star Rating
  • Group by Select
  • Caps-Lock check
  • Modals
  • Date/Time
  • HTML5 Extensions
  • Advanced autocomplete
  • Masked Text
  • Google reCaptcha
  • Facebook Like

functional

Dynamic Action plug-ins

  • Sparklines
  • Modals
  • Loading...
  • Dynamic Quick Picks
  • Session Timeout
  • Save before exit
  • Tooltips
  • Context (right-click) Menu
  • IR Extensions
  • CLOB Load

interactive

Plug-in Types

I want to cover 3 things

iamparagon.com

Region plug-ins

  • Navbar
  • Embedded PDF
  • Label Cloud
  • Gantt Chart
  • Google Visualizations
  • Image Slider
  • Advanced Calendar
  • Facebook comments
  • jQuery lists
  • Maps

visual

Consumer

vs

Creator

Process plug-ins

and some of us dabble in extending existing enterprises

http://www.grassroots-oracle.com/2013/04/extend-apex-sparklines-plugin-bullet.html

  • Excel to Collections
  • Report to PDF
  • Report to Excel/XML
  • Geocoding
  • Twitter

apex bullet sparklines

APIs

Authentication

Security plug-ins

modular

Authorisation

z

Now claim a workspace!

http://floyd:8080/apex

(or BYO environment)

Session 1

  • Caps-Lock
  • Excel to Collections

Session 2:

  • Gritter notification
  • Navbar
  • Dynamic Quick Picks
  • Modal

We learned:

  • Super LOV
  • Plug-ins are awesome

By now...

  • You are thinking of ideas
  • You are keen to learn more
  • APEX 3.x should be a faded memory

</ apex_plugins_workshop >

-- Scott Wesley

sagecomputing.com.au/workshops

sagecomputing.com.au/training

grassroots-oracle.com

We learned:

  • Not always install, wizard, go!
  • Plug-ins are even

more

awesome

www.packtpub.com/content/oracle-apex-techniques/video

http://goo.gl/TT8Rw

Session 3:

  • Group by Select
  • Loading...
  • Sparklines
  • Star rating

can re-engineer for :

APEX v3.2

> 50 columns

Learn more about creating dynamic, engaging presentations with Prezi