17,377
社区成员
发帖
与我相关
我的任务
分享
vHead CHAR(1);
省略......一段
BEGIN
DELETE CSZ_ChuShengZMX
WHERE SheZhiBH = SheZhiBH_IN
AND ShiYongBZ = 0;
UPDATE CSZ_ChuShengZ
SET KaiShiBM = KaiShiBM_IN,
JieShuBM = JieShuBM_IN,
ShiYongJG = vShiYongJG,
ShiYongYH = ShiYongYH_IN,
ShiYongYHMC = ShiYongYHMC_IN,
SheZhiRQ = SheZhiRQ_IN,
SheZhiYH = SheZhiYH_IN
WHERE SheZhiBH = SheZhiBH_IN;
INSERT INTO CSZ_ChuShengZMX
(ChuShengZBH, SheZhiBH, ShiYongYH, ShiYongJG)
SELECT vHead || TO_CHAR(BianHao),
SheZhiBH_IN,
ShiYongYH_IN,
vShiYongJG
FROM CSZ_BH
WHERE BianHao between vKaiShiBH and vJieShuBH
MINUS
SELECT ChuShengZBH, SheZhiBH_IN, ShiYongYH_IN, vShiYongJG
FROM CSZ_ChuShengZMX
WHERE SheZhiBH = SheZhiBH_IN;
COMMIT;
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
DATABUFFER_OUT := '调用信息失败!' || TO_CHAR(SQLCODE) || ':' || SQLERRM;
APPCODE_OUT := -1;
RETURN;
END;
select ' 你是' || '太阳' as 列名 from dual;
-- 执行一下,就可以看到效果了
SELECT vHead || TO_CHAR(BianHao),vHead , TO_CHAR(BianHao),
FROM CSZ_BH