Where no man has gone before
I am a PL/SQL nerd. I love the language and what you can do with it. I consider myself a PL/SQL programmer first and only secondarily an APEX developer. For quite some time now I am highly in favour of using Object-Oriented techniques within packages but have difficulties convincing others to share that position. In … Read more
A good tradition needs follow up. As you all know both Richard and Sergei are very active in the Oracle APEX community. We partner with the Oracle APEX development team, visit and speak at conferences, write blogs and what not. Over the past few years we organised the Kscope preview a number of times and … Read more
My contribution to this years contribution to #JoelKallmanDay Recently I created a data-load within APEX to load about 3500 lines of excel-sheet into a temporary table. I created the table for receiving the data using the Data Workshop, as shown in the image. I now had a neat little table in which I could start … Read more
I used Dimitri’s great blog on how to get started on the Oracle Always Free cloud and APEX. Great work Dimitri.. Thanks for this. We’re used to add a login-message to our instances, so we can easily see on what instance we’re logging in. Alas.. The Oracle Always Free instances don’t offer that opportunity. That … Read more
I still use PL/SQL developer to work in our Oracle Databases. It is a tool I’ve been using for years and old habits seldom die.. In fact Pl/SQL developer is the only sound reason I have parallels desktop installed on my Mac. 🙂 PL/SQL developer connects to the database using an Oracle Client. This can … Read more
A good tradition needs follow up, last year we were not able to fullfill our promise, this year we’ll do better.
It was March 2018 when Jasper Alblas and Frans Jacobs introduced me to a real nice way of explaining the advantages of Kanban within a Scrum environment. In the Agile world, Kanban and Scrum have been seen as separate frameworks / practices, but as we all know Scrum teams actually practive Kanban as well. With … Read more
owa_cookie.send does not write the cookie to the browser because the “Reload on Submit” setting is not set at page level.
The goal in defining LOV queries is to have them stored in a compiled way, having the benefit of database dependencies and making use of the SQL optimizer.
Recently I’ve been installing the OATOA (Oracle APEX on Tomcat with ORDS behind Apache) stack a number of times on both Oracle Linux 7 and CentOS7. In the past this was no problem, Tomcat came up and a request to http://myserver:8080/ords/ gave me the expected APEX login screen. However since Oracle Linux 7 and CentOS7, … Read more