[Oracle] Domain Class 만들기(모델 만들기)

select A.column_name, A.data_type, B.comments
, 'private '||DECODE(A.data_type,'VARCHAR2','String','NUMBER','long','String')||' '||LOWER(A.column_name)
||';'||'  // '||B.comments
from all_tab_columns  A, all_col_comments B
WHERE A.table_name = 'HCMS_HNBK_RCV_PTCL'
AND A.owner = 'AWF_USER'
AND A.OWNER       = B.OWNER
AND A.TABLE_NAME  = B.TABLE_NAME
AND A.COLUMN_NAME = B.COLUMN_NAME;