pl/sql 中操作DML語句

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中& 表示彈出框提示你輸入值