Posts Tagged ‘code’

Vertical text in javascript

I’ve just recently been given a Word document with a mock up of a report that I needed to reproduce in HTML. Well, i looked at various options like using transforms, rotate, DX filters in IE, but none of them worked properly, or without major headaches. Whilst searching around, I found a JS library called […]

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 »

Oracle Apex, jQuery and GIS integration

I recently needed to provide mapping functionality in an APEX app I was developing. In V3+ of Oracle apex, you can create interactive reports like this Now when you click the cog, you geta map icon at the top: I added a <li> element to the interactive report on-the-fly using jQuery (depending if it finds […]

Share
More »

Querying XML in Oracle

Many people seem to have trouble reading XML data within Oracle.

Oracle has a full library of routines built in to allow you to interrogate XML data. Unfortunately, they’re not very well documented.

Just say you have an XML file you want to be able to SELECT from. it looks like this:

Share
More »

Switch to our mobile site