Many moons ago Anton Nielson
posted about the different kinds of session state in Oracle APEX.Different
I remember session state was hard enough when learning, particularly coming from Oracle Forms. But how is there more than one, you may ask?
98% of the time we just need to worry about the persisted
session state that we all know and love. The one we see when clicking "Session" in the developer toolbar. Essentially
Suppose that every time we add records into the T1 table we have to do some additional stuff.
One option to implement this is by using an AFTER INSERT trigger that will perform this additional stuff, but I really dislike this option (mainly because the code becomes hidden in a way, and there may be a negative impact on performance).
I prefer writing a procedure that inserts the records into T1 and performs this additional (more...)
I presented this topic on at Tech 16 on Monday afternoon. The latest version is on the Tech 16 website and on http://www.slideshare.net/StewAshton1/ranges-ranges-everywhere-oracle-sql Thanks to the organisers, staff, presenters and delegates who made this a great conference and a wonderful experience!
I presented this topic on Super Sunday. The latest version is now on the Tech16 site and on http://www.slideshare.net/StewAshton1/advanced-row-pattern-matching
A common question when it comes to migrating APEX applications is "can I just export a page".
There are more technical posts on the topic of exporting APEX applications than this one out there, eg:Håvard KristiansenChristoph RuepprichAlan WarrenJohn Scott
I just wanted to clarify the concept, perhaps for those learning the tool.
So the answer? Sure you can, but what about other components related to that page? A breadcrumb; menu list (more...)
After installing APEX 5.0.4 and ORDS 3.0.8 I had an issue where APEX plugins that have static files bundled with the plugin (files that at runtime get mapped to URLs such as /ords/your_workspace_name/r/your_app_id/files/plugin/123456789/v1/filename
) were giving a 404 "not found" error from ORDS. Well, you actually have to open the console in the web browser to see the 404 errors, and then if you try to open the file directly you (more...)
UKOUG 2016 is underway. This year I'm staying at the Jury's Inn hotel, one of a clutch of hotels within a stone's throw of the ICC. Proximity is the greatest luxury. My room is on the thirteenth floor, so I have a great view across Birmingham; a view, which in the words of Telly Savalas
"almost takes your breath away".
Although the conference proper - with keynotes, exhibition hall and so on - opens today, (more...)
If you, like me, are a data warehousing or BI professional, you have probably been wondering how this all fits in the cloud world. You may have even heard of data warehousing "in the cloud". But what does that really mean? What is a cloud data warehouse?
Another quick twitter inspired blog post inspired by the SQLcl account itself.
Asked and answered: Do you support the ACCEPT command? YES. pic.twitter.com/NchmQ6Eegs
— SQLcl (@oraclesqlcl) November 29, 2016
ACCEPT is a great way to get input but validation has to happen elsewhere as there's no hooks to do something like validate a number in a range without running a sql or plsql that does
I'm a big fan of generating data with dual, using a perk of the connect by syntax.
I think Tom Kyte was the originator of this technique. It's not necessarily the fastest method, but it's super convenient - no table required.
Today I wanted to know how many weekdays a year, so I defined 365 rows on the fly using sysdate to turn these into each day of the year. Then I ran a simple (more...)
For automation of all of my processes I need Jenkins in my development server.
First I had installed Jenkins as Docker container via Vagrant Docker provider. But with this architecture it was very complicated to create docker images and run Docker containers on the Docker host, in this case my Vagrant Virtualbox.
So for simplification I have decided to install Jenkins with the provisioning of the Vagrant Virtualbox via a shell provider in my Vagrantfile:
Quite often I'll find I'd like to display a date with the time in a column within an APEX report, but you end up wondering how to control the wrap.
This is one problem that probably has a half dozen solutions, but I think this is the cleanest. And blogging about it helps me remember
Depending on your screen size, you might be faced with something that takes up too much space per (more...)
The weather has turned cold, the lights are twinkling in windows and Starbucks is selling pumpkin lattes. Yes, it's starting to look a lot like Christmas. But first there's the wonder-filled advent calendar that is the UKOUG Annual Conference in Birmingham, UK. So many doors to choose from!
The Conference is the premier event for Oracle users in the UK (and beyond). This year has another cracker of an agenda: check it out.
The session (more...)
If you try the newest version 126.96.36.199 (or maybe earlier versions too) you see, that your managed server does not restart, when
- you have deployed your ADF application(s)
- you try to restart the managed server with ADF
- you use intentionally or not shared libraries in your weblogic-application.xml (see example below)
<?xml version = '1.0' encoding = 'UTF-8'?>
xsi:schemaLocation="http://www.bea.com/ns/weblogic/weblogic-application http://www.bea.com/ns/weblogic/weblogic-application/1.0/weblogic-application. (more...)
As this post appears, I'm presenting on this subject for the Dutch Oracle User Group OGh. This blog post won't contain as much detail as the presentation itself, although it's pretty close. If you're interested to see and replay everything for yourself, you can find the material of the presentation in the "Presentations and papers" section and here directly. There are installation instructions in