view counter


Oracle Application Express (APEX) resources, news, and support articles.

APEX: Application Builder Defaults

Home --> Workspace --> Application Builder --> Application Builder Defaults

I'm not sure which version this was released, but it makes life just a little bit easier...which is ultimately the goal of any technology. From your Application Builder home page in the Tasks section, you should see Application Builder Defaults

APEX: Assign Multiple Schemas To A Single Workspace

Home --> Administrative Services --> Manage Workspaces --> Assign Multiple Schemas To A Single Workspace

Here's My Recommended Technology Stack

APEX: Substitution Strings

Home --> Workspace --> Application Builder --> Substitution Strings

I was asked a question the other day about substitution strings. Like many things, I did not know all of them off the top of my head. But I do know where to find them.

A trick I used to use was to create a page with an HTML Region and put all the substitution strings in there...just so I could remember them.

Some Christmas goodies for APEX

The German Oracle APEX team created a really nice Christmas countdown calendar. Unfortunately it's in German but just use Google translate and you will understand probably most of it. :)

It's a really nice idea.

ODTUG Kaleidoscope 2010: APEX Plugin Showcase

One of the best new features of APEX 4.0 is the extensible plugin architecture.  You will be able to create your own item and region types as well as custom dynamic actions (javascript enabled actions on the browser).  You'll be able to add these plugins right in to the builder so they are available to all of your developers.  You will be able to share (or even sell) these with the APEX community.  This is big.

Email BLOB Attachments From The Database

Recently I was developing an oracle database application and had the requirement to send out an email with an attachment. Initially it sounded pretty easy. I’ll just use the APEX_MAIL package and its all handled for me. But then I remembered, this was not an APEX application I was developing. So then I thought, no problem, I’ll just use the UTL_MAIL package. There is an API to add attachments. But wait, you can only add VARCHAR and RAW attachments and there is a max length of 32K on them.

Joel Kallman

(YABAOAE) Yet Another Blog About Oracle Application Express APEX
view counter