comments.sql

oracle dba 常用的管理脚本, 覆盖日常的系统管理.

--* File Name    : Comments.sql
--* Author       : DR Timothy S Hall
--* Description  : Displays all comments for the specified table and its columns.
--* Call Syntax  : @Comments (table-name) (schema-name)
--* Last Modified: 15/07/2000
PROMPT
SET VERIFY OFF
SET FEEDBACK OFF
SET LINESIZE 255
SET PAGESIZE 1000

SELECT a.table_name "Table",
       a.table_type "Type",
       Substr(a.comments,1,200) "Comments"
FROM   all_tab_comments a
WHERE  a.table_name = Upper('&1')
AND    a.owner      = Upper('&2');

SELECT a.column_name "Column",
       Substr(a.comments,1,200) "Comments"
FROM   all_col_comments a
WHERE  a.table_name = Upper('&1')
AND    a.owner      = Upper('&2');

SET VERIFY ON
SET FEEDBACK ON
SET PAGESIZE 14
PROMPT