sql

查询主键：
select a.column_name from user_cons_columns a, user_constraints b
where a.constraint_name = b.constraint_name and b.constraint_type = 'P' and a.table_name = 'CP_TEST';

生成复制语句：
select 'INSERT INTO CP_TEST (INT_APP_STYLE_ID,' || WMSYS.WM_CONCAT(column_name) || ') SELECT CP_TEST.NEXTVAL,' || WMSYS.WM_CONCAT(column_name) || ' FROM CP_TEST'
from user_tab_columns where table_name='CP_TEST' AND column_name != 'INT_APP_STYLE_ID';

oracle日志超4G，不能接受链接：
http://www.askmaclean.com/archives/2gb-listenerlog-198-days-instance.html