APEX is promoted as the perfect replacement for MS Access applications. One thing you should consider though is how you migrate your data to the Oracle database. In APEX there is a handy tool called the Data Workshop that can be used for this. You first export your Excel files (more...)
I first blogged about build options
three years ago while still using APEX 3.x - I can tell by the green ;-)
I still use them regularly
, but not often for versioning as they're allocated at a component level and not for attribute modifications - perhaps in later (more...)
I recently was working on an application in Apex 4.2.1.00.08, where the application had several pages with Interactive Reports.
On all these pages, the IR worked fine – except for one crucial page, where the IR’s action menu didn’t work (Select Columns, for example, showed a (more...)
I find build options
as nifty tools to not only categorise components for the very purpose build options are documented for, but to help inform developers & testers of applications.
Here I've added a region on the global page to inform users of the status of the page - based (more...)
Representing hierarchical data in an APEX Tree is fairly straight forward, the wizard to create a tree region assists you with that. But when you need to show data from multiple tables, you will need to provide your own query. In a previous blogpost I have written how to achieve (more...)
I’ve just gotten around to reading the Patch Set Notes for Apex 4.2.3, and noticed this bit:
8.5 Changes in How Oracle Application Express Populates CLIENT_INFO in V$SESSION and GV$SESSION
The Oracle Application Express 4.2.2.00.11 patch set changes how Application Express populates (more...)
Oracle OpenWorld is a monster event – 10Ks of attendees, thousands of sessions and 100Ks of private conversations that all help convey and define the message about Oracle’s strategy and the roadmap for its close to 4000 thousand products. Concurrently with OOW is the JavaOne conference that – al a (more...)
In two previous blogposts I described a method to transform a regular APEX Tree component to a Tree component with checkboxes. The second blogpost described a way to retrieve the data from the database using JSON and AJAX and check the appropriate checkboxes. In this last part of the series (more...)
Just a little tip I picked up at the InSync13 conference from listening to Scott Wesley. If you have a lot of conditions that look like this:
(conditions based on a PL/SQL Expression, where the PL/SQL itself doesn’t actually call anything outside of Apex – it’s only dependent on variables (more...)
Am I the only one who finds this help message vaguely insulting?
Filed under: APEX
I saw a forum post
recently asking how to dynamically change the region title.
This is a little ambiguous - is this dynamic to the value set in APEX meta-data, or dynamic as a result of user events on the page?
Here is the instructions for the former. Soon I (more...)
If for some reason, you could not install the APEX packaged application via Application Builder > Packaged Applications interface, you have an option of installing it by importing the SQL script (fxxxx.sql).
In my case, when installing via the Packaged Applications interface, I got the following error:
While working (more...)
Why I try to post about Database Sizes on Oracle Multitenant Self-Service Provisioning. When I create New Database(PDB), I want other Maximum Storage sizes.
My idea is 500 GB and 2 TB... How to do? On "Self-Service Administration" - First, select "Self-Service System Configuration". Then select "Database Sizes".
A user can create notifications on Oracle Multitenant Self-Service Provisioning page. Notifications are displayed on the home page of this self-service application to communicate with users of this self-service system. Notifications are managed by application administrators but viewable by all users.
First, select "Administration", then select "Notifications".
Then, select "Add (more...)
It can be fairly simple to configure your APEX application to authenticate against your Active Directory server - this means your users can use the same username/password as the use to log onto their desktop machine - a big plus.
Declarative definition can be as simple as heading to Shared (more...)
On Oracle Multitenant Self-Service Provisioning page."Request an Account
", I thought that's very interesting for testing how it work.
Select "Request an Account
" and Fill in as below picture(Please fill in available email).Note: User are created by "Request an Account". They have Pluggable Database Administrator (more...)
It's too easy for dropping PDB on Oracle Multitenant Self-Service Provisioning. Just select "Drop", then select Datafiles - whether Including Datafiles (will remove datafiles)
or Keep Datafiles
Wow! ...Related Posts:Multitenant Self-Service Provisioning (BETA) - Database 12cMultitenant Self-Service Provisioning - Clone PDBMultitenant Self-Service Provisioning - Close/Open PDB (more...)
When use PDB, users want to plug & unplug PDB. I just wanted to unplug PDB on Oracle Multitenant Self-Service Provisioning. If PDB mode = OPEN, users must close PDB before.
After PDB mode = "Mounted", then started with "Unplug" again.Don't Forgot to remember - Unplug Path
Checked on (more...)
Just wanna test about Oracle Multitenant Self-Service Provisioning again. In this post, I wanted to test closing/reopening PDB. Previous post, I tested cloning PDB and some PDB (TESTPDB01) status = "READ ONLY.
Selected "Close/Reopen". Found below picture
It shows... Users can reopen as "READ WRITE" or "Close PDB"... Tested with (more...)