Recently a fine young gentleman, who shall remain nameless (let's call him Jerry), asked for some assistance he was getting with an error in Oracle APEX.
He had done all the right things in regard to debugging the problem, but didn't know enough about APEX to know which settings to investigate.
I think developers new to APEX need the occasional post like this to give them an idea on how to start looking into a (more...)
I was constructing a fresh app for a presentation idea and I came to think about the prefix people use for Application Items in Oracle APEX.
I've seen a few variations used, and upon asking the question on Twitter (as a poll limited to 4 options), some came back with a few other suggestions.
The final tally based on the replies (we'll (more...)
from the Developer Advocates group asked the following question on Twitter.
My immediate thought regarded features I'd be disappointed to live without. Looking at some other responses I realise that the answer matches Tom Kyte's creed: "it depends".
Here is a collection of responses that I think sums(sql) really well, (more...)
Another preference question in my 2015 survey
fellow should be pretty happy with the top result, but almost half of the "Other" responses said PL/SQL Developer. I used this many years ago while SQL Developer was still being born. Since SQL Developer was free and portable, it was an easy selection, though I only use if for queries, not PL/SQL development. (more...)
Saddened but not surprised to see COALESCE lagging behind NVL.
Why? Because I think coalesce
is a good idea and the modern equivalent of NVL.
I follow @SQLDaily
for useful tips. Oracle SQL evangelist Chris Saxon
runs the feed.
Full and utter credit goes to the gang at CommitStrip, you should check it out.http://www.commitstrip.com/en/2016/06/20/coder-bingo/
I thought a few choice replacements would help Joel Kallman and team rip into what I'm sure will be another stellar set of Sunday Symposium in Chicago.
|Credit to CommitStrip, text modified from original|
We'll be listening around the world, keep your tweet
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...)
The 'grand algorithm' favoured this particular tweet from Connor McDonald in my 'highlights'.
I found this intriguing considering a side project I've been tinkering on. The solution ended up looking much simpler than a model clause, though I'm going to need to let it digest for a while before I fully understand how
it works. Maybe read (more...)
If you've ever used a PL/SQL dynamic action with the default 'wait for result', you would have seen the following warning if you have the browser console open.
|Text for bots: Synchronous XMLHttpRequest on the main thread is deprecated because of its detrimental effects to the end user's experience.|
Consider this scenario of dynamic actions on change of P42_ITEM:
|Synchronous vs Asynchronous server calls|
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...)
Ever had this problem where your button is offset to page items?
|Item / Button misalignment|
While the Universal Theme is awesome, it hasn't quite got everything right. I look forward to trying the updated version
of the theme in our existing applications.
APEX forum legend fac586 (a.k.a. Paul MacMillan) provided a simple solution here
to the Column CSS Classes
property for the button.
Little tips like this can be acquired (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...)
I was lucky enough to attend a 'Let's Talk Oracle' session from Canberran Richard Foote
today diving into AWR.
After an early dad joke and before we got into his AWR collection, we gave this brain teaser.
This hurt many heads, including mine, and I also picked the wrong answer. Richard reports our group did well (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...)
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...)