As many conferences evolve over the years, the number of sessions on offer can easily be overwhelming. I have overheard many conference attendees wrestling with their choices for what to see and which sessions to attend.
For DOAG 2016 I have a short overview with my picks and with one or two tip-sessions. I hope this helps, though it is just my personal preference of course…
Please note that this post is based on the (more...)
In 1.5 week I'll be travelling to and through the Nordics as one of the speakers during the OTN Nordic ACE Tour
. It will be quite a busy schedule!
and one about APEX (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
APEX 5 has built-in support for dialog boxes. These come in two varieties; dialog pages (which show another standard APEX page in a dialog box using an iframe) and inline dialogs (which show a region on the current page as a dialog box). John Snyders goes into great technical detail
about APEX dialogs and the differences between the two types.
This post is a quick summary of how to use inline dialogs. As John points (more...)
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...)
Do you want to display an image on a report in APEX ?
Is the image stored as a BLOB data type in your schema or the blob is returned by some functions?
If so, then displaying the BLOB is not a simple or straight forward task.
Actually it is a simple and straight forward task, as long as you know "the trick" you need to create/defined in your APEX report.
The following steps outlines what (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...)
This blog post will bring you through the steps of how to get Oracle R Enterprise (ORE) to work with APEX.
The reason for this blog posts is that since ORE 1.4+ the security model has changed for how you access and run in-database user defined R scripts using the ORE SQL API functions.
I have a series of blog posts going out on using Oracle Text, Oracle R Enterprise and Oracle Data Mining. (more...)
This is the third blog post of a series on using Oracle Text, Oracle R Enterprise and Oracle Data Mining. Check out the first and second blog posts of the series, as the data used in this blog post was extracted, processed and stored in a databases table.
This blog post is divided into 3 parts. The first part will build on what was covered in in the previous blog post and will expand (more...)
In APEX you can define a web service that returns XML as below - all declarative, just a few steps through a wizard.
Then generate a report on top of that web service - again just a few clicks through a wizard. The generated query looks like this:
from apex_collections c,
XMLTable('/Response/S_getCustomerListTableArray/S_getCustomerListArrayItem' passing xmltype001
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...)
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...)
At my current project we use Interactive Reports heavily. But in some cases the underlying queries are rather complex and a query without any filter or with just a filter on all columns doesn't perform that well (understatement...). We already implemented a solution to prevent initial loading of the data by adding an additional criterium to the query ( :P400_SEARCH = 'Y'
). The default value of this hidden item is 'N' and on (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...)
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 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!