Early last year I put the call out
to #orclapex developers, asking them to fill out some questions in survey (using a packaged APEX application, of course).
The results helped contribute to a presentation
I did Kscope15. Thank you to all those who responded. I thought I'd finally post some results, see if it can elicit further discussion, even of a casual nature.
Some of you asked me if I could post these results, so (more...)
I just came back from the DOAG APEX Connect 2016 conference in Berlin
... very nice location, great content and the wonderful APEX community to hang out with ... always a pleasure. This time we felt a little bit pink ;)
As promised, you can download the slides and the demo script (as is) from my site
Instructions are included.
See you at KScope in Chicago, #letswreckthistogether .
Cheers and enyoy!
describing the use of a simple selector identifying page spinners was originally going to be about performance, then I learned something I found very interesting.
I likened what I learned to Tom Kyte's essay
(Asktom->Resources->Presentations->FalseKnowledge.htm) on Correlation vs Causation. The essence was that things change over time, and we can't always trust authorities on the topic, and we must always test in our own environments. This aligns with skepticism
in general, and (more...)
This is the 11th installment of my blog series around Stream Processing and Analytics.
First two interesting tweets I found last week. The first one by Steve Wilkes brings it straight to the point:
The second one by Neha Narkhede reveals some impressive metrics about the usage of Kafka @ LinkedIn. 1. (more...)
One of the simplest tuning techniques to encapsulate PL/SQL used in APEX within packages, minimising the size of anonymous blocks. This applies to any PL/SQL within the page, including computations, processes, plugins, dynamic actions, validations, shortcuts and dynamic PL/SQL regions.
This change can make a big impact in the execution time of PL/SQL as it's processed at compile time instead of interpreted at runtime.
Plug-ins can be wonderful black boxes and consumers may not care (more...)
Sending emails from the Oracle database can be both simply deceptively braindead easy, and confoundingly perplexingly awful at the same time. Easy, because all you have to do is call one of the supplied mail packages to send an email:
(sender => 'email@example.com'
,recipients => 'firstname.lastname@example.org'
,subject => 'Test Subject'
,message => 'Test Message');
(p_from => 'email@example.com'
,p_to => 'firstname.lastname@example.org'
,p_subj => 'Test Subject'
,p_body => 'Test Message'
Sage Computing Services
are happy to announce a new 2 day course for Oracle APEX developers.
jQuery and Dynamic Actions in APEXThis course is designed for APEX developers who know their way around the APEX builder but want to build more interactive & user friendly applications that are also suitable for touch devices.
Upon completion attendees will have a great understanding of the communication between the browser and the database, using dynamic actions effectively (more...)
A common Apex project is to take a customer’s existing spreadsheet-based solution and convert it more-or-less as is into Apex. I’ve got one going at the moment, a budgeting solution where users need to enter their budget requests. They currently enter their requests into an XLS template file which generates subtotals and totals for them.
To do this in Apex I’m going to use a tabular form, and to do the subtotals I’ll use jQuery (more...)
Consider a chart with a trend that might be quite jagged across data points (blue line).
What if you would like a smoother version of that line - a moving average
, if you will (red line). This stabilises the results, like looking at climate vs weather
|Oracle APEX Line Chart - 2 series|
It's fairly easy from a SQL point of view - in this case it's another column in the original chart query
Recently I saw a simple, accepted answer in the forums that tempted me to provide a small extension to the provided answer. This has since spawned two blog post ideas, here is the first.
The following question asked how to hide the spinner from a particular page full of small reports refreshed on a timer.https://community.oracle.com/thread/3908020
The answer was some basic CSS, which could be placed in a variety of locations depending (more...)
Getting older, it’s getting harder to see and click those tiny checkboxes…
/* Double-sized Checkboxes */
-ms-transform: scale(2); /* IE */
-moz-transform: scale(2); /* FF */
-webkit-transform: scale(2); /* Safari and Chrome */
-o-transform: scale(2); /* Opera */
CAN YOU SEE THEM NOW? Ah, good. That’s all right then.
Brought to you by dept-of-coding-by-copy-and-paste.
Filed under: APEX
When installing a new WebLogic Domain for any a-specific Oracle (Fusion) Middleware application or any other implementation requiring a WebLogic domain like ORDS for instance, a new ‘home’ is created under [MW-home]/user_domains/. [MW-Home] translates, for instance, to /u01/oracle/product/Middleware.
To start your brand-new domain, or perhaps and rather, to automate the startup of your domain, you would use the supplied [MW-home]/user_domains/[DomainName]/startWebLogic.sh command-file.
This file will start the Weblogic domain (the Admin Server) and the deployed (more...)
7 and 8 March iAdvise was present as Diamond Sponsor at Apex World. For the first time it was a two day event. Because of the success last year, the location of Apex World was again the beautiful SS Rotterdam. Over the past few years, the event became more and more international. This was clearly seen in the language of the presentations. Nearly all the presentations were held in English.
A special thanks to Chris Amelink (more...)
A customer of mine switched to a Singe Sign On Authentication Scheme for their APEX application - using Oracle Access Manager, but that's irrelevant to this case.
The renewed Calendar Region in APEX is awesome. With just one SQL statement you can provide your users with a calendar view of their data that looks very familiar to what they already know, use and love. Apart from one thing: Navigating to a specific date is cumbersome.
The shortest route is:
- Navigate to the right month (can be any number of clicks)
- Switch to "Week view"
- Navigate to the right week (between 0 and (more...)
I’ve just published two Apex Region Plugins on apex.world that allow you to incorporate a simple Google Map region into your application. They’re easy to use, and you don’t need to apply for a Google API key or anything like that.
1. Simple Map
This allows you to add a small map to a page to allow the user to select any arbitrary point. If you synchronize it with an item on your page, (more...)
Ever since I started exploring the idea of using a TAPI approach with Apex, something I was never quite satisfied with was Tabular Forms.
They can be a bit finicky to work with, and if you’re not careful you can break them to the point where it’s easier to recreate them from scratch rather than try to fix them (although if you understand the underlying mechanics you can fix them [there was an article about (more...)
Above you see an example of an Interactive Report everyone should know: this is the Application Builder listing all pages of an application.
The task at hand is to call (more...)
iAdvise presented the APEX 5.0 roadshows in the first half of 2015. Besides the presentation about the new features, we provided 3 tutorials which helped the visitors to explore Oracle Application Express 5.0. Now we offer these tutorials through our blog. In this article the second tutorial is presented.
This tutorial helps you step by step through the process of migrating an application to the Universal Theme
of Oracle Application Express 5.0
. In this tutorial we talk about (more...)
Time for my look back on 2015 and what I might aim for in the coming orbit around
the sun. The highlighted word is dedicated to the #flatearth people I've been conversing with on Twitter recently. Wow.
Like many people, part of the reason for doing these sorts of things really what every person should do semi-regularly -> write down your aspirations. I remember being taught goal setting from a young age and I think (more...)