ApEx 4.0: Websheet Objects

When creating a new workspace you might have noticed that there will be some extra tables on your schema.
All these table start with the name APEX$_ and are used for the websheets feature of the new version of ApEx.

If you don’t use websheets (at start) and you don’t want these extra tables present on your schema then you can prevent the creation of these tables by following the next steps:
– Login into the internal workspace
– Go to Manage Instance -> Feature Configuration
– Set “Create Websheet objects in new workspaces” to No

Please keep in mind that the above action will still allow developers to make websheets. If these objects do not exist then the developer will see a warning message when he/she tries to create a websheet. You then will able to create these objects again:

If you have the Websheet Objects on your schema and you wish to remove them then go to “
Home -> Administration > Manage Service -> Websheet Database Objects” and there you can safely remove these objects.

ApEx 4.0 Quick Picks

A feature that hasn’t been highlighted much is the Quick Pick functionality with items of type “Popup LOV” and “Select List”.

This features enables you to make a quick choice from the the list values in the LOV. Only downside is that you can’t use a query or function that returns the Quick Picks. However you can still reference to other items using the &MY_ITEM. notation.

This is how you set it up:

This is the result:

ApEx 4.0 Region Selector

Last year on ODTUG I did a presentation where I showed my own implementation of region tabs. These are extra buttons to display regions in a more user friendly way. Suppose you have a lot of regions on your page then you could present a list of buttons, each button will show/hide a region.

I’m pleased to announce that in ApEx 4.0 you can do this declarative by using a new region type: “Region Display Selector”.
To set it up just follow these simple steps:

- First alter any existing region on your page and set the Region Display Selector to YES. You can find this setting under Region Attributes.

Region Display Selector

- Make a new region of type Region Display Selector

Region Type Display Selector

- You can add more regions to the display selector by setting the Region Display Selector to YES

Region Type Display Selector

You can see my own implementation of region tabs in the next photo gallery:

ApEx 4.0 available for download

ApEx 4.0 has been released. You can download the new version of ApEx on the website of Oracle.

You can read about the new features of Application Express 4.0 here.

Please mind that the requirements are changed:

Oracle Application Express 4.0 is supported on all Editions (SE1, SE, EE, and XE) of the Oracle database, 10.2.0.3 or higher. Application Express 4.0 can also be used with Oracle Database 10g Express Edition.

Patch for SQL Developer 2.1 released

Just noticed that a patch is released for SQL Developer 2.1. From the Oracle website:

Oracle SQL Developer 2.1.1 is a patch release to SQL Developer 2.1, which was released in December 2009. This patch release resolves a number of the issues raised and addresses a few additional feature requests raised on the SQL Developer Exchange.

You can download it here.

SQL Developer and ApEx: Application missing

Last week I was searching for a long time to find my application in SQL Developer. I wanted to deploy it to a production environment, the application had APP_ID 113 but I couldn’t find it in SQL Developer:

After some time I noticed an other application that had the same name: “Daily Report”. After I changed the name of my application to “Daily Reports”, I could see it in SQL Developer and deploy it!

ApEx 4.0 : Tabular Form Validations

An other nice feature of ApEx 4.0 will be the option to create tabular form validations. This will give tabular forms the only thing it missed so far, an easy way to validate the data before you try to save it.

In the previous editions you could write your own validation for a tabular form but you had to take care of the session state of the data you filled in, otherwise the date you changed would be lost if a validation was triggered.

An other option you could use was to implement the famous ApExLib Framework from Patrick Wolf.

To create a tabular form validation in ApEx 4.0 you just create a new validation and you will see that an extra option is present:

Step 1

Continue reading