Archive for the ‘Oracle’ Category

oracle apex checkbox select all

Recently I needed to add a check box column to an interactive report on Oracle 4.2. I used the APEX_ITEM functionin my report’s SQL to generate the checkbox, but I needed a Check All option on the column header. Simple, just rename the column header: [input type=”checkbox” onclick=”$f_CheckFirstColumn(this)” /> This was implemented after repeated requests […]

Share
More »

Oracle XMLDB custom authentication for webdav / http

Oh what joy Oracle has brought me today!! I’ve been struggling for a few days trying to work out how best to integrate Oracle and Active Directory to allow users to map a drive letter to Oracle XMLDB to use it as a file store, extract EXIF, lat / lon and so on… I’d finally […]

Share
More »

Oracle on Amazon RDS with APEX listener

I’m in the process of setting up Oracle 11g with APEX and XMLDB on Amazon Web Services. I thought i’d document the process and what i do to get it all (hopefully) working together. Also, this will act as reference document for me when I do it again later this week. So here we go… […]

Share
More »

How to set Oracle Apex Checkbox default value

By Craig Glendenning As often is the case when I blog about something, I spent waaaaay too much time trying to figure out how to do something that is seemingly very simple. In this case my trivial requirement was to create a single checkbox, that when checked, puts “Yes” in the database, and when unchecked, […]

Share
More »

Oracle APEX radio groups as buttonsets

Buttonsets are sometimes appropriate to represent a choice of selections instead of radio buttons. I think they look much better – especially when used for smaller lists. Sub lists can be shown or hidden easily using dynamic actions in APEX 4.

Share
More »

New RICT V3.0 software

I’ve been moving some software I wrote a few ago, from Amazons cloud environment(EC2) to an offsite web farm here in Scotland over the last couple of months and thought I’d take the opportunity to freshen up the interface a bit. As I was now using Apex 4, I was keen to take advantage of […]

Share
More »

Getting the server name in Oracle 11g

In an APEX application i’m creating, I’m storing some output files that the public needs to get access to on the XMLDB server. The problem is, when i’m moving my code to production, I need to update the location to send the users to. Previously, I’d used global variables in a Global package to store […]

Share
More »

Oracle Apex sticky hide and show regions

Recently had a need for sticky hide/show regions in Oracle Apex 4.1. Here’s how I done it. Add the jQuery cookie library to your page template Added the following line to the hide and show region template ?View Code HTML1 $.cookie(‘#REGION_STATIC_ID#’,$(‘##REGION_STATIC_ID# .hide:first:visible’).length);return false; So my hide and show region template looks like this: ?View Code […]

Share
More »

Upgrading Oracle Apex 3.2 to Apex 4.0 on Amazon EC2 Cloud

Just today, I upgraded one of my Amazon cloud servers to Application Express 4.0. Few wee problems along the way, but got there in the end. Here is how I did it. Download APEX 4.0 from here Copy the .zip to an S3 bucket Make the bucket public Use PUTTY to log on to the […]

Share
More »

Oracle Pipline functions

Pipelined functions are an extremely useful feature of Oracle 9i and above. They allow you to present disperate nontable based data as a standard table whilst streaming the output so that processing can begin immediately. I.e., they let you SELECT from a function much like you would SELECT from a table. Cool huh? Why would […]

Share
More »

Switch to our mobile site