SELECT MAX(TO_NUMBER(SUBSTR(WAREHOUSNO, 7))) + 1 FROM WZ_WAREHOUS
WHERE EXTRACT(YEAR FROM 2007-6-11 16:29:51) =
(SELECT EXTRACT(YEAR FROM TO_DATE('2007-6-11 16:29:51','YYYY-MM-DD HH24:MI:SS')) FROM DUAL)总是报缺少右括号错误,本人对ORACLE又不是很熟悉,找不到什么地方有错误,麻烦各位帮忙看看哪里有错误了。谢谢~
WHERE EXTRACT(YEAR FROM 2007-6-11 16:29:51) =
(SELECT EXTRACT(YEAR FROM TO_DATE('2007-6-11 16:29:51','YYYY-MM-DD HH24:MI:SS')) FROM DUAL)总是报缺少右括号错误,本人对ORACLE又不是很熟悉,找不到什么地方有错误,麻烦各位帮忙看看哪里有错误了。谢谢~
FROM WZ_WAREHOUS
WHERE EXTRACT(YEAR FROM date '2007-6-11 16:29:51') =(SELECT EXTRACT(YEAR FROM date '2007-6-11 16:29:51')) FROM DUAL)
WHERE EXTRACT(YEAR FROM TO_DATE('2007-6-11 16:29:51','YYYY-MM-DD HH24:MI:SS')) =
(SELECT EXTRACT(YEAR FROM TO_DATE('2007-6-11 16:29:51','YYYY-MM-DD HH24:MI:SS')) FROM DUAL)你手工从新按照这个输入一遍