SQL Script Display Data Dictionary Descriptions

Updated: 31-Dec-2002
Version: 1.0

Description

This script displays the name and description of all tables matching the search string given.

Parameters

1 - The search string

SQL Source

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 

set verify off
set feed on
set pages 200

col table_name form a25
col comments form a45 wrap

select * from dictionary where table_name like UPPER('%&1%')
order by table_name
/

Return to Index of SQL Scripts

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links