테이블 layout 추출하기

[ORACLE VERSION 9i]

 

SELECT A.TABLE_NAME,

       C.COMMENTS,

       A.COLUMN_NAME,

       B.DATA_TYPE,

       B.DATA_LENGTH,

       A.COMMENTS

  FROM USER_COL_COMMENTS A, USER_TAB_COLS B, USER_TAB_COMMENTS C

 WHERE A.TABLE_NAME = B.TABLE_NAME

   AND A.COLUMN_NAME = B.COLUMN_NAME

   AND A.TABLE_NAME = C.TABLE_NAME

   AND A.TABLE_NAME LIKE 'T_%';

 

 

 

[ORACLE VERSION 8I]

 

  SELECT A.TABLE_NAME,

         C.COMMENTS,

         A.COLUMN_NAME,

         B.DATA_TYPE,

         B.DATA_LENGTH,

         A.COMMENTS

    FROM USER_COL_COMMENTS A, USER_TAB_COLUMNS B, USER_TAB_COMMENTS C

   WHERE A.TABLE_NAME = B.TABLE_NAME

     AND A.COLUMN_NAME = B.COLUMN_NAME

     AND A.TABLE_NAME = C.TABLE_NAME

     AND A.TABLE_NAME LIKE 'T_%';