The pg_trgm module provides GiST and GIN index operator classes that allow you to create an index over a text column for the purpose of very fast similarity searches. These index types support (more...)
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();
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, Development Tagged: 11g, 12c, ADF, ADF Architecture, Branching, (more...)
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...)
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...)
ADF Spotlight sessions demonstrate features of Oracle ADF. Recently I delivered a session providing a DevOps solution in the cloud for Oracle ADF developers. This was broadcast live on June 30, 2015. You can view the full recording on YouTube here.
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:
Thank you to all those who attended, and cheers for all the great feedback, I sincerely appreciate it. I wish I (more...)
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...)
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.
Then I found Tom's answer using easy to understand dynamic SQL (properly asserted, no less)
My return to work present, but I was told they missed my enthusiasm, which was nice #geekflattery pic.twitter.com/OK60sl66Bh— Scott Wesley (@swesley_perth) July 13, 2015
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...)
By now, you should have a working installation of CentoOS with Oracle XE, Apex, ORDS, TomCat and Apache. There are still some additional configuration and optimization we should do, which (more...)
I had many items dotted around an Apex application where the user is allowed to enter “Codes” – values that must be uppercase (more...)
If you want to quickly get some kids introduced to computer programming concepts, you could do a lot worse than using Code Studiofrom code.org. That's what I did the last couple weeks - took two hours to lightly shepherd the Dayton YWCA day camp through a programming intro.
It's really well-organized and easy to understand - frankly, it pretty much drives itself. It's based on block-dragging for turtle graphics and/or simple 2D games, (more...)