working with technology

It is very popular to install Oracle database Express edition on one's laptop , XE is a small and light footprint of Oracle database which is very good to serve as a repository database for many products.

I have been using XE on my laptop for a long time and when I install Hyperion Essbase 11 today, I use XE as the hyperion repository natrually and I realize that the default parameters of XE is really small and we have to change it to bigger value for the installation to be sucessful.

Installation of EssbaseRead more

What kind of applications could you build using Apex ?

The best way to find out what could you do with apex is to see the demo  apex application from Oracle. Oracle provide many demo Apex applicaiton at the website http://apex.oracle.com , It is really useful for beginners to download these apex demo applications and install it in your own development enviroment and play with it. This process is also called the import of Apex applications. Importing an existing Apex application is really easy. and require only a few steps.Read more

Oracle Application Express - Apex seems to become a standard component for Oracle database now! Cause when I install Oracle database 11g and create database using the DBCA, Apex is installed and configured into the database by default.Read more

What is Apex workspace?

Workspace is an very important concept for Apex, We know that a tablespace is a container for database data, and apex workspace is like an 'container' for Apex Applications and data. Usually a workspace is related with a database schema, the apex applications definition and data will be stored in the schema default tablespace. The relationship is as the following graph:

Read more

Recently I use Oracle application express to develop a partner management applications, The more I use it , the more I feel that it is really great tools that we all should learn to use it to develop small applications to improve productivity of our daily work.
It is easy to learn and most of the functionality is wizard guided. It surely serve as a great 'Excel replacer' or 'Excel enhancer' , most important of all , it is free!Read more

To add multiple chart and tabular table to the same apex page is an common requirement for apex applications development. and it is easy to implment this feature using apex 's concept of 'Region'.

For Apex, Each chart or table is placed inside a 'region', so multiple 'region' could be arranged on different section of the same page to make up the multiple chart on the same page effect.

The above Apex page is made of two region which data could be draw from totally different data tablesRead more