PL/SQL Library
config.bat - connection data and table names.
TableStructure.sql - script shows the table structure and comments.
TableStructure.bat - runs sql script for all project tables.
Result in file TableStruktur.html:
Business Objekt TABLE_NAME
- Kontext: bla bla bla.
- Inhalt: bla bla bla.
- Beladungszyklus: bla bla bla
- Datenaktualitaet: bla bla bla
- Hinweise: bla bla bla
- ETL-Package:bla bla bla
- SVN: bla bla bla
| Spaltenname | Datentyp | Null? | Default | Kommentar |
| EMPLOYEE_LOGIN | VARCHAR2 (20) | N | bla bla bla | |
| NTMAIL | VARCHAR2 (4) | N | ... | |
| EMPLOYEE_LOGIN | VARCHAR2 (20) | N | bla bla bla | |
| RESELLER_ID | NUMBER (22) | N | bla bla bla |
DataAmount.sql - Script shows info about table amount and index of growth.
Result in file DataAmount.html:
| Tabellenname | Average records count per month | Data storage amount (MB) per Year | Index storage amount (MB) |
| TABLE_NAME_1 | 14516 | 18 | |
| TABLE_NAME_2 | 10863 | 12 | 18,56 |
| TABLE_NAME_3 | 2343,25 | ,88 | 2,25 |
| TABLE_NAME_4 | 4232,63 | 3 | 3,5 |