presentation (and book
), I have created a presentation called PL/SQL: The Good Parts
This is not intended as an introduction to PL/SQL, but rather an overview of features you should consider if you want to maximize your enjoyment of programming in the Oracle Database. Also, this is not an exhaustive list of all features, it's simply the ones I personally use frequently.
Note that unlike (more...)
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
I saw a commercial a few months (more...)
I've been playing around with MATCH_RECOGNIZE - the data pattern matching extension to SELECT that was introduced in version 12.
Most examples I've seen have used the default AFTER MATCH SKIP PAST LAST ROW as most often the logic dictates, that when we have found a match in a group of rows, we want to search for further matches after
those rows to avoid unwanted "double" matches.
But can there be uses where we want (more...)
You’ve finished the design for an Apex application, and the manager asks you “when will you have it ready to test”. You resist the temptation to respond snarkily “how long is a piece of string” – which, by the way, is often the only appropriate answer if they ask for an estimate before the design work has started.
Since you have a design and a clear idea of what exactly this application will do, you can build a reasonable (more...)
I ran into a problem the other day when moving some code from one database to another (both XE 11g). The code in question needs to convert an XMLType to a CLOB to do some (hacky) string manipulation on it, and then turn it back to an XMLType.
Here's the original code: l_xml := apex_web_service.make_request(...);
-- little hack to remove bad empty namespace from result
l_clob := l_xml.getClobVal();
Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.
In case you dreamed of updating an Apex tabular form built on top of a view based on APEX_COLLECTIONS by means of INSTEAD OF triggers, you must be ready to grant the following rights to the schema user attached to the workspace, otherwise you'll get an ORA-01031: Insufficient privileges
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...)
I have a simple tabular form with a numeric “sort order” column. I want the value of this column to be defaulted automatically, based on the maximum value of the rest of the records on the screen. Unfortunately the builtin Apex default type for columns in a tabular form can only be based on an Item, or a PL/SQL expression or function. I didn’t want to make a database call to get the maximum value (more...)
Today my presentation is confirmed: “Bob the Builder: Build/Deploy of ADF enterprise applications”.
I will speak over our experiences with following
- build tools
- deployment tools
- versioning & branching
- continuous integration
- hot deployment in development
- compile & runtime dependencies
If you speak german and you are interested in some of this, you should come and attend DOAG 2015.
Filed under: Deploying
, ADF Architecture
When you have to create stored procedures which need to be called from an Oracle Service Bus, the most covenient way (at least for the one creating the mapping between the incoming message and the stored procedure) is to use Object Types.
The "downside" is that you might need lots of Object Types and Nested Table Types to get the right structure.
If you are unfamiliair with this technique, there are some links at the (more...)
This is part four in a series of blog posts
about how to install Oracle 11g Express Edition (XE) with Oracle Application Express (Apex) on a CentOS Linux server, with Apex served by Oracle REST Data Services (ORDS) running on top of Tomcat and Apache.
After setting up a small CentOS server with Oracle Express Edition (XE), I wanted to stress test it to see how much load such a barebones installation can handle. In (more...)
If you are using the Apex built-in Data Loading feature to allow your users to upload CSV files, you may have encountered this error. It’s not a particularly useful error, and the apex logs don’t seem to shed much light on the problem either – reporting only “ORA-01403: no data found” with backtrace
ORA-06512: at "APEX_040200.WWV_FLOW_DATA_UPLOAD", line 4115 ORA-06512: at "APEX_040200.WWV_FLOW_PROCESS_NATIVE", line 213 ORA-06512: at "APEX_040200.WWV_FLOW_PROCESS_NATIVE", line 262 ORA-06512: at "APEX_040200.WWV_FLOW_PLUGIN", (more...)
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...)
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...)
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...)