vo생성쿼리

select rpad('private '
||decode(a.data_type,'NUMBER','int','String')
||' '
||lower(substr(a.column_name,1,1))
||substr(replace(initcap(a.column_name),'_',''),2)
||';',30)
||nvl2(b.comments,'/* '||b.comments||' */','')
from user_tab_cols a, user_col_comments b
where a.table_name=upper(:TB) and
b.table_name=upper(:TB)
and a.column_name=b.column_name;