ToolsSo many tools. And I arguably don't use enough of them.
APEX 5.1It's out and I'm excited. Unfortunately, scheduling is super tight, so I'll be waiting at my current site until hopefully around (more...)
This blog will help you understand usage of Oracle Developer Cloud service for automated testing of NodeJS REST based web service application using a popular testing framework called Jasmine. The NodeJS application will be deployed on Oracle Application Container Cloud Service.
Note: For details on how to develop and deploy NodeJS REST application on Application Container Cloud using Developer Cloud service, please refer the blog link mentioned below.
Recently a question was posed regarding we all got into programming in the first place.
There are a few interesting posts, here is my submission.
The Vic-20 was the first introduction, using BASIC pokes recorded on tape, but I think it was seeing the use of a variable in a simple Pascal programme over the shoulder (more...)
Time for the performance questions in my 2015 survey. A favourite topic of mine, and my boss, Penny Cookson, lives for tuning.
Q9. How do you proactively address performance? (tick all that apply)
Tune SQL - I would be surprised if this (more...)
I have an Interactive Report that includes some editable columns, and the users wanted to include some “quick picks” on these columns to make it easy to copy data from a previous period. The user can choose to type in a new value, or click the “quick pick” to quickly data-enter the suggested value.
Normally, a simple page item can have a quick pick by setting the Show Quick Picks attribute on the item. This (more...)
The problem being this error:
ORA-01489: result of string concatenation is too long
It relates to when the result set is over 4000 characters, eg:
with data as (select rpad('x',400, 'x') str from dual connect by level <=10)Ten rows of 400 characters equals 4000, add the concatenation operator and you get (more...)
select listagg(str,', ') within group (order by null)
I thought I'd add a simple demonstration, for reference.
Consider the following query, with variations of escaped column output.
with data as
||'<br>APEX<script></script>' as string
-- UI default
-- where no tags expected
-- good for most things
-- replace line feeds with HTML line break. (more...)
You see, the "change in price" wasn't (more...)
Here is a video I recorded to walk through how the plugin was made:
Note: For an alternative implementation, see the "Block Calendar" in Oracle JET. As far as I can tell, there (more...)
Wrote and tested the code, checked in to source control. Job done.
A few days later we deployed a new release that included dozens of bug fixes into UAT for testing. (more...)
In my experience, these are best defined at a privilege level, where the same privilege could be allocated to multiple business roles, but that's for another post.
In this post, I want to mention a cool API function called
apex_authorization.reset_cache, which helps control the behaviour of these authorization schemes.
PrefaceWhile googling something else (more...)
Looks DO matter! Today’s users are fed up with the current look and feel of their Oracle Forms / EBS System, many of which were developed last century. But we know how hard it can be to take the first step towards modernization. As Forms administrators / DBA’s your management many not want to believe there is any life left in these applications and won’t move forward. He probably thinks its wiser to move on. But (more...)