Just before the new year I became a 'guru' - at least as per the measuring stick over at the OTN APEX forum
I tried to find my tweet when I reached the 'Expert' status, just to see how long it's been - but I couldn't find it - maybe too small a speck in the big data that is twitter.
However, milage varies when it comes to forum usage and I must (more...)
Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.
This is the sort of things I hate, because I cannot fully explain why it works the way it does, anyway, here is a short account of what happened:
Some time ago I installed Oracle XE 11g on an Oracle Linux VM.
Upgraded Apex to 4.2.3
Installed all my applications with little effort if we
An enhancement request I was assigned was worded thus:
“User will optionally enter the Phone number (IF the phone was blank the system will default the store’s area code).”
I interpret this to mean that the Customer Phone number (land line) field should remain optional, but if entered, it should check if the local area code had been entered, and if not, default it according to the local store’s area code. We can assume (more...)
Just like every other tom, dick & harry on the internet, I thought I'd look back at the year that was.
Keep an eye out for interesting tangential
|A vague attempt at humour|
Readership continues to grow. Rapidly. From my first full year (2010) with 5k visits, I'm now at 50k visits & 69k page views for 2013, averaging 70 posts per year - cool stuff!
I've been impressed with the growth (more...)
As this the traditional time to layout resolutions for the year here are my 2 database related ones.
To understand more about some of the newer technologies and to advance my use of APEX as a means of providing reporting information around the systems and people I manage.
Having worked with the base Oracle RDBMS, and latterly SQL Server, for around 20 years I must admit that I am not as familiar with such terms (more...)
Late last year Packt Publishing offered 3 e-books
to help promote Giorgio's revised edition of PhoneGap 3
. People who commented or tweeted the blog post received entries to win.
While I prepared some SQL
to randomise selection of winners, I didn't get a chance to arrange the job to be (more...)
AJAX is becoming important in the world of web applications. APEX has provided us a very easy way to create an AJAX process, by using dynamic actions. Using PL/SQL Actions in Dynamic Actions to communicate with the database without submitting the page will suffice in most cases, but the downside (more...)
In the first two parts of this blogpost series we covered the basics and the technique on how to provide nice/friendly/readable URLs for a public APEX Application.
If you haven’t read the other two parts, please go back and read part 1, then read part 2. Done? Ok, lets (more...)
|PhoneGap 3 Beginner's Guide|
Packt publishing have generously given me the opportunity to give away 3 copies
of their e-book PhoneGap 3 Beginner's Guide
, by Giorgio Natili
.Details on how to enter are further below.
You don't think you need to be an APEX developer to appreciate this book, (more...)
In the first part of this Blogpost Series we touched some fundamentals and finally listed some options. If you haven’t read it, yet, please do now before continuing here.
The last post ended with me saying I found a way for hrURLs that works with APEX Listener, mod_plsql and EPG.
What did I mean? Actually, I thought how to rename "ADMIN" user?or How to rename "Email Address" on Multitenant Self-Service Provisioning? Why I interested in it?
I created New Database by using "ADMIN" user.
I didn't get email about credentials (Because no email address for ADMIN user
Last post, I posted about Oracle Multitenant Self-Service Provisioning - BETA 2
and read more about what changes have been made in this Beta 2 release.
Users with the PDBA role in the Oracle Multitenant Self-Service Provisioning application can only view PDBs that they created or have been made an (more...)
Got news on tweeter about Multitenant Self-Service Provisioning - BETA 2
. It's very interesting. You will find something change. For example On Oracle Multitenant Self Service Provisioning - BETA 1 runs in APEX pdb
(Downloaded pdbss_1030.zip and installed)This version, the Oracle Multitenant Self-Service Provisioning application now runs in (more...)
Somewhat unexpectedly, at least for me, Joel Kallman announced a new iteration of Apex.
Searching the APEX Forum for nice URLs is as old as Oracle APEX itself, so far without much luck. There is magic switch that forces APEX to create readable URLs.
As part of preparing my Presentation “Going Public” for Kscope 2014 in Seattle, I investigated the available methods on (more...)
Often I want to configure an APEX page based on how many rows have been returned in a (typically classic) report region. There are a number of methods for determining this row count, and some have advantages over others.
1) Computation while rendering the page.
APEX is promoted as the perfect replacement for MS Access applications. One thing you should consider though is how you migrate your data to the Oracle database. In APEX there is a handy tool called the Data Workshop that can be used for this. You first export your Excel files (more...)
I first blogged about build options
three years ago while still using APEX 3.x - I can tell by the green ;-)
I still use them regularly
, but not often for versioning as they're allocated at a component level and not for attribute modifications - perhaps in later (more...)
I recently was working on an application in Apex 4.2.1.00.08, where the application had several pages with Interactive Reports.
On all these pages, the IR worked fine – except for one crucial page, where the IR’s action menu didn’t work (Select Columns, for example, showed a (more...)
I find build options
as nifty tools to not only categorise components for the very purpose build options are documented for, but to help inform developers & testers of applications.
Here I've added a region on the global page to inform users of the status of the page - based (more...)