MS Visual C++ Tool to represent the table structure hierarchy of an Oracle database

From: Valentin Welter <valentin.welter_at_t-online.de>
Date: 4 Feb 2003 10:48:15 -0800
Message-ID: <7f0ff6a5.0302041048.794984e4_at_posting.google.com>



You can find this item on my homepage
http://valentin.welter.bei.t-online.de

This tool displays the hierarchical table structure of a schema / user of an Oracle (relational) database in the same manner like the directory / file structure representation used by Windows Explorer.
1. Prerequisites
To use this package the user needs:
· Oracle Client or Personal Oracle for Windows
· Visual C++ developer kit

2. Package components
· TableRel.sql: SQL script, which creates the parent – child
table relationships of the given database and schema / user.
· DBTree.exe: transforms the table relationships into Visual
C++ resources.
· MFCTREE3: Visual C++ project files.
· Auxiliary files: template.rc and template.h, which are
template Visual C++ files.

3. Getting start
· Start the DBTree.exe program.
· Fill out the input fields.

Remarks
- Since some users may not have the "Create session" privilege, the schema could be another one than the user. The user has to fill out the both fields.
- The Table relationship file represents the output file, which is created by TableRel.sql script. It is also the input file of the Resources Interface function.
· Execute the package functions in the given order:

-        Table relationships: creates the Table relationship file.
-        Resources Interface: transforms the table relationships into
Visual C++ resources.
-        Compile resources: recompiles the program Mfctree3.exe with
the new resources
-        Show DB Tree: executes the program Mfctree3.exe, which
displays the hierarchical table structure of the schema.

Remarks
- The user can create Table relationship files for different databases / schemata.
- For the already existing Table relationship files the user has to fill out only the field Table relationship file and then to execute the functions:
Resources Interface, Compile resources and Show DB Tree. - Just to display the last time created and compiled resources the user can execute either the function Show DB Tree or the program Mfctree3.exe.  

The program DBTree.exe uses the methods of binary trees and recursive procedures based on the LIFO principle
described at http://valentin.welter.bei.t-online.de – Demos & More – DemoDBTree.  

Have a lot of fun! Received on Tue Feb 04 2003 - 19:48:15 CET

Original text of this message