Geographical, monetary or otherwise - some of us simply can't make it to the conference every Oracle developer should do at least once, or so I've heard.
For those of us stuck at home we do have some options.1) ODTUG offers a LiveStream of selected presentations.
I stayed up past my bedtime to watch Patrick Wolf introduce the APEX 5.0 Page Designer. I look forward to watching the recording of Shakeeb Rahman (more...)
After last night's teaser I thought I'd try apexea.oracle.com again to see if EA2 was ready, and it is!
|and it looks darn sexy|
Confirmed in Twitter by some big-wig APEX dude at Oracle
I've had bit of a play and it it's very impressive - plenty (more...)
is just days away from kicking off and hours after I realised the live stream of Patrick Wolf's APEX 5.0 Page Designer
presentation was actually at a reasonable Perth hour (9:30pm), I found out I wasn't going to be home to watch it - darn it!
Luckily in this age of the internet there are other reasons to get excited. Tonight while I continued to write my Prezi on how APEX 5 will (more...)
SQL Analytics provides a fairly simple mechanism for determining positional rank within a set of results.
Before I demonstrate that query - which is already found in many good libraries
- I thought I'd show how we could take it a step further and add the ordinal suffix (st, nd, rd, th) to a result.
We can do this using date format masks
with placing as (select rownum rn from dual connect by level < (more...)
SQL analytics can be used to generate break columns in your queries, without the need for break formatting attributes in APEX or the old fashioned break on
option in SQL*Plus.
I came across an example recently where I wanted to apply the break formatting in my query to avoid extra sub-totals from being displayed after each break.
|No sub-totals please|
I could use jQuery to hide the rows instead of modifying them
, but as (more...)
Truth be told, the default "no data found" message for APEX reports is pretty boring.
|Out of the box|
Even the default wording irritates me just a little bit every time I see one amidst a page I thought was looking pretty snazzy.
There are two things I've done recently to make it look a little better.1) Surround it with a nice soft coloured box.
|Something with a little pop|
My experience patching Oracle APEX v4.2.1 to 4.2.3 on my Windows 7 laptop.
Personally my main driver for this is to experience the updated themes and templates. I'd also like to explore the packaged applications and see if any of the dynamic PL/SQL regions have been converted to templates.
I already had 4.2.1 installed and before the patch was available to me I thought I'd try running scripts (more...)
This latest analysis on the population of mobile device technology got me thinking more about the typical sized screen you might encounter as a global web developer.
So it's looking at 2014 Quarter 1 shipment of nearly 280 million smartphones. 81% are now android, only 16% related to Apple - that next iPhone better be (more...)
A common bug-bear
for me is the large distance on web pages between the browser toolbar and the start of any real content on the page.
I remember providing feedback during a tryapexnow beta release on the issue
|Gimme content without scrolling!|
I can't expect too much - while news websites are frequent offenders for this, newpapers have also been doing it for years.
Today I (re?)discovered how to make these buttons (more...)
I'm not a huge user of Firefox anymore. My exodus from IE brought me to Firefox, but then Chrome came along and I've been happy ever since.
That's quite analogous to my mobile telephone experience - starting with Nokia, big jump to first generation iPhone, now happy with Android.
I still use Firefox, but only so I can have a separate browser with an independent development builder session for Oracle APEX development. The FireFTP extension (more...)
This post was inspired by a question
on the OTN APEX forum, which contains requests for two fairly common scenarios:
1) A select list dependent on another select list
2) A report the updates based on the selections.
The original post submitted the page after each select change - APEX 4.x makes this unnecessaary thanks to cascading select lists
And the report can also be refreshed without submitting the page thanks to Dynamic Actions