[ORACLE] TABLE_NAME, COLUMN_NAME

 

오라클 테이블 이름 select

SELECT B.TABLE_NAME, C.COMMENTS,  A.COLUMN_NAME, D.COMMENTS, A.DATA_TYPE, A.DATA_LENGTH
 FROM ALL_TAB_COLUMNS A  ,
           ALL_TABLES  B   ,
           ALL_TAB_COMMENTS C,
           ALL_COL_COMMENTS D
 WHERE A.TABLE_NAME = B.TABLE_NAME
      AND A.TABLE_NAME = C.TABLE_NAME
      AND A.TABLE_NAME = D.TABLE_NAME
      AND A.COLUMN_NAME = D.COLUMN_NAME
      AND A.TABLE_NAME ='PROF%';