dulildx的专栏

select text from user_source where type='PROCEDURE' and name='PRO_E_F_PAYTYPE_SUMMARY'

1、C3p0："class"=com.mchange.v2.c3p0.ComboPooledDataSource2、Proxool："class"=org.logicalcobwebs.proxool.ProxoolDataSource3、Dbcp："class"=org.apache.commons.dbcp.BasicDataSource 使用详情

查看锁表进程SQL语句1： select sess.sid, sess.serial#, lo.oracle_username, lo.os_user_name, ao.object_name, lo.locked_mode from v$locked_object lo, dba_objects ao, v$se

最高效的删除重复记录方法 查出最小的rowid 删除比最小的rowid大的所有行DELETE FROM EMP E WHERE E.ROWID > (SELECT MIN(X.ROWID) FROM EMP X WHERE X.EMP_NO = E.EMP_NO)