CREATE OR REPLACE PROCEDURE USER_TEST_PROCEDURE(AGESS IN VARCHAR2,NAMES IN VARCHAR2)
AS
BEGIN
UPDATE USER_TEST SET USER_AGE = AGESS WHERE USER_NAME = NAMES;
DBMS_OUTPUT.PUT_LINE('修改的NAME是:' || NAMES);
END;
使用带参数的存储过程修改表
CREATE OR REPLACE PROCEDURE USER_TEST_PROCEDURE(AGESS IN VARCHAR2,NAMES IN VARCHAR2)
AS
BEGIN
UPDATE USER_TEST SET USER_AGE = AGESS WHERE USER_NAME = NAMES;
DBMS_OUTPUT.PUT_LINE('修改的NAME是:' || NAMES);
END;
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
