Skip to main content

Oracle Application Express (APEX/HTMPDB) Global System Variable or Subtitutes

If you are using a static value number of times in your Oracle Application Express (APEX) application that you have to change on all occurances if the value had changed. For example if you had a system with a url used all over pages and had changed you would have to go and change the variable defined in every page for it to take correct effect throughout application.

There is a way to define a global variable as long as you have a static value to go in it. Please find below how you define and use this global system variable in apex applications.

  1. Login to application express as Administrator.
  2. Click Application Builder
  3. Select the application.
  4. Go to Shared Components
  5. Click  Globalization Attributes under Globalization section
  6. Select Definition tab
  7. Select Subtitutions tab
  8. Here you can define Subtitution Strings with their corresponding values
  9. For example you can define string "MYEXTERNALURL" with value "" and click Apply Changes.
  10. Once defined inside your page Region source definition within your SQL code you can use ":MYEXTERNALURL" rather than putting full domain name again and again.

Note: Oracle Application Express or APEX v4.x is now released with lot of fixes and improvements.

Popular posts from this blog

TrueCrypt on macOS X Mojave 10.14

If you have updated your macOS recently to Mojave otherwise known as verison 10.14 you may not be able to install the last version of Truecrypt in order to access your old volumes encrypted with Truecrypt software. This article will guide you to get this working on your MacOS v10.14 (Mjoave).

Download the package from or
Find downloaded package using Finder in your HDD/Users/username/Downloads folder and will look like TrueCrypt 7.1a Mac OS X.dmg.

Open file location in Finder and open or double click on TrueCrypt 7.1a Mac OS X.dmg. This will mount Truecrypt 7.1a and will have Truecrypt 7.1a.mpkg in it.

Drag the package TrueCrypt 7.1a.mpkg and drop in your Downloads folder.

From Locations in Finder you can eject your TrueCrypt mount.

Now go to your Downloads location, find the file TrueCrypt 7.1a.mpkg, right click and select Show Package Contents. Find the file Contents/distribution.dist and open with your favourite edi…

Starting with Python

New to Python, don't feel behind and get started now, it is never too late.
Here we have some useful links you will need to get you going.

CoVid-19 Statistics and Charts

Statistics based on some specific metrics are listed below. The data is based on daily information from Worldometer and updated manually. Charts will update automatically.

Please use links below to get to individual charts and feel free to bookmark this page but do not bookmark direct chart link as it may change. These charts compare statistics for countries including China, Italy, UK, US, Pakistan & India.
(Does not work in Safari Mobile)

Please click on links below for specific chart, more to come.

Death Doubling RateChart showing death rate doubling in x number of days.

Survival RateThis chart shows trend of patients successfully recovered vs total closed cases.
Death rate comparisonComparison of deaths per cases every day showing trend comparison and days behind.
Cases reportedNo of cases reported, how far they are behind each other and trend. Deaths reported No of deaths reported with trend comparison between three countries.

The data for these charts is extracted directly from John Ho…