yehuiling的专栏

 public void insertWorkProjects(List listWorkProject)   throws CustomException {  Session session = null;  Transaction transaction = null;  try {   session = HibernateSessionFactory.getSession();   tr

//bug编号是否重复select bug.bug_code,count(bug.bug_code) c from bug_record buggroup by bug.bug_codehaving count(bug.bug_code)>1 //修改bug编号 sql拼update bug_record bug set bug.bug_code=(select 6-01_bug

  DECLARE  tablespace_name        varchar2(100);  tablespace_file        varchar2(100);  tsql                   varchar2(500);BEGIN     tablespace_name := DG;                      --表空间名称

----普通的SQL语句 查询第10页的数据select * from (select rownum as rn,t.* from 表名 t where rownum=101-- 带排序的SQL语句 查询第10页的数据（速度慢）select * from (    select rownum as rn,t.* from    (        select