摘要： create or replace trigger trig1after insert on scott.testbegin dbms_output.put_line('添加成功...');end;create or replace trigger trig2after update on scott.testfor each row/*行触发,默认是表触发*/begin dbms_output.put_line('修改成功...');end;create or replace trigger trig3before delete on scott.testbe 阅读全文

摘要： create or replace view my_view as select ename,job,sal,comm from emp;create or replace view my_view as select ename,job,sal,comm from emp with read only;create or replace view my_view as select emp.ename,dept.deptno,dept.dname from emp,dept where emp.deptno=dept.deptno with read only;drop view my_vi 阅读全文

摘要： create or replace procedure my_pro5(v_deptno number) istype my_cursor is ref cursor;v_cursor my_cursor;v_ename emp.ename%type;v_sal emp.sal%type;begin open v_cursor for select ename,sal from emp where deptno=v_deptno; loop fetch v_cursor into v_ename,v_sal;/***游标向下移动***/ exit when v_cursor%notfound; 阅读全文