This is Spear

select A.TABLE_NAME, A.COMMENTS, B.COLUMN_NAME, B.COL_COMMENTS, C.COL_NO, C.DATA_TYPE, C.DATA_LENGTH, D.CONSTRAINT_TYPE, D.POSITION, C.NOTNULL_YN from ( select table_name, comments from ALL_TAB_COMMENTS where owner = '#유저명#') A, ( select TABLE_NAME, COLUMN_NAME, COMMENTS AS col_comments from all_col_comments where owner = '#유저명#') B, ( SELECT TABLE_NAME, COLUMN_NAME, TO_NUMBER(COLUMN_ID) +1 AS c..