Installing APEX 3.2.1

I know Oracle APEX 3.2.1 has been out for a little while now, and Oracle APEX 4.0 is on the horizon, but following my recent installation of Oracle XE on Windows 7 and subsequent upgrade to APEX 3.2.1 I thought I’d provide the steps I took to upgrade to version 3.2.1.

The steps provided are for upgrading to APEX 3.2.1 from an earlier version on Oracle XE. However, I’ve also included notes for upgrading and if you are using the EPG on 11g or a HTTP server on10g. Hopefully this will come in handy to anyone starting out with APEX.
Read the rest of this entry »

Dynamic Report Regions Tutorial

Sometimes requirements are such that you can’t write a simple SELECT statement to return the information you want to see on a page. For example, you might want a report that displays dates in the first column, names across the top and the task each person is performing on that date as the content of the report. I’ve written a scheduling application that requires a report exactly like this, however, I don’t know the date range or the people that the end user is going to want to see information for.

In another case we have a number of tables that all have the same structure. These are code tables that are used for Select Lists throughout our Forms and APEX applications. These tables all have the same four columns: identifier, code, meaning and an in use flag. There are hundreds of these tables so I don’t want to have to write a separate page to see the data in each of these tables. Not only would this take a considerable amount of time, but I’m likely to go crazy with boredom half way through! Luckily there is an easy solution to both these problems: Dynamic Report Regions. Read the rest of this entry »

Dynamic HTML Generated From PL/SQL Tutorial

Using APEX it’s very easy to display information using forms and reports regions, you could even throw in a chart or dial for a bit of something different. However, it’s also simple to generate HTML pages from PL/SQL code. This opens up a world of choice when it comes to designing and developing your application.

This tutorial is a simple demonstration of creating HTML output from PL/SQL code. It assumes that you have completed the APEX_ITEM Tutorial as it relies on the checkbox and ticked column that you create within this tutorial. Read the rest of this entry »

Adding a Checkbox to Your Report – APEX_ITEM Tutorial

OK, so you’ve got a report, but you want something more. You want to add functionality to your report. You want to be able to tick things and have it do stuff. Luckily there’s an easy way and it’s called APEX_ITEM.

This tutorial will talk you through adding a checkbox to your report and adding functionality to your page to identify records that are ticked and processing them.

This tutorial assumes you have a workspace with the Sample Application installed.

Read the rest of this entry »

Using Built-in Substitution Strings Tutorial – Part 3

In this series of tutorials we have looked at using the apex_application API and learned how to create dynamic branches to return to previous pages. In Part 2 we created a blank About page, which we will now build on using different substitution strings to add extra fields and information.

It is assumed that you have a workspace with the Sample Application installed, as we will be building on this application, and that you have worked through Exercise 2, as we will be adding to the page we created then. Read the rest of this entry »

Using Built-in Substitution Strings Tutorial – Part 2

Part one of this tutorial demonstrated the use of the apex_application API. This second part will build on this to look at other substitution strings that are available and how they can be used. The exercise below will create a simple “About” page that can be used for any APEX application. It is assumed that you have a workspace with the Sample Application installed as we will be building upon this application and it’s data structure. Read the rest of this entry »

Using Built-in Substitution Strings Tutorial – Part 1

One of the most common pieces of functionality we use as Oracle Forms developers is substitution strings. Everything from user and sysdate in triggers to system variables such as :system.current_item in Forms. Substitution strings are also used in APEX and this tutorial aims to show how these substitution strings can be referenced and used. It is assumed that you have a workspace with the Sample Application installed, as we will be building upon this application and its data structure. Read the rest of this entry »

Installing APEX Tutorial

Prior to training, we’ve found it really useful that developers install Oracle APEX and Oracle XE locally. Not only does this give them a safe environment in which to experiment, but it gives them an understanding of what Oracle APEX actually is. They can use this knowledge to help support our customer installations and in investigation of any setup or installation issues that we have.

The following step-by-step instructions have been followed successfully by many developers now and we’ve got the installation time down to well under two hours, including configuration. Read the rest of this entry »

Oracle APEX Tutorials

As we’ve recently started work on our first big APEX development, it was my task to train up a group of our Oracle Forms developers. Training took the form of a two day course, where I provided an overview of what APEX is, explained why we’ve chosen to use it and then provided practical training to allow them to start development. Obviously there have been a few questions along the way, but really the developers have been able to develop using APEX since the course finished. Read the rest of this entry »