kfsql.txt

一个建立Oracle序号发生器并调用的小例子程序,其中包含Oracle中序号发生器的建立

select * from nszx
delete from nszx where sjbh>'2569'
select * from zygsgg 
update lmlb set lmbh='99' where lmbh='099'
delete zygsgg where sjbh='FB0000001167'
select b.lmmc,a.qymc,a.nsrsbh,c.lmmc,a.se,a.sqq,a.sqz from pgt a,lmlb b,lmlb c
insert into pgt(sjbh,lmbh,qymc,sz,sqq,sqz) values('FB9999999998','014001','20040420','014','20040101','20040419')   
select b.lmmc,a.qymc,a.nsrsbh,c.lmmc,a.se,a.sqq,a.sqz from pgt a,lmlb b,lmlb c where a.ztbz<>'02' and a.lmbh=b.lmbh and a.sz=c.lmbh order by a.qymc,a.sqq

*************建立序号发生器***************使用nszx_sjbh.java类来产生，在数据库中自动加1
create sequence SEQ_NSZX_SJBH 
    increment by 1 
    start with 1 
    maxvalue 999999999 
cycle; 



*********加入一条案件曝光数据的SQL语句********
insert into pgt(sjbh,lmbh,qymc,sz,sqq,sqz,ztbz) values('FB9999999997','014001','20040420','014001','20040101','20040419','01')   

update zygsgg set url='/jsp/publish/wzlm/xwgg/zyggtz/FB0000000020.shtml' where url='/jsp/publish/wzlm/xwgg/ggtz/FB0000000020.shtml'
update zygsgg set url='/jsp/publish/wzlm/xwgg/zyggtz/FB0000000021.shtml' where url='/jsp/publish/wzlm/xwgg/ggtz/FB0000000021.shtml'
update zygsgg set url='/jsp/publish/wzlm/xwgg/zyggtz/FB0000000022.shtml' where url='/jsp/publish/wzlm/xwgg/ggtz/FB0000000022.shtml'