Thursday Thought: Boredom

Do you ever get bored? I do.

What do you do when you're bored? I eat. I think. I watch.

Sometimes I play on my phone. I whip it out, play some quizzes, read some feeds, send a text.

What I prefer to do is watch the world. There's plenty going on, I walk through a nearby bush regularly and sometimes it's almost like I'm absorbing pleasantness, contentment.

I saw a commercial a few months (more...)

Perth – Free 1/2 day Education Event

Thanks to Sage Computing Services, AUSOUG are hosting a free 1/2 day education event for it's members.

Join us Wednesday 19th August, 2015 at the Duxton Hotel from 2:30pm to be regaled with tales of tuning, APEX, SQL and PL/SQL.

  • Penny - Practical Tuning Tips for Developers
  • Kylie - Snazzy SQL: Titbits to advance your code
  • Katie - PL/SQL: Are you making the most of it?
  • Scott - APEX 5 isn't just a sexy (more...)

My Kscope15 sessions

My Kscope15 sessions are now available on my presentations page.

I linked to the Prezi version as they don't translate well to PDF, as those of you who tried downloading off the Kscope mobile app may have found.

The supporting code from my deep dive demos can be downloaded here:
http://sagecomputing.com.au/workshops/jquery_workshop_code.sql

Thank you to all those who attended, and cheers for all the great feedback, I sincerely appreciate it. I wish I (more...)

Podcast recommendation: SGU

Another item on my backlog is getting up to date on my favourite podcasts. I've got a post drafted that lists my recommendations, but if you're looking for a fun, well produced science podcast then go no further than The Skeptics Guide to the Universe.

They are generally 90 mins an episode and if you're not into podcasts already that may seem daunting. To me they fill my commute with fun but thought provoking stuff (more...)

Exploring dynamic pivot options

In looking for information on pivoting variable number of columns, I stumbled across a question I once managed to AskTom, many moons ago.
https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:7644594042547

Adrian Billington has an interesting lead into an XML solution with pivot, but would need more digging to finalise conversation of XML data for APEX to use.
http://www.oracle-developer.net/display.php?id=506

Then I found Tom's answer using easy to understand dynamic SQL (properly asserted, no less)
https://asktom. (more...)

Back to work, post Kscope15

After landing late Wednesday night I'm officially back to work on Monday morning, greeted with this:

It's good to be back. There is an APEX 5 instance sitting on 12c ready for app regression testing once it has data, but work before play - got a small backlog (more...)

KScope Day 2

I struggled a little bit this morning, for the first time in a few days the alarm woke be up with a start. I'm not sure my brain was ready. Kudos to those that tackled the 5k, I had the energy a few days ago...

Printing with node.js

Dimitri provided a great intro to help us all understand what node.js is all about and how to learn more, covering
- Installing node
- (more...)

KScope Day 1

Day 1? Really, is that all? There are so many things going on it feels like day 3.

And I'm not even participating in everything since I'm also coming back to do some family time each day.

Chi Gung

I gave this a go this morning after not being able to find Kent on the first day. It was interesting and there were some good exercises that everyone should consider doing in the morning, though (more...)

Listen to Kscope15 on Twitter

If you're at Kscope15 (even if you're not!), do you realise there is another set of conversations going on beyond the talks and beyond the between-session banter?

It's online of course, and it's on Twitter. It's live; it's interactive; and it's worth 'listening' to, if not contributing as well.

Visit this URL to read what's going on, even if you're not registered.
https://twitter.com/search?q=%23Kscope15
It might change your mind on registering for (yet (more...)

KScope15 APEX Symposiums

Kscope15 officially kicked off on Sunday with a set of symposiums, I stayed in the APEX room the whole day, though I really wanted to hear what Steven Feuerstein had to say after lunch in the other room. I also hear a great discussion was had in the ADF room on tablet first vs mobile first.

APEX Episode 5 (A new frontier)

Joel Kallman kicked off the movie themed symposiums with a great talk about (more...)

Washington memorials

I'm no patriot, and I'm certainly not American.

I'm somewhat of a pacifist, but I appreciate the efforts of the brave in years past. I certainly felt an urge to to shake the hands of some of the aging veterans we saw as we passed the WWII memorial.

What moved me most, however, was walking through the Lincoln memorial.

There was some amazing prose on those walls. Considered words, unbiased by the various media of (more...)

Bawston

Boston is a nice city, smaller than expected but full of culture.

The weather was great for us and we took one of the Duck tours which took off from right outside our hotel.
From out piggy tumblr
We don't get much in the way of American history in Australian schools, and most of what I know comes from movies or general interest. We had an amazing character driving our duck, a fella named Tim (more...)

Kscope Journey

Boy that was a long trip.

Sure, Perth to Dubai was 11 hours but on a brand new half full Airbus it wasn't so bad, even if we didn't get in early to move away from the bulk head seats. The leg room was handy while bubba was awake, but arm rests that don't fold up made it harder to get her to sleep.

I think though the most boring part was the 3 hour (more...)

Review: Ex Machina

Do yourself a favour and buy, beg, borrow (don't steal) the movie "Ex Machina".

Don't watch any trailers, don't read any articles, and don’t even read up on IMDB. Just trust that if you have any interest whatsoever in what it means for a machine to be self-aware - this is the movie to watch.

I'll just say it does a brilliant job in exploring the philosophical repercussions of the Turing test. For (more...)

APEX iFrame Security setting

At some point during APEX development you may find yourself putting an Oracle APEX page within an iFrame.
<iframe src="//myserver.com.au/ords/f?p=SAGE:1023:&SESSION."></iframe>

Just recently I did just that and came across an error I expected to see, but a little curious as to how it presented itself.

Refused to display '//myserver.com.au/ords/f?p=SAGE:1023:30559832045078' in a frame because it set 'X-Frame-Options' to 'DENY'.

Googling the last half of the message returns some interesting (more...)

Kscope15 Presentations of Interest

Kscope15 is insanely close and I'm very excited to be making the journey this year.

A few months ago I made a list of presentations that piqued my interest to try encourage a business colleague to come along. Maybe this list will encourage someone to join what I understand to be the world's best conference for APEX developers.

The APEX topics listed in full here
http://kscope15.com/component/seminar/seminarslist?Itemid=57&topicsid=2
The links below go directly to the (more...)

APEX 5 alternative to gReport.data.view(‘DETAIL’)

I'm sure we've all done it at some point or another, used some "feature" in the database you're probably not meant to.

Interactive reports still have a few misgivings prior to APEX 5 so some tried to utilise gReport object, since it was available in the generated page but undocumented - which in Oracle speak means that they're more than entitled to change behaviour in future without telling or supporting you.

I understand htmldb_Get put (more...)

AUSOUG: Perth Seminar May 28

Attention Perth Oracle technologists.

I'll be giving a dry run of my Kscope talk to the user group in Perth on May 28th, which happens to be the deadline for us to submit copies of our sessions to ODTUG.

So if you're in Perth, have any form of interest in APEX - come by the Oracle offices in near Kings Park by 8am, or come a bit earlier for a feed.

Evidence-Based APEX: Building Better Practices

Register here
http://www.ausoug.org.au/cms/rest/event/2125

Customising APEX 5 Open Door Credentials

The polish that comes with APEX 5 also extends to the generic login screen used for the Open Door Credentials authentication scheme.

This scheme is great for testing. It allows you to log into the application by supplying just a username, as if you logged in normally - saving on user management in test servers.

The login screen used isn't page 101, but a generic page generated via wwv_flow_custom_auth_std.login_page. Prior to APEX 5 the page (more...)

The Oracle APEX Talkshow

apex.press/talkshow
Not only has Juergen been adding style, pride and awareness to laptops worldwide, he's also launched a podcast.

I love podcasts. I listen to a few good science shows every week and I've been looking for some decent software related shows, and this one hits the subject matter right on the head.

Juergen states he hopes to interview many developers from the APEX team, offering perhaps a recording per month. Not limiting (more...)