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