1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 INSERT DECLARE v_empno emp.empno%TYPE := &empno; v_ename emp.ename%TYPE := ‘&ename’; v_salary emp.sal%TYPE := &sal; BEGIN INSERT INTO emp(empno,ename,sal) VALUES(v_empno,v_ename,v_salary); COMMIT; END; UPDATE DECLARE v_empno emp.empno%TYPE; v_salary emp.sal%TYPE :=&sal; BEGIN UPDATE emp SET sal=v_salary where empno=1234; COMMIT; END; DELETE DECLARE v_empno emp.empno%TYPE :=&eno; BEGIN DELETE emp WHERE empno=v_empno; COMMIT; END
在PL/SQL中& 表示彈出框提示你輸入值