Oracle Based Software
Macrotone Consulting in addition to writing bespoke Oracle packages and procedures, prepares generic code that is available upon request. Some of the code may have specific database version dependencies.
This package supports both database trigger auditing and Fine Grain auditing, and provides a simple interface to implement these features upon database schema’s. Tested and developed on Oracle 9.x and Oracle 10.x.
Data Scrambling Package
This package enables sensitive data to be removed from a client site (subject to client agreement) by masking the identified table data columns with random data of the same data length and type. This preserves the data characteristics but ensures no real data information can be seen. Any foreign key constraints dependant upon the masked columns would be disabled. Tested and developed on Oracle 9.x and Oracle 10.x.
This package determines the number of working days between two specified dates. It can automatically calculates the Bank Holidays that occur within the specified period and subtracts them from the total available. It correctly allows for the different parts of the UK such as Ireland, Wales and Scotland, which have different holidays. The Bank Holiday determination is optional, otherwise it only allows for Saturday and Sunday being non-working days. Optional also is whether the start date is also included in the calculation. Tested on Oracle 9i, 10g and 11g.
Recently Closed Issues
Close date: 2014-02-13 17:28:26
Close date: 2014-02-12 16:53:09
Close date: 2014-01-30 16:30:03
Close date: 2014-01-30 16:05:00
Close date: 2014-01-28 09:41:16
Quote(s) of the Day
Marriage is an attempt to solve problems together which you didn't even have when you were on your own.
Fortune does not change men, it unmasks them.
It is entirely seemly for a young man killed in battle to lie mangled by the bronze spear. In his death all things appear fair. But when dogs shame the gray head and gray chin and nakedness of an old man killed, it is the most piteous thing that happens among wretched mortals.
Homer, The Iliad