APEX

Introduction The last article provided a quick introduction to REST APIs. Now we will use a simple REST API to develop an APEX application using a real world example. Football Web Pages I enjoy watching football (soccer). My local team are Kingstonian FC, a non-league team in South West London. Kingstonian play in the seventh tier of English football. Kingstonian’s players are semi-professional so the players hold down jobs and train and play part-time....

Data masking with APEX Background A common customer requirement is to mask sensitive or personally identifiable data from APEX reports. Oracle has a ‘Data Masking and Subsetting’ product that performs this task. However, for smaller APEX projects, the full blown data masking product might be overkill as it needs familiarity with the product and configuration. This may be time consuming and expensive. However, we are able to use the PL/SQL package DBMS_REDACT to achieve the same result....