17,377
社区成员
发帖
与我相关
我的任务
分享请大家帮忙把这段SQL存储过程改成ORACLE的存储过程,谢谢
ALTER PROCEDURE update_KeyListSimple
(
@KeyID [int],
@KeyStorageID [int],
@KeyGenerateTime [datetime]
)
AS UPDATE [ECKMC].[dbo].[KeyList]
SET
[KeyStorageID] = @KeyStorageID,
[KeyGenerateTime] = @KeyGenerateTime
WHERE
( [KeyID] = @KeyID)
(
@KeyID [int],
@KeyStorageID [int],
@KeyGenerateTime [datetime]
)
AS UPDATE [ECKMC].[dbo].[KeyList]
SET
[KeyStorageID] = @KeyStorageID,
[KeyGenerateTime] = @KeyGenerateTime
WHERE
( [KeyID] = @KeyID)
...全文
请发表友善的回复…
发表回复
wvivw 2006-06-23
- 打赏
- 举报
Create or replace PROCEDURE update_KeyListSimple
(v_keyid integer,
v_keystorageid integer,
v_keygeneratetime date)
as
begin
Update ECKMC.KeyList
set KeyStorageID = v_KeyStorageID,
KeyGenerateTime = v_KeyGenerateTime
WHERE KeyID = v_KeyID;
end ;
(v_keyid integer,
v_keystorageid integer,
v_keygeneratetime date)
as
begin
Update ECKMC.KeyList
set KeyStorageID = v_KeyStorageID,
KeyGenerateTime = v_KeyGenerateTime
WHERE KeyID = v_KeyID;
end ;
shaun1981 2006-06-23
- 打赏
- 举报
马上结算
shaun1981 2006-06-23
- 打赏
- 举报
在线等.........help
