国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁(yè) > 數(shù)據(jù)庫(kù) > Oracle > 正文

Oracle生成單據(jù)編號(hào)存儲(chǔ)過(guò)程的實(shí)例代碼

2024-08-29 14:00:03
字體:
來(lái)源:轉(zhuǎn)載
供稿:網(wǎng)友

Oracle生成單據(jù)編號(hào)存儲(chǔ)過(guò)程,在做訂單類似的系統(tǒng)都可能會(huì)存在訂單編號(hào)不重復(fù),或是流水號(hào)按日,按年,按月進(jìn)行重新編號(hào)。

可以參考以下存儲(chǔ)過(guò)程

CREATE OR REPLACEprocedure Pro_GetBillNO(TypeTable in varchar2,cur_mycursor out sys_refcursor)asDReceiptCode varchar2(40);DReceiptName varchar2(50);DPrefix1 varchar2(50);DISO varchar2(50);DIsAutoCreate varchar2(20);DPrefix2 varchar2(20);DPrefix3 varchar2(20);DDateValue date;DNO number;DLength number;DResetType number;DSeparator varchar2(20);DReturnValue varchar2(50);strSql varchar2(1000);beginDReturnValue:='';select "ReceiptCode","ReceiptName","Prefix1","ISO","IsAutoCreate","Prefix2","Prefix3","DateValue","NO","Length","ResetType","Separator" intoDReceiptCode,DReceiptName,DPrefix1,DISO,DIsAutoCreate,DPrefix2,DPrefix3,DDateValue,DNO,DLength,DResetType,DSeparator from"SysReceiptConfig" where "ReceiptCode"=TypeTable;if to_number(DResetType)>0thenif DIsAutoCreate=1 THENif DResetType=1 then --按年份if to_number(to_char(sysdate,'yyyy')) <>to_number(to_char(DDateValue,'yyyy')) thenupdate "SysReceiptConfig" set "NO"=1,"DateValue"=to_date(sysdate) where "ReceiptCode"=TypeTable;elseupdate "SysReceiptConfig" set "NO"="NO"+1 where "ReceiptCode"=TypeTable;end if; --年份end if;--DResetType=1if DResetType=2 then --按月份if to_number(to_char(sysdate,'MM')) <>to_number(to_char(DDateValue,'MM')) thenupdate "SysReceiptConfig" set "NO"=1,"DateValue"=to_date(sysdate) where "ReceiptCode"=TypeTable;elseupdate "SysReceiptConfig" set "NO"="NO"+1 where "ReceiptCode"=TypeTable;end if; --月份end if;--DResetType=2if DResetType=3 then --按日if to_number(to_char(sysdate,'dd')) <>to_number(to_char(DDateValue,'dd')) thenupdate "SysReceiptConfig" set "NO"=1,"DateValue"=to_date(sysdate) where "ReceiptCode"=TypeTable;elseupdate "SysReceiptConfig" set "NO"="NO"+1 where "ReceiptCode"=TypeTable;end if; --月份end if;--DResetType=3elseupdate "SysReceiptConfig" set "NO"="NO"+1 where "ReceiptCode"=TypeTable;end if;--DResetTypeend if;strSql:=' select * from "SysReceiptConfig" where 1=1 ';strSql:=strSql ||' and "ReceiptCode"='''||TypeTable||'''';open cur_mycursor for strSql;end;

以上所述是小編給大家介紹的Oracle生成單據(jù)編號(hào)存儲(chǔ)過(guò)程的實(shí)例代碼,希望對(duì)大家有所幫助,如果大家有任何疑問(wèn)請(qǐng)給我留言,小編會(huì)及時(shí)回復(fù)大家的。在此也非常感謝大家對(duì)VeVb武林網(wǎng)網(wǎng)站的支持!


注:相關(guān)教程知識(shí)閱讀請(qǐng)移步到oracle教程頻道。
發(fā)表評(píng)論 共有條評(píng)論
用戶名: 密碼:
驗(yàn)證碼: 匿名發(fā)表
主站蜘蛛池模板: 高邮市| 基隆市| 克什克腾旗| 玉林市| 化德县| 九寨沟县| 邵阳县| 九龙县| 灌云县| 虞城县| 留坝县| 甘泉县| 外汇| 南阳市| 石棉县| 昌都县| 定边县| 新龙县| 炎陵县| 东乡县| 阜平县| 鹿泉市| 日喀则市| 南康市| 张家港市| 收藏| 山东| 甘孜| 邛崃市| 专栏| 翼城县| 察隅县| 广汉市| 伊川县| 松阳县| 西盟| 河南省| 岳阳市| 三穗县| 鹤庆县| 灵寿县|