오라클 테이블 및 칼럼 내역 보기

 SELECT

     A.Table_Name    AS TableName,

     A.COLUMN_NAME   AS columnName,

     A.DATA_TYPE     AS dataType,

     A.DATA_LENGTH   AS dataLength,

     B.COMMENTS      AS comments,

     A.NULLABLE      AS nullAble

  FROM dba_tab_columns A,   all_col_comments B

WHERE A.OWNER = B.OWNER

     AND A.TABLE_NAME = B.TABLE_NAME

     AND A.COLUMN_NAME = B.COLUMN_NAME

     AND A.OWNER = 'EJMIS'

     AND A.Table_Name NOT LIKE 'BIN%'

   Order by TableName, ColumnName

    -- AND 조건으로 테이블명 선택시 생성하게끔도 가능

    -- AND A.TABLE_NAME = #tableName#