ITPUB个人空间 »
andytianyi的个人空间
欢迎访问 andytianyi 的个人空间
我的论坛主题
-
2008-05-06 15:53:41 / Oracle开发
create sequence SQ_Messagequeueminvalue 1maxvalue 9999999999start with 541increment by 1cache 20cycleorder;create or replace trigger TG_Messagequeuebefore insert on Messagequeuefor each rowdeclare-- local variables herenextId number(20);beginselect SQ_Messagequeue.nextval into nextId from dual;:new.sid := nextId;end TG_Messagequeue;
查看(350)
评论(4)
-
2008-05-06 15:18:21 / Oracle数据库管理
create sequence SQ_Messagequeueminvalue 1maxvalue 9999999999start with 541increment by 1cache 20cycleorder;create or replace trigger TG_Messagequeuebefore insert on Messagequeuefor each rowdeclare-- local variables herenextId number(20);beginselect SQ_Messagequeue.nextval into nextId from dual;:new.sid := nextId;end TG_Messagequeue;[ 本帖最后由 andytianyi 于 2008-5-6 15:53 编辑 ]
查看(244)
评论(4)
-
2008-04-09 10:33:25 / Oracle开发
selectltrim(substr('#11111#222222#33333333#LP444444', instr('#5555555555#22222212#33333333#44444444', '#',-2,2)+1),'#') from dual;我如何得到倒数第二个#后的值,也就是33333333
查看(629)
评论(14)
-
2008-04-03 13:54:14 / Oracle开发
create or replace procedure billupdate(billId in varchar2)isbillcount %count;beginselect count(*) into billcount from bill a where a.billId = billid;if billcount is not null thenUpdate billset status= '1',where billid = billid;commit;end if;if billcount is nullthenInsert into bill(billid,status)values('面单编号','1');commit;end if;In
查看(722)
评论(13)
-
2008-04-02 10:08:32 / Oracle开发
求大家推荐本书关于性能调优,备份恢复的?有什么好书,大家推荐下下啊?
查看(554)
评论(11)
-
2008-03-27 11:32:05 / Oracle开发
MERGE INTO nodeshopping nUSING (select * from nodeshopping where PRODUCTID = 'P004') bON (b.PRODUCTID = 'P004')WHEN MATCHED THENUPDATE SET n.productnumber = '999999' where n.productid='P004'WHEN NOT MATCHED THENINSERT (productId, productnumber) VALUES ('P004', '100');表中存在记录就更新这个记录,如果不存在就插入记录为什么会不成功呢当select * from nodeshopping where PRODUCTID = 'P004' 找不到记录的时候,应该是NOT MATCHED ,然后应该insert的把?为什么不这样执行呢?
查看(602)
评论(16)
-
2008-03-24 10:59:08 / Oracle开发
create tablehjdhjd(col1 varchar2(100) for bit data not null)for bit data not null???什么意思啊?
查看(340)
评论(5)
-
2008-03-21 15:26:12 / Oracle开发
百分比在oracle 用什么存储最好?
查看(258)
评论(3)
-
2008-03-20 12:24:52 / Java web开发及框架技术
如何得到oracle存储过程返回值问题???返回值:nodeIdcreate or replace procedure textpro(provs in varchar2,citys in varchar2,addresses in varchar2)isbool varchar2(20);nodeId varchar2(20);cursor numcur isselect keyCode,receiverNodeId from Tborderaddrmap a where a.prov = provs and a.city = citys and a.mapKey ='K';beginfor rec in numcur loopselect instr(addresses,rec.keyCode) into bool from dual;if (to_number(bool) > 0) the
查看(583)
评论(4)
-
2008-03-20 12:24:28 / Oracle开发
返回值:nodeIdcreate or replace procedure textpro(provs in varchar2,citys in varchar2,addresses in varchar2)isbool varchar2(20);nodeId varchar2(20);cursor numcur isselect keyCode,receiverNodeId from Tborderaddrmap a where a.prov = provs and a.city = citys and a.mapKey ='K';beginfor rec in numcur loopselect instr(addresses,rec.keyCode) into bool from dual;if (to_number(bool) > 0) thennodeId := rec.receiverNode
查看(562)
评论(4)