DISCLAIMER: this article is based on Early Adopter 1.
I’ve finally got back to looking at my reference TAPI Apex application. I’ve greatly simplified it (e.g. removed the dependency on Logger, much as I wanted to keep it) and included one dependency (CSV_UTIL_PKG) to make it much simpler to install and try. The notice about compilation errors still applies: it is provided for information/entertainment purposes only and is not intended to (more...)
If you have one record where you want to display multiple columns of information, the 'Value Attribute Pairs - column' report template is pretty nifty.
Some of the packaged applications use this within the breadcrumb bar, above a region display selector, and it looks really tidy.
|Nulls shown with tilde|
Note, I've modified region attribute setting 'Show null values as' to a tilde (~).
But what if I wanted to hide those null values for (more...)
Creating a Navigation Bar using static values is very straightforward. Just create a list similar to this example below - and you can easily define multiple levels.
Then, in the User Interface Attributes, set that list to be your application's "Navigation Bar List" and specify the template.
And the Navigation Bar pops up nicely in the upper right corner of the screen.
So far so good.
But what if you don't want a Static List, (more...)
Next question in my 2015 survey
, how many different ways can we all type "chrome"?
Q4: Which browser do you use for development?
The first free text question, with a long variety of unique results. I haven't analysed the complete list to get a truer result, but the pattern is clear. 3 of the top 5 are Chrome. APEX developers build in Chrome, the application builder is recommended for Chrome, especially during early adopter (more...)
The next question in my 2015 survey
was a high level look at what resources developers use to get through your day.
On a slightly side note, there was an interesting discussion on the science of preferred vs effective learning styles in this podcast
. It reminded me of my scuba diving course where we learnt the content using 5 different methods, which was a great way to ensure everyone understood how to survive in a (more...)
Last month I wrote a post about CSS performance
, including some performance test results.
I recently encountered this brilliant post on Medium
that describes some best practices for CSS.
While APEX does a lot of this for you, I think it's worth a read by all developers. Even applying basic naming conventions can make code easier to read and understand.
There was also a section on performance that described an issue that my previous (more...)
I have been considering writing this article for quite some time now.
APEX Connect 2016 in Germany’s capital Berlin and the DOAG Database days have finally persuaded me to talk more about #DBADev, let me explain why…
Whenever in the stone age…
During my career as DBA, I was always working closely together with Oracle Forms & Reports developers. In retrospect, the cooperation in that time was remarkable.
These Forms & Reports developers had always (more...)
I came across a tweet from a non-Oracle person I follow that should amuse many web developers:
One of the replies referred to "little bobby tables", eluding to a classic xkcd comic
about SQL injection.
Of course I had to make the correction that this was in fact Cross Site Scripting (XSS), not SQL injection. This post summarises
syntactical considerations (more...)
Following up from the results on when you started learning APEX, here is question 2 from my 2015 survey.
Note that questions such as this offered the respondent to choose multiple selections, hence a count much higher than 192.
Q2: Which versions have you experienced?
I think it's fair to say that most of the 2.x respondents might also be part of the third that said they started prior to 2007.
I started in (more...)
Today while perusing posts in the #orclapex
hashtag, I came across this from Christina Moore.
She hasn't been blogging long but I love her style and format. I found this one on classic report templates
a great resource, though I wish the Oracle team would produce content like this to accompany the documentation, or as an extension to (more...)
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...)
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...)
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...)
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...)
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.