dictionary table 종류를 검색하는 쿼리

1. 쿼리

SQL> set linesize 300

SQL> column TABLE_NAME format a30

SQL> column COMMENTS   format a30

SQL> select * from dict where table_name like 'DBA_HIST_SQL%';

2.결과

TABLE_NAME                     COMMENTS

------------------------------ ------------------------------

DBA_HIST_SQLBIND               SQL Bind Information

DBA_HIST_SQLCOMMAND_NAME       Sql command types

DBA_HIST_SQLSTAT               SQL Historical Statistics Info

                               rmation

DBA_HIST_SQLTEXT               SQL Text

DBA_HIST_SQL_BIND_METADATA     SQL Bind Metadata Information

DBA_HIST_SQL_PLAN              SQL Plan Information

DBA_HIST_SQL_SUMMARY           Summary of SQL Statistics

DBA_HIST_SQL_WORKAREA_HSTGRM   SQL Workarea Histogram History

8 rows selected.

SQL>  select * from dict where table_name like 'DBA_ALL_%';

TABLE_NAME                     COMMENTS

------------------------------ ------------------------------

DBA_ALL_TABLES                 Description of all object and

                               relational tables in the datab

                               ase

SQL>