我的论坛主题

• 怎么自增SID好啊，我现在是这样的

  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)

• 怎么自增SID好啊，我现在是这样的

  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)

• ORA-01403: 未找到数据

  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)

• MERGE INTO 问题

  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)

• 百分比在oracle 用什么存储最好?

  2008-03-21 15:26:12   /   Oracle开发

  百分比在oracle 用什么存储最好?

  查看(258) 评论(3)

• 如何得到oracle存储过程返回值问题???

  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)

• 如何得到oracle存储过程返回值问题???

  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)