Oracle数据库系统应用开发实用教程电子课件 第7章 PLSQL编程基础.pptVIP

* * * * * * * * declare v_name VARCHAR2(50) :=linping; v_date DATE :=06-4月-10; v_id NUMBER:=10; begin if(v_id 10) then dbms_output.put_line(v_id 10); ELSIF (v_id 15) then dbms_output.put_line(v_id 15); else dbms_output.put_line(v_id = 10); end if; exception when others then dbms_output.put_line(error); end; DECLARE v_deptno emp.deptno%type; v_empno emp.empno%type; v_sal number(6,2); BEGIN v_empno:= no; SELECT deptno,sal INTO v_deptno,v_sal FROM emp WHERE empno= v_empno; IF v_deptno =10 THEN UPDATE emp SET sal=v_sal+100 WHERE empno= v_empno;