Oracle VM Site Review - Oracle VM Health Check
view counter

Feed items

The Oracle APEX Talkshow

apeks sticker, check.

There are some stickers are out there causing quite the sensation in the Oracle APEX Twitter community. Check it out and join the conversation.

A couple of weeks ago I received my sticker from the master dealer, Juergen, so I thought I'd share my pimped up laptop, complete with sticker friend.

Things learnt during APEX5 Universal Theme seminar by Shakeeb

Tonight I stayed up way past my bedtime (well, in the days of writing a book and Kscope presentations, midnight isn't that late).

I watched and listened to Shakeeb Rahman from the APEX team on an ODTUG webinar, which was recorded and available for ODTUG members.

I did, however, take some notes. I thought I'd share:

*****

Introduction

No need for css/javascript, or design

Not shy about reference to Douglas Adams.

Season's readings

Have you discovered the OTech Magazine yet?

apex.oracle.com upgrades to 5.0 this Friday

There was movement at the station, for the word had passed around
That the APEX version 5 will become available.

I've jumped the gun before, but this message is taken direct from the apex.oracle.com site:

All commenters now welcome

I've finally bitten the bullet and disabled the Google+ commenting mechanism from this blog. I promised this in my 2014 annual review, and I figure I might as well not wait.
When Google announced they would integrate Google+ with blogger, it sounded like a good idea at the time. However it required that commenters needed a Google+ account as opposed to having a number of authentication options.

Perth Breakfast Meeting - APEX5 + JSON + Food

Do you live in Perth, Western Australia?
Do you use Oracle Application Express?
Are you interested in seeing how easy it is to extend the product?
Keen to see APEX 5 in action?

Please tell me you're free for breakfast on Tuesday March 24. You'll be out by 9am feeling glad you came. Visit the event details page for the abstract, it's inspired by a book I'm currently writing ;p

Adjusting Interactive Reports - learning from mistakes

Sometimes I come across code where it's obvious someone has taught themselves APEX, then worked through a problem to come up with a solution - but they went a long way.

Today's situation required data in an interactive report to not wrap the output. I thought it'd be worth sharing because a few lessons might be demonstrated along the way for newer developers.

Here is the long way:

1) Add this to the Page Load property
$('td').attr("style","white-space:nowrap");

LISTAGG to a CLOB, avoid 4000 chr limit

Thanks to twitter I found this post by Carsten Czarski on LISTAGG and CLOBS that helped my with the 4000 character limit with LISTAGG(), found when building JSON strings.
ORA-01489: result of string concatenation is too long

view counter