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...)
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...)
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...)
Another conference series over and many new lessons are still churning around somewhere in the back of my brain.
Our Australian conferences still seem a little subdued compared to years gone by, but the thicker community bonds held strong while the economy decides what to do.
The other problem we have is getting all those people out there we know are using Oracle technology out from their cubicles and at these fun events!
My Presentations (more...)
If you've played with the D3 chart plugins you can find in the Sample Charts Packaged Application, you may have noticed the ability to nominate a column from your query as the series name.
|APEX 5.1 Column Mapping|
APEX 5.1 provides this built into the framework. Combined with some rather granular attribute control at series and axis levels, I think it will be harder to find tweaks that haven't been made declarative.
Let's say you're experimenting with a report (IR or classic) column and you would only like it to appear in you development environment.
What options do you have for hiding that column in other environments?
- Don't migrate the change - use your source control processes to only move it when it's ready. This isn't always practical, nor the intent, particularly since you can programatically set the status.
- Add server condition on database name - we (more...)
This question in my 2015 survey
is related to question 7
Q8: Do you have any thoughts you'd like to share on instrumentation?
I left this open for people to add a free-text response. Here are some worth highlighting, though it was hard to choose since so many people had something to add.a) How would it help me?
Have a read of this post
to get an idea of how the debug (more...)
It's less than a month away from the Australian conference series and I'm probably about 2 thirds ready for my sessions.
Australia? Yup, the Perth gig will be on 7-8 Nov and the fun continues in Melbourne on 10-11 Nov 2016.
Check out www.ausoug.org.au/connect2016
, then think about that junket. Jokes aside, events like these are the best place to chat to people about Oracle technology, with plenty of sessions to allow (more...)
I'm going to take advantage of the fact I live in a city so remote to many others in this amazing community,
and schedule this post for my local 8am time.
It's seems my schedule didn't work. Not the first fail from blogger...
This might get me as one of the first posts
in what's hopefully an interesting day amongst Oracle bloggers.
Tim Hall, a great producer of resources for Oracle technologists, suggested bloggers new (more...)
My journey into 12c continues
with the use of identity columns
, this time regarding data that had been imported from another database, but sequences haven't been updated.
Ensuring the next number returned from a sequence matches the current value from the table appears to be a common problem, my thoughts are described here
. The biggest trouble is linking up the sequence to the column so we could automate the process.
We can now (more...)
I've been operating with a 12c environment this year and I can see some standard patterns of mine changing.
One is the use of triggers, or lack thereof. I live in a city with a certain evangelist who does not like triggers
, so I was happy to see Sven Weller's "perfect trigger
" post. The answer is: there is no trigger.
Well, it's one thing to say 'create all new tables like this', (more...)
Last week I described a method to make the tooltip on information more accessible to the end user.
Here is how you could make the same information available to touchscreen users.1)
First step, as before
, is to define the HTML Expression of the column to include the title
In this case I also stored my row identifier as an extra data- attribute
<span title="#RECENT_NOTE#" data-key="#ROW_KEY#">#MY_COLUMN#</span>2a)
Create a dynamic action on click (more...)
Quite sometime ago while still on 3.x I described a simple way to add tooltips in a report
using standard HTML in a HTML Expression.
However, it will only appear when hovering over the span content, not anywhere within the table cell.
$('td[headers=my_column] span').each( // for every data cell in the column
This question in my 2015 survey
relates to built-in instrumentation.
Q7. Do you utilise apex_workspace_activity_log (for monitoring/reporting application usage)?
Yes (90) 47%
No (102) 53%
This log table reports details of all page rendering and AJAX process calls. I really like this information, though I would like to be able to add to the output things such as
In addition to the Monitoring pages you'll find in the APEX administration section, I've built (more...)
Despite web pages having been around for quite some time, and users have been given years of affordance
, people still double click on links & buttons in web pages.
This can cause a few issues in an APEX environment as the underlying process may get executed twice, and today I came up with what I thought was a simple, declarative solution.
In my case I had a button that submitted a modal page. I (more...)
This question from my 2015 survey
may pique curiosity among some APEX developers.
Q6: How do you instrument your code?
Hopefully those in the 22% who do not add instrumentation just didn't understand the question.
Instrumentation is another term for adding debugging information to your code. There is plenty of commentary
on this topic and done right it can make tracking down problems a breeze.
It can be as simple as knowing when a procedure (more...)
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...)