Archive for april, 2013

Determine the difference between two dates

Function created Now, i just create a view to demonstrate with: SQL> create or replace view temp_view   2  as   3  select to_date(’01-JAN-1999 12:02:04′, ‘dd-mon-yyyy hh24:mi:ss’ ) d1,   4         to_date(’15-MAR-1999 01:34:23′, ‘dd-mon-yyyy hh24:mi:ss’ ) d2   5  from

Read More

New book: Oracle Application Express for Mobile Web Applications

Very recently a new book came out: "Oracle Application Express for Mobile Web Applications". This book is aimed at developers with some knowledge of APEX and want to know more about building web applications with APEX (of course) especially aimed

Read More

Paper “Professional Software Development using APEX”

As announced on Twitter yesterday, my paper titled "Professional Software Development Using Oracle Application Express" has been put online. I'm copying the first two paragraphs of the summary here, so you can decide if you want to read the rest

Read More

Logger 2.0.0 Alpha

Logger is a PL/SQL logging and debugging framework. It's used in many organizations to instrument code in their Oracle applications. Tyler Muth created Logger a few years ago and has since released several upgrades, the last being 1.4.0. I contacted

Read More
PL/SQL Email Client package: version 1.0 is available

PL/SQL Email Client package: version 1.0 is available Nach einer sehr langen Zeit (um genau zu sein: nach 2 1/2 Jahren), konnte ich endlich eine neue Version meines Projektes PL/SQL Email Client online stellen. Neu in Version 1.0 sind

Read More

MP3 player in Apex

see http://www.eberapp.com/pls/apex/f?p=447:402:0::NO::: 

Read More

Low cost APEX reporting tool (Excel)

Plug-in uses the source queries of all report regions on a page (standard or interactive) to fetch and convert data to temporary XML with DBMS_XMLGEN package. Plug-in then applies on temporary XML one or two XSLT transformation with XSLT processor

Read More

Execute Dynamic Action From Report Column Link

In my previous post I showed how a dynamic action can be executed by using $event.trigger(<name>).  Using the same call we can execute a dynamic action from a column link in a report.  Not only can the dynamic action be

Read More

Apex Drop Down Menu Plugin

It's basically a wrapper plug-in for the Navbar and Dropdown pieces of the Twitter Bootstrap framework so most of the credit must go to the developers and contributors of that framework. The goal of this plug-in for APEX was to

Read More

APEX_LDAP.AUTHENTICATE fails authentication

APEX_LDAP.AUTHENTICATE fails authentication for user names with high ASCII characters after upgrade to APEX 4.2.1 Environment: Application Express 4.2.1.00.08, Oracle Database 10.2.0.5.0, Microsoft Active Directory

Read More