해당 필드명이 들어간 테이블 조회 SELECT USER_TAB_COLUMNS.TABLE_NAME as TNAME, USER_TAB_COMMENTS.COMMENTS as TCMT, USER_TAB_COLUMNS.COLUMN_NAME as COL_NM, USER_COL_COMMENTS.COMMENTS as COL_CMT, USER_TAB_COLUMNS.DATA_TYPE as TYPE_CD, DECODE(USER_TAB_COLUMNS.DATA_TYPE, 'NUMBER',USER_TAB_COLUMNS.DATA_PRECISION ||'.'||USER_TAB_COLUMNS.DATA_SCALE, USER_TAB_COLUMNS.DATA_LENGTH) as LENGTH, USER_TAB_COLUMNS.NULLABLE a..

--------------------------- 적당한 노가다가 좋아요. +_+ --------------------------- SELECT 'private ' || DECODE(DATA_TYPE,'DATE' , 'String' ,'CHAR' , 'String' ,'VARCHAR2', 'String' ,'NUMBER' , 'int' ,DATA_TYPE) || ' ' || LOWER(A.COLUMN_NAME) || ';' || ' // ' || B.COMMENTS FROM USER_TAB_COLUMNS A , USER_COL_COMMENTS B WHERE 1=1 AND A.TABLE_NAME = B.TABLE_NAME AND A.COLUMN_NAME = B.COLUMN_NAME AND A.TABLE_N..

해당 필드명이 들어간 테이블 조회 SELECT USER_TAB_COLUMNS.TABLE_NAME as TNAME, USER_TAB_COMMENTS.COMMENTS as TCMT, USER_TAB_COLUMNS.COLUMN_NAME as COL_NM, USER_COL_COMMENTS.COMMENTS as COL_CMT, USER_TAB_COLUMNS.DATA_TYPE as TYPE_CD, DECODE(USER_TAB_COLUMNS.DATA_TYPE,'NUMBER',USER_TAB_COLUMNS.DATA_PRECISION ||'.'||USER_TAB_COLUMNS.DATA_SCALE, USER_TAB_COLUMNS.DATA_LENGTH) as LENGTH, USER_TAB_COLUMNS.NULLABLE as..