摘要：触发器语法： 1 CREATE OR REPLACE TRIGGER trigger_name 2 {BEFORE | AFTER } 3 {INSERT | DELETE | UPDATE [OF column [, column …]]} --可跟update具体列 4 ON [schema.] 阅读全文

摘要：1. 统计每年入职的员工人数 1 set SERVEROUTPUT ON; 2 declare 3 cursor cemp is select to_char(hiredate,'yyyy') from emp; 4 phiredate VARCHAR2(4); 5 count80 number:= 阅读全文

摘要：1. 异常一：NO_DATA_FOUND 1 declare 2 pename emp.ename%TYPE; 3 begin 4 select ename into pename from emp where empno=1234; 5 exception 6 when no_data_found 阅读全文

摘要：1 --查询并打印员工的姓名和薪水 2 declare 3 --定义一个光标 4 cursor cemp is select ename,sal from emp; 5 --为光标定义对应的变量 6 pename emp.ename%type; 7 psal emp.sal%TYPE; 8 begi 阅读全文