APEX 5 is currently in Early Adaptor 2, so the exact implementation of this blogpost might change when APEX 5 goes GA.Font Awesome
is standard included with APEX 5 and you can use the icons on buttons, there is a special property for that.
I was playing around the other day and I wanted to include some Font Awesome icons in my report.
First create a report (classic or interactive, whatever you want) and (more...)
In my previous blog post
, I took a look at the new APEX_JSON package that ships with Apex 5.0 and its capabilities for parsing JSON.
In this blog post, I am going to look at how the APEX_JSON package can be used to generate JSON from data in your database using PL/SQL.
There are multiple ways of creating JSON output using the APEX_JSON package. There are several overloaded write() procedures which can output (more...)
Last week, at the yearly ODTUG Kscope Conference, I did my presentation "Getting Started with APEX Plugin Development". After the session Patrick Wolf
, Principal Member of Technical Staff for APEX, pointed out an improvement that could be made.
In the presentation I point out the need to escape the input that you get from a user of the plugin in order to protect the plugin from unwanted use, like SQL Injection, Cross Site Scripting (more...)
As I mentioned a year ago
, it looks like Apex 5.0 will include a new package called APEX_JSON for parsing and generating JSON. In this blog post, I will take a quick look at the parsing, and the next blog post will be about generating JSON output.
Since Apex 5.0 is still in Early Adopter (beta) mode and not yet released for download, we can run a query against the data dictionary (more...)
I have been awfully quiet on my blog lately. I think that is because I have been busy with other things, like my garden and stuff like that. There are some ‘techie’ thing I have done in the meantime, though,
I have submitted a couple of abstracts for Tech14. Hope at least one of them gets selected. I really like presenting and if it is in a different country, that is just a plus. That (more...)
If you are working with Oracle software as a developer, DBA or application server administrator, you should read the new OTech Magazine.
The Winter 2014 issue is almost a book: 136 pages of high-quality technology articles by some of the leading experts in their respective fields. My contribution is the article “From Requirements to Tool Choice” about how to choose the right Oracle development tools (ADF, APEX, or Forms).
And did I mention it (more...)
If for some reason, you could not install the APEX sample packaged application via Application Builder > Packaged Applications interface, you have an option of installing it by importing the SQL script (fxxxx.sql).
In my case, when installing via the Packaged Applications interface, I got the following error:
While working with DBA and Oracle support to resolve the root cause of this issue, I’ve found that the installation script (like export file) of the (more...)
It's finally here, for Linux & Solaris at least: Oracle 12c Database
You know how it is, when you have that feeling. You are on top of your game. You have a few quick brush strokes to add to a system to make it more dynamic. You have all the small needed changes in your head and you know it is just (more...)
Hide/Show regions are very useful in that they allow users to hide certain on-screen content when it’s not relevant for them (and show it again just as easily) simply by clicking the small arrow icon in the top left of the region.
But how can you programmatically do the (more...)
Next week, I’m off for the OUGN Spring Conference that the Norwegian Oracle User Group arranges on board a cruise ship sailing from Oslo to Kiel and back. This event gathers the Oracle A-List, including Tom Kyte, Cary Millsap, Bryn Llewellyn, Mark Rittman, Markus Eisele and many others – it’s (more...)
Here one day before deadline, I have entered almost my entire current catalog of presentations for consideration in the Oracle OpenWorld 2013 agenda. One new for this year: “Worst Oracle ADF Project Ever”
If you would like me to speak at one of your events, the following are the presentations (more...)
Like a middle aged man visiting the gym for the first time in 10 years, I am merely going to flex my blogging muscles here…
One of the recurring issues that annoys me on the OTN SQL & PL/SQL forum, and also the APEX forum is the misunderstanding of what (more...)
Here's a link to a nice write up in Forbes on something that I was involved with over the last few years:Thomson Reuters Eikon - Mapping The World's Energy On The Move
If you already use Oracle Spatial or Locator then you probably already know Simon Greeners SpatialDB Advisor
blog, but if not then I can recommend it as an invaluable source of Spatial nuggets. Whether you are just starting out with Spatial or have some level of experience with it you (more...)
and chose MXGraph from JGraph
It's been a while since my last blog post but as I'm now looking for my next Oracle contract (hopefully Apex again purrrlease) I've a little time on my hands. So I thought I would share with you my latest creation. It's a variation on the Treadputer which is basically (more...)
In every other profession having a 20 year experience is a good thing, in ours you are treated as a has-been who is kept around only to maintain the legacy system. This is insane.
The following bit of jQuery will allow you to do this. Just change the string “Personal Bio” to be whatever the string (more...)
Long time no speaky!
Well, on 21st March 2012, I spoke at the OUG Ireland conference. The title of the presentation was “to iterate is human, to recurse divine” – a touch pretentious, I know. The event started for me the night before, meeting Roel Hartman, Jan Navratil and Frits (more...)