17,086
社区成员
发帖
与我相关
我的任务
分享pl/sql变量名和栏名一致的情况
PROCEDURE ANZ00 (
sist_cd VARCHAR2,
shonin_kbn VARCHAR2,
hnmk_cd VARCHAR2
)
...
UPDATE ANZ101T SET
SETSUMEI_KBN = TO_CHAR(TO_NUMBER(SETSUMEI_KBN) + 1),
SHONIN_KBN = shonin_kbn,
KSN_YMD = SYSDATE
WHERE SIST_CD = sist_cd AND HNMK_CD = hnmk_cd;
...
END ANZ00;
这是是应该用'||xxx||'
还是''||xxx||''
编译都通过的
谢谢
sist_cd VARCHAR2,
shonin_kbn VARCHAR2,
hnmk_cd VARCHAR2
)
...
UPDATE ANZ101T SET
SETSUMEI_KBN = TO_CHAR(TO_NUMBER(SETSUMEI_KBN) + 1),
SHONIN_KBN = shonin_kbn,
KSN_YMD = SYSDATE
WHERE SIST_CD = sist_cd AND HNMK_CD = hnmk_cd;
...
END ANZ00;
这是是应该用'||xxx||'
还是''||xxx||''
编译都通过的
谢谢
...全文
请发表友善的回复…
发表回复
adidasprince 2002-09-19
- 打赏
- 举报
jz
bobfang 2002-09-19
- 打赏
- 举报
UPDATE ANZ101T SET
SETSUMEI_KBN = TO_CHAR(TO_NUMBER(SETSUMEI_KBN) + 1),
SHONIN_KBN = ANZ00.shonin_kbn,
KSN_YMD = SYSDATE
WHERE SIST_CD = ANZ00.sist_cd AND HNMK_CD = ANZ00.hnmk_cd;
SETSUMEI_KBN = TO_CHAR(TO_NUMBER(SETSUMEI_KBN) + 1),
SHONIN_KBN = ANZ00.shonin_kbn,
KSN_YMD = SYSDATE
WHERE SIST_CD = ANZ00.sist_cd AND HNMK_CD = ANZ00.hnmk_cd;
jiezhi 2002-09-19
- 打赏
- 举报
是''||xxx||''
