Usually software developers, project managers, and DBAs need to log into a production or test database to view the column definitions in a table or view. Potential problems might be:

• Locating a specific column in a table or view with hundreds of columns takes a long time
• To view a different database requires logging into that database instance
• Estimating row and table sizes need to be calculated
• Read access to the database must be provided to users

+1DataElements generates HTML documentation which:

• Displays the table and view descriptions as defined in the Oracle database
• Displays the table and view descriptions in sorted order to quickly find columns
• When run on Unix systems with a web server, can search for column names in all tables and views
• Displays the size of each column and average row size for one row
• Can be used to display table and view descriptions for one or more Oracle databases
• Can display table and view descriptions for multiple versions of the same database
• Can be integrated with +1Copybook product

Sample web pages from running +1DataElements for a small table are shown below.

CUSTOMER Table
Table - Sorted Table - Average Row Size - To Table Index

LAST_NAME                       CHAR(20)
FIRST_NAME                      CHAR(15)
AGE                             NUMBER(3)
PHONE_NUMBER                    CHAR(15)
DATE_LOADED                     DATE

CUSTOMER Table
Table - Sorted Table - Average Row Size - To Table Index

AGE                             NUMBER(3)
DATE_LOADED                     DATE
FIRST_NAME                      CHAR(15)
LAST_NAME                       CHAR(20)
PHONE_NUMBER                    CHAR(15)

CUSTOMER Table
Table - Sorted Table - Average Row Size Table - To Table Index

Column Name	Data Type	Bytes
LAST_NAME	CHAR(2)	2
FIRST_NAME	CHAR(10)	12
AGE	NUMBER(13,2)	16
PHONE_NUMBER	NUMBER(13,2)	20
DATE_LOADED	DATE	28

Each of the above would be displayed on their own web page. Index pages are generated to let you select which Oracle database and which table or view in the database to display. The above example is very simple. The true benefit of +1DataElements becomes obvious as the number of rows in a table or view increases to 50, 100, 200, or more columns.

+1DataElements is a powerful, yet easy tool to use. Compared with current approaches, +1DataElements saves time in locating, searching, sizing, and reviewing column descriptions in one or more tables.

+1 Software Engineering is a registered trademark of +1 Software Engineering.

Oracle, SQL*Loader, and all Oracle-based trademarks are trademarks or registered trademarks of Oracle Corporation in the United States or other countries. +1 Software Engineering is independent of Oracle Corporation.

All other product names are trademarks of their respective holders.