자주쓰는 소스(SQL)
select rpad('private ' || decode(a.data_type, 'NUMBER', 'int ', 'String ') || substr(lower(a.column_name),1,1) ||substr(replace(INITCAP(a.column_name),'_',''),2) ||';',30) ||'/* ' ||b.comments ||' */' from user_tab_cols a, user_col_comments b where a.table_name = b.table_name and a.column_name = b.column_name and a.table_name = upper(:tb);
카테고리 없음
2020. 7. 22. 15:34