sql script library parser

From: Vitaliy Mogilevskiy <vit100gain_at_earthlink.net>
Date: 12 Nov 2001 18:56:06 -0800
Message-ID: <b8e0d722.0111121856.775ea30c_at_posting.google.com>

I finally finished working on SQL Directory - SQLDIR.

If you are using DBAToolZ SQL Script library come and check what SQLDIR can do for you:

Highlights:

• Creates searchable SQL script directory accessible from SQL*Plus.
• Automatically scans SQL scripts for description and group assignments.
• Portable design runs on WINDOWS and UNIX platforms.
• Enterprise solution for custom SQL*Plus script management.

SQLDIR creates a searchable directory of SQL scripts to aid an Oracle DBA. Directory is stored in Oracle database and is accessed via SQLDIR SQL*Plus script. SQL scripts are automatically scanned for description and are assigned to SQL Group (Categories). This is achieved by embedding two pairs of SQLDIR tags:

Group TAG:

    <SQLDIR_GRP></SQLDIR_GRP>
    SQLDIR assigns sql scripts to predefined groups using this tag.

Description TAG:

    <SQLDIR_TXT></SQLDIR_TXT>
    SQLDIR parses sql script descriptions using this tag.

SQL scripts can be assigned to one or many groups for ease of management and access though SQLDIR menu. SQLDIR groups are defined in special configuration file that can be customized to suit your environment.
Demo version is available now.

Regards,

--
Vitaliy Mogilevskiy
DBAToolZ
http://www.dbatoolz.com

Received on Tue Nov 13 2001 - 03:56:06 CET