寻宝走进玉林,精武世界官网,一诺倾情国语版全集
create or replace trigger scott_trigger before ddl on schema begin raise_application_error(-20008,'禁止scott用户的所有ddl操作'); end;
create sequence myseq;
create or replace trigger emp_trigger before update or delete or insert on emp begin if to_char(sysdate,'day') in ('星期四','星期五') then raise_application_error(-20008,'不允许在周四周五修改emp表'); end if; end;
update emp set sal=800;
create table emp_new as select * from emp;
create table emp_audit(name varchar2(10),delete_time date);
create or replace trigger delete_trigger after delete on emp_new for each row begin insert into emp_audit values(:old.ename,sysdate); end;
delete from emp_new where empno='7499';
select * from emp_audit;
create table emp_new as select * from emp;
create or replace trigger emp_trigger before update of sal on emp_new for each row when (new.sal<old.sal or new.sal>1.5*old.sal) begin raise_application_error(-20008,'工资只增不降,且涨幅不可大于50%'); end;
update emp_new set sal = 1.6*sal where empno='7788';
create table emp_new as select * from emp;
create table dept_new as select * from dept;
create or replace trigger cascade_trigger after update of deptno on dept_new for each row begin update emp_new set deptno=:new.deptno where deptno=:old.deptno; end;
update dept_new set deptno=15 where deptno=20;
select * from dept_new;
select * from emp_new;
create view emp_view (ename,empno) as select ename,empno from emp where deptno=20 with check option;
create table emp_new as select * from emp; create table dept_new as select * from dept;
create view emp_dept as select d.deptno,d.dname,e.empno,e.ename from dept_new d,emp_new e where d.deptno=e.deptno;
grant create view to scott;
create or replace trigger insteadof_trigger instead of insert on emp_dept for each row declare v_temp int; begin select count(*) into v_temp from dept_new where deptno=:new.deptno; if v_temp=0 then insert into dept_new(deptno,dname) values(:new.deptno,:new.dname); end if; select count(*) into v_temp from emp_new where empno=:new.empno; if v_temp=0 then insert into emp_new(deptno,empno,ename) values(:new.deptno,:new.empno,:new.ename); end if; end;
insert into emp_dept values(15,'humanresource',7999,'leaf');
select * from emp_new;
select * from dept_new;
create table event_table(event varchar2(50),event_time date);
create or replace trigger event_trigger after startup on database begin insert into event_table values(ora_sysevent,sysdate); end;
select * from event_table;
create table object_log( logid number constraint pk_logid primary key, operatedate date not null, objecttype varchar2(50) not null, objectowner varchar2(50) not null );
create sequence obj_log_seq;
create or replace trigger object_trigger after create or drop or alter on database begin insert into object_log values(obj_log_seq.nextval,sysdate,ora_dict_obj_type,ora_dict_obj_owner); end;
create sequence my_seq;
select * from object_log;
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复
Oracle字符串函数length、upper、lower、initcap、 concat、instr、replace
网友评论