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