Category Archives: APEX

KScope 14 Wrap-up – APEX 5 Highlights

Aside

I am just back from KScope14 in Seattle, WA – what a week. No “Low-T” here!

APEX 5.0 Early Adopter 2 was featured on Sunday by the Oracle APEX team, after which I was able to complete prep for my APEX Interactive Reports, The Good, The Bad and The Ugly, Revisited.  I demoed APEX 5 IR new features, including multiple IRs on a single page with links between those reports – we now have a simple way to quickly generate dashboard-like layouts.  The big news with IRs in APEX 5 is Change – there is a new scheme of classes and Id’s for the IR elements – the old apexir_* set are gone.  There is completely new jQuery widget that controls IRs – sooooo… any custom code – dynamic actions, plugins, javascript, whatever – that does not use the standard API’s will need to be refactored.  I’ll be posting more in APEX 5 Interactive Reports in the coming week.

There were many highlights – APEX 5, great sessions, an awesome party at EMP, great people.  A standout for me was seeing Mike Riley there, smiling, and receive the ODTUG Volunteer of the Year Award – Congratulations Mike!  To read more about Mike Riley, and his journey in life and with ODTUG, see the ODTUG Technical Journal Corner.Volunteer Spotlight by John King.

While there check out two articles on SQL Developer – one by Jeff Smith, on making your job easier with SQL Developer, and one from Galo Balda, Using SQL Developer to Work With GitHub.  Great stuff, by two great people.

 

Aside

 

 

 

Image

RMOUG  – Rocky Mountain Oracle User Group – 2013 is around the corner – check out the RMOUG 2013 Training Days for more information. I’ll be presenting on Tabular Form Terrors and How to Overcome Them – updated APEX tabular form information, with guidance on how to build some of those out-of-the-sandbox features that are not readily built by existing wizards and dynamic actions. See you there!

APEX Data Load Options – How Do I Load Data …

Posted on by
Reply
How to Load MS Excel Data into APEX?

The most common APEX data load problem….how to load MS Excel files as XLS, not as CSV.

There are as many ways to load data into an Oracle database as … well, there are a lot of them.  When building an Oracle Application Express application, there are some data load options that are more suitable than others.  This presentation outlines the standard APEX-supplied data load options, explores the APEX Data Load wizard, and discuss how to integrate some more traditional Oracle data load options into your APEX applications.  This is by no means an inclusive view of all the possibilities, but some of these options will give you ideas on how best to approach your data load issues.

Download the presentation here:  APEX Data Loading Options

RMOUG 2012 Coming Up Feb 14-16,2012

Posted on by
Reply

Image

I will be speaking at RMOUG – the Rocky Mountain Oracle User Group annual Training Days February 14-16, 2012 in Denver CO.  This is a great conference – tons of learning packed into two full days.  Followed by a few of skiing, for those so inclined.

How to Load Data – Let me Count the Ways – This presentation reviews various data loading options for Oracle Application Express (APEX) applications, including the new Data Load wizard/component and the APEX Listener XLS upload. How hard, or easy, is it to use various data load options? Which works best for which incoming data types? You’ll learn the pros and cons of each, enough to make intelligent decisions for your data loading needs.

See the RMOUG website for more information on RMOUG Training Days 2012.

See you there!