CREATE OR REPLACE PROCEDURE p_ra(v_eno IN emp.EMPNO%TYPE) AS
v_sal EMP.SAL%TYPE;
BEGIN
SELECT SAL INTO v_sal FROM emp WHERE empno = v_eno;
UPDATE EMP set SAL = v_sal + 100 WHERE EMPNO = v_eno;
dbms_output.put_line('漲薪前:'||v_sal||'漲薪后:'||(v_sal + 100));
END;
v_sal EMP.SAL%TYPE;
BEGIN
SELECT SAL INTO v_sal FROM emp WHERE empno = v_eno;
UPDATE EMP set SAL = v_sal + 100 WHERE EMPNO = v_eno;
dbms_output.put_line('漲薪前:'||v_sal||'漲薪后:'||(v_sal + 100));
END;
2023-10-24
SQL> desc dbms_output;
Element Type
--------- ---------
ENABLE PROCEDURE
DISABLE PROCEDURE
PUT PROCEDURE
PUT_LINE PROCEDURE
NEW_LINE PROCEDURE
GET_LINE PROCEDURE
CHARARR TYPE
GET_LINES PROCEDURE
我查看這個(gè)包怎顯示這個(gè)啊
Element Type
--------- ---------
ENABLE PROCEDURE
DISABLE PROCEDURE
PUT PROCEDURE
PUT_LINE PROCEDURE
NEW_LINE PROCEDURE
GET_LINE PROCEDURE
CHARARR TYPE
GET_LINES PROCEDURE
我查看這個(gè)包怎顯示這個(gè)啊
2021-05-12
ORA-24247: 網(wǎng)絡(luò)訪問被訪問控制列表 (ACL) 拒絕
這個(gè)問題要怎么解決,沒辦法調(diào)試呀
這個(gè)問題要怎么解決,沒辦法調(diào)試呀
2019-04-17
感謝老師的精彩教授,非常優(yōu)秀,10分好評(píng)!
2018-12-22