An occasional question in the forums relates to issues ordering a particular column. It's one of those things that will probably keep coming up, so it's worth having another reference out here on the web.
The basic example stems from the need to order data that might contain characters.
with data as (select '1' vc from dual union all select '11' vc from dual union all select '2' vc from dual union all select 'a' (more...)
My sister sent me this video not long after my daughter was born earlier this year - I finally watched it while cleaning up e-mails and I'm glad I did - I highly recommend you all take 2 minutes aside and just let these images of history wash through your brain.
If you think the first half had an air of familiarity, you might be thinking of this video from Carl Sagan - I certainly (more...)
I stumbled across a blogging milestone while fact checking what I was going to open this post with - for me this month represents 5 years of blogging.
In that time I've learnt heaps, met new people, changed blog name, visited other cities to speak, and dived deep into APEX after a long time in Oracle Forms, published a video series & was recognised as an Oracle ACE.
Turns out Packt Publishing are celebrating (more...)
KScope14 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...)
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 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.
Today I watched Europa Report - a movie that plays the same sport as Gravity, but seemed to go straight through to the keeper since I only heard about it while listening to a science podcast - which I think was StarTalk Radio hosted by the charismatic Neil deGrasse Tyson - of recent Cosmos fame.
Anyway - bloody brilliant movie. If you liked Gravity, you'll like this. And it does a fairly good (more...)
Quite a few times I see a questions regarding how to share authentication between Oracle APEX applications so the user does not need to log in a second time.
As long as your link between the applications share the session ID, the solution is simple - set the cookie name the same across your applications. Shared components -> Authentication Schemes -> Edit current scheme -> Session cookie attributes -> Cookie Name