APEXblog.nl - Tips and Tricks

About This Blog:
I (Richard Weug) started this blog primary for myself to save all kinds of Apex tips and tricks in one place. To use it as a place to write down how I used some coding in my own projects, but also to copy and paste all kinds of articles I find on the Internet. (So I never have to wonder on what website did I read about??? When I see something interesting I collect the content so I have my own archive/knowlegde base.

View my profile on LinkedIn

 

Home

Print
16
Apr

PL/SQL Email Client package: version 1.0 is available

Written by Richard Weug on Tuesday, 16 April 2013 12:55. Posted in PL/SQL

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

Print
12
Apr

MP3 player in Apex

Written by Richard Weug on Friday, 12 April 2013 09:33. Posted in Tips and Tricks

Print
12
Apr

Low cost APEX reporting tool (Excel)

Written by Richard Weug on Friday, 12 April 2013 09:31. Posted in Tips and Tricks

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 implemented as DBMS_XSLPROCESSOR package. If we can’t build desired output just with XSLT final conversions can be made with ConverBlob procedure. Plug-in then starts download of transformed output. XSLT transformations must be previously uploaded in APEX application as static files.

Print
12
Apr

Execute Dynamic Action From Report Column Link

Written by Richard Weug on Friday, 12 April 2013 09:28. Posted in Tips and Tricks

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 executed but a value can also be passed to the dynamic action.

Print
09
Apr

Apex Drop Down Menu Plugin

Written by Richard Weug on Tuesday, 09 April 2013 21:54. Posted in Tips and Tricks

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 make it as easy as possible to add these components to your applications. The result is a fantastic looking, easy to use navigation bar that could be used as a replacement for tabs or elsewhere.