Table 내역 보기

Table 내역 보기

SELECT A.TABLE_NAME
      ,A.COLUMN_NAME
      ,A.DATA_TYPE
      ,NVL(A.DATA_PRECISION, A.DATA_LENGTH) DATA_SIZE
  FROM COLS A
      ,(SELECT TABLE_NAME
          FROM SYS.DBA_TABLES
       ) B
 WHERE A.TABLE_NAME = B.TABLE_NAME
 ORDER BY 1, 2