SELECT '999-9-999-999' , TRIM(TO_CHAR(MAX(TO_NUMBER(SUB_NO))+1,'00')) , SELECT DECODE(COUNT(*),0,'','1') FROM BANK_MT WHERE GINKO_CD = 1 ,1 FROM SHIYOSYA WHERE SUISEN_ID = '999-9-999-999' 想将SELECT DECODE(COUNT(*),0,'','1') FROM BANK_MT WHERE GINKO_CD = 1的?果插入到表SHIYOSYA中但是??,不知是何原因
竟然说我的帖子有伤害的言论。INSERT语句发不出去,在SELECT '999-9-999-999' 的前面就是INSERT语句,关键是错在 SELECT DECODE(COUNT(*),0,'','1') FROM BANK_MT WHERE GINKO_CD = 1上,不知为何
>>SELECT DECODE(COUNT(*),0,'','1') FROM BANK_MT WHERE GINKO_CD = 1这句的目的是什么?这样写肯定不是你要的 COUNT 值
FROM SHIYOSYA WHERE SUISEN_ID = '999-9-999-999'
想将SELECT DECODE(COUNT(*),0,'','1') FROM BANK_MT WHERE GINKO_CD = 1的?果插入到表SHIYOSYA中但是??,不知是何原因
SELECT DECODE(COUNT(*),0,'','1') FROM BANK_MT WHERE GINKO_CD = 1上,不知为何
HAVING
....