| Installation script for Oracle Education's famous Scott/Tiger schema. | |
| Demonstration application based on Oracle's Scott/Tiger schema. Includes scripts to create the schema, additional tables, PL/SQL packages, and a guide to application development. | |
| Installation guide for the demo application. Includes: Application Development, Database Design, Normalization, Coding Standards, Object Naming, PL/SQL Programming Tips. | |
| Source code (C++) for the Oracle demo installer. The installer prompts the user to specify the target database schema,
application, and data home directories. The files are copied to the target directories, configuration scripts are generated, then SQL
scripts are executed to create the schema objects and compile the PL/SQL packages. To compile the program: g++ setup.cpp -o setup.exe -static -static-libgcc -static-libstdc++ -lshlwapi -lole32 -luuid |
|
|
|
Oracle Whitepaper: Why use PL/SQL? Author: Bryn Llewellyn. November 2016. |
|
|
MD050 Oracle Applications Extension Functional Design template. |
|
|
MD070 Oracle Applications Extension Technical Design template. |
|
|
Generic Technical Specification Template. |
|
|
Technical Specification for a CSV file data import program, implemented with PL/SQL. |
|
|
Technical Specification for Sales Order data import via a CSV file, implemented with PL/SQL. |
|
|
User Guide for Sales Order data import via a CSV file. |
|
|
PL/SQL Package Specification template for you to modify. |
|
|
PL/SQL Package Body template for you to modify. |
|
|
SQL template for you to modify |
Downloads
 |