ASs_type varchar2(40);
s_start date;
s_end date;
BEGIN ----
SELECT MAX(ID*1) INTO s_type FROM S_IN_RECORD;
----
SELECT TO_DATE(STARTTIME,'YYYY-MM-DD HH24:MI:SS') INTO s_start FROM S_IN_RECORD WHERE ID=s_type;
--盘点结束,插入结束时间--
UPDATE S_IN_RECORD SET ENDTIME=(SELECT TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss') as A FROM dual) WHERE ID=s_type;
----
SELECT TO_DATE(ENDTIME,'YYYY-MM-DD HH24:MI:SS') INTO s_end FROM S_IN_RECORD WHERE ID=s_type; insert into S_IN_DETAIL(ID,KBH,STATE,TYPE)
--盘亏--
SELECT (S_SQU_IN_DETAIL.NEXTVAL) AS ID,KBH,'4',s_type FROM
(SELECT KBH FROM S_IN_START A WHERE A.TYPE=s_type AND NOT EXISTS (SELECT KBH FROM S_IN_SCANSTOCK B WHERE A.KBH=B.KBH))
;
--以的代码只能从1插到9,10及10以后的数字插不进去是怎么回事?--
--删除扫描记录表数据--
DELETE S_IN_SCANSTOCK;
END;
s_start date;
s_end date;
BEGIN ----
SELECT MAX(ID*1) INTO s_type FROM S_IN_RECORD;
----
SELECT TO_DATE(STARTTIME,'YYYY-MM-DD HH24:MI:SS') INTO s_start FROM S_IN_RECORD WHERE ID=s_type;
--盘点结束,插入结束时间--
UPDATE S_IN_RECORD SET ENDTIME=(SELECT TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss') as A FROM dual) WHERE ID=s_type;
----
SELECT TO_DATE(ENDTIME,'YYYY-MM-DD HH24:MI:SS') INTO s_end FROM S_IN_RECORD WHERE ID=s_type; insert into S_IN_DETAIL(ID,KBH,STATE,TYPE)
--盘亏--
SELECT (S_SQU_IN_DETAIL.NEXTVAL) AS ID,KBH,'4',s_type FROM
(SELECT KBH FROM S_IN_START A WHERE A.TYPE=s_type AND NOT EXISTS (SELECT KBH FROM S_IN_SCANSTOCK B WHERE A.KBH=B.KBH))
;
--以的代码只能从1插到9,10及10以后的数字插不进去是怎么回事?--
--删除扫描记录表数据--
DELETE S_IN_SCANSTOCK;
END;
解决方案 »
- sqlplus如何登录(网页形式)
- rman12004错误 ora-27001错误
- 关于日期转换的问题
- msvc++6开发CS架构 : 服务器端接收请求报文后,如何最大效率地进行oracle数据库中操作,例如insert,select,update等? oci?
- oracle日期的一个疑惑???
- 有关CLOB的问题?没用过,请高手指点下
- ORA-00947: 没有足够的值 存储过程问题
- Oracle 8i建数据库是不是要很长很长时间...........
- 两个菜鸟问题:加分
- 大伙帮忙看看这句sql语句,为什么不行啊(关于order by的)
- 求写oracle多个字符替换(有测试数据)
- 求助,安装oracle时出现的问题!
insert into S_IN_DETAIL(ID,KBH,STATE,TYPE)
--盘亏--
SELECT (S_SQU_IN_DETAIL.NEXTVAL) AS ID,KBH,'4',s_type FROM
(SELECT KBH FROM S_IN_START A WHERE A.TYPE=s_type AND NOT EXISTS (SELECT KBH FROM S_IN_SCANSTOCK B WHERE A.KBH=B.KBH)) 你取个s_type值来测试
执行下
SELECT (S_SQU_IN_DETAIL.NEXTVAL) AS ID,KBH,'4',s_type FROM
(SELECT KBH FROM S_IN_START A WHERE A.TYPE=s_type AND NOT EXISTS (SELECT KBH FROM S_IN_SCANSTOCK B WHERE A.KBH=B.KBH))
检查一下
如果是的话把它改大点,以前实习的时候做一个期货系统也是这个问题。
很好奇你现在做的是是不是我当年那个,呵呵
问题已经解决了,是程序里的代码问题原来是:MAX(ID) 改成MAX(TO_NUMBER(ID)) 就解决了
谢谢大家!