Recovering a deleted page in APEX


Posted by Hafed | Posted in apex(htmldb), oracle | Posted on 12-06-2015

In case a page is deleted in APEX, we can recover it using the export feature of APEX. The steps are as follows:

Open the application in application builder

Export application and then select the option -export page-. from there, the dropdown list shows only the pages that are in the application. You have to select the timeframe you need.

In order to select the deleted page, you have to tweak the HTML and this is where we use firebug to modify the list in order to add the option for the deleted page

Once it is done, the export will allow the export of the page

Returning to the import/export option of the application and from there select the file that was exported and import it. The page will be placed in the app.

For a full step by step explanation , see the original post by Peter raganitsch

Enterprise manager woes and a solution


Posted by Hafed | Posted in oracle | Posted on 16-04-2015

With enterprise manager for Oracle 11g R2, it seems there are endless ways to have it stop working. One excellent article that I used to get enterprise manager work again is found on oracle-base website. Here is the link 

Frite and other javabeans download


Posted by Hafed | Posted in oracle, Other tools | Posted on 16-08-2013

The downloads are no longer available through Sourceforge. I will be adding a download page on for all of the available documents including Frite and other tools.

In the meantime, you can send me an email and I will forward the tools you need. Please be advised that gmail accounts do not accept zip attachments.


Update september 2013: I have uploaded the different tools in the downloads page.  Please leave a comment if you find the tools useful.


Oracle 12c presentation By Tom Kyte – Montreal- Canada


Posted by Hafed | Posted in oracle | Posted on 31-05-2013

This month of May 2013, we had the pleasure of receiving the well known Oracle Expert Mr Tom Kyte here in Montreal. The presentation lasted almost two hours with the main emphasis on the upcoming Oracle 12c database. Most notably, Mr Kyte described the various new features including those for PL-SQL.

However, the most striking new feature is the change in the Oracle architecture. From now on, there is one instance that controls a number of databases. Better get used to the Catalog and container concepts.

On a personal level, I was lucky to receive two tickets to the upcoming soccer game between the Montreal Impact and the Houston team (MLS). As a bonus, here is my picture with Mr Kyte and the Oragec president. What a day …

Oragec Montreal Prestige 2013. Hafedbenteftifa with Tom kyte

Oragec Montreal Prestige 2013. Hafed Benteftifa with Tom kyte

Migrating from Oracle Forms to APEX


Posted by Hafed | Posted in oracle | Posted on 28-05-2013

Yesterday, I  gave an impromptu talk about migrating from Oracle Forms to APEX. The aim was to highlight the different options or paths to follow when deciding about a migration strategy. I also touched upon migrating from Excel/Access to Forms. Here are the screenshots from that presentation. A translation of  each one is given below the screen capture.

Screen 1

Introduction migration to APEX

Introduction migration to APEX

Read the rest of this entry »

New APEX release 4.2


Posted by Hafed | Posted in apex(htmldb), oracle | Posted on 22-06-2012

The team in charge of APEX at Oracle has just released the early adopter version 4.2. Of the main striking features is the package applications option. Préviously, those applications were available on Oracle OTN and then were later removed.

Now, you can access them from the application dashboard as shown in the screenshot below.

apex 4.2 packaged applications

Oracle Apex 4.2 packaged applications

The list of all the enhancements to the new version can be found here:


ORAGEC-Oracle APEX day – Montreal Oct 2011


Posted by Hafed | Posted in apex(htmldb), oracle | Posted on 14-10-2011

Yesterday, there were a number of presentations on the new Oracle APEX 4.1 version.

The presentation by David Peake, APEX product manager from Oracle, highlighted the new features available in 4.1. Read the rest of this entry »

Feedback on teaching Oracle APEX


Posted by Hafed | Posted in apex(htmldb), oracle | Posted on 22-06-2011

Today, I  finished the spring session teaching Oracle APEX to 2 groups of students. The majority had prior experience with Oracle Forms with some having more than 7 years experience developing Forms application.

Most had a desire to explore APEX as a tool since they read a lot about it but were unsure whether they could transition smoothly to developing APEX web applications.

Read the rest of this entry »

APEX Early adopter ver 4.1


Posted by Hafed | Posted in apex(htmldb), oracle | Posted on 08-05-2011

APEX EA 4.1 is out. Evaluation workspaces can be requested at

Some of the notable improvements that can be seen right away are the APEX Builder Dashboards, which  in this version show only the most important information. However, there are other improvements as well that can be seen once you login to APEX.

Switching to Oracle Apex or … not ?


Posted by Hafed | Posted in apex(htmldb), oracle | Posted on 14-03-2011

I have been following Oracle Apex since 2004 and while I was no big fan at the beginning, I am more and more inclined to say that there is a case for adopting this tool in a number of cases, especially in situations where budget and time are severe constraints. I will try to summarize my current experience with Oracle Apex.

Please bear in mind that I wrote this post as a way to explain to a friend whether it makes sense to switch to Oracle Apex or Oracle JDeveloper coming from an Oracle Forms perspective.

Good points

  • Shared components: excellent repository approach that will boost the productivity of any team. Important stuff that I have been using are: LOV, templates, Lists, application items and globalization. Read the rest of this entry »