The "Read Me" guides you through installing the demo application in an Oracle Database, and setting up a professional software development environment.

Read Me    

The demo application contains the following:

• An installer to create the schema, load test data, and compile the PL/SQL code.
• A schema based on Oracle's training database, containing Sales Order and Employee data.
• Additional tables for CSV import, error logging, defining holiday dates, and storing statistics data.
• PL/SQL packages: Functions that do useful things with dates, strings, and numbers.
• Binary search functions.
• A library of statistics functions.
• Applications to import and export data via CSV files.
• SQL reports.
• Test scripts.
• Database administration scripts.
• Source Code Templates.

Documentation included:

• A guide to creating an application development environment
• Coding Standards, including object naming, and PL/SQL programming tips
• Database Normalization
• Specification templates
• Functional and Technical specs, plus a user guide for the data import app

The application programs have been created using the PL/SQL language. The program modules, functions and procedures, are stored in Packages, which reside in the database.

Public procedures and functions are declared in the Package Specifications, and can be called by database users to perform useful tasks.

Packages
Package Name	Description
EXPORT	Export data to CSV files
IMPORT	Import data from CSV files with validation and error handling. Sales orders, statistics.
ORDERRP	Rules package for Order related functions, for example currentprice returns the price that is currently in effect for a product. This saves repeating code and reduces maintenance effort.
PLSQL_CONSTANTS	Define all your non-table related data types and constants here, rather than hard-coding in your programs.
UTIL_ADMIN	Admin functions such as error logging and messaging.
UTIL_DATE	Date of Easter and related holidays. Is today a working day? Last working day of the month.
UTIL_FILE	File handling functions, such as load data from a CSV file into a staging table, rename files etc.
UTIL_NUMERIC	Number manipulation functions: Binary searches. Base conversion. Duplicate removal. Excel Column labels (convert number to alpha code). Factorial. Sorting. Statistical functions e.g. Standard Deviation, Percentiles.
UTIL_STRING	String handling functions: Extract fields from a delimited string (used by the CSV import). Sort strings. Convert escaped characters (e.g. \n to New Line ASCII char 10)