--异常
declare
v_ename varchar2(50);
begin
select ename into v_ename from emp;
exception
when too_many_row then
v_name='too_many_row exception';
end;
--自定义异常
declare
v_excep exception;
begin
update set ename='tina' where empno=10000;
if sql%notfound then --如果没有更新数据
raise v_excep --throw exception
end if;
exception
when v_excep then
dbms_output.put_line('.............');
end;
--trigger
create table temps (id number(5),desc varchar2(200));
--simple
create or replace trigger t_emp
before insert or update of ename --在插入和更新ename字段的时候触发触发器
on emp --数据对象
for each row --行级触发器 在一次操作表的语句中,每操作成功一行就会触发一次;
--不写的话,表示是表级触发器,则无论操作多少行,都只触发一次
begin
insert into temps vlaus(:old.empno,:old.ename);
end;
--when()
create or replace trigger t_emp
before insert or update of ename
on emp
for each row
when(old.empno<>0001) --满足该条件才会执行触发器
begin
insert into temps vlaus(:old.empno,:old.ename);
end;
--INSERTING,UPDATING
create or replace trigger t_emp
before insert or update of ename
on emp
for each row
when(old.empno<>0001)
begin
if INSERTING then --根据当前操作分别作处理 (插入操作)
insert into temps vlaus(:old.empno,:old.ename);
elsif UPDATING then (修改操作)
update temps set desc =:new.ename where id=:old.empno;
end if;
end;
分享到:
相关推荐
sudo alien -i /home/ubuntu/oracle-instantclient-basic-21.1.0.0.0-1.x86_64.rpm sudo alien -i /home/ubuntu/oracle-instantclient-devel-21.1.0.0.0-1.x86_64.rpm sudo alien -i /home/ubuntu/oracle-instant...
dm8-oracle-jdbc16-wrapper.jar
Oracle Database 21c 是最新的版本;...oracle-database-ee-21c-1.0-1.ol8文件分割成 三个 压缩包,必须集齐 三个 文件后才能一起解压一起使用: Oracle Database 21c (oracle-database-ee-21c-1.0-1.ol8.part3.rar) ...
oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm oracle-instantclient11.2-basiclite-11.2.0.4.0-1.x86_64.rpm oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm oracle-instantclient11.2-jdbc-...
oracle-instantclient-basic-21.6.0.0.0-1.x86_64.rpm oracle-instantclient-basic-21.6.0.0.0-1.x86_64.zip oracle-instantclient-devel-21.6.0.0.0-1.x86_64.rpm oracle-instantclient-sqlplus-21.6.0.0.0-1.x86_...
REDHAT安装ASM时必须安装的包。一共有三个,分别是 oracleasm-support-2.1.7-1.el5.i386.rpm oracleasm-2.6.18-164.el5-2.0.5-1.el5.i686.rpm oracleasmlib-2.0.4-1.el5.i386.rpm
(完整)Oracle复习题总结-推荐文档.pdf
oracleasm-support-2.1.4-1.el5.x86_64.rpm 适用于内核为2.6.18-164.el5环境使用
kmod-oracleasm-2.0.8-15.el6_9.x86_64 oracleasm-support-2.1.8-1.el6.x86_64 oracleasmlib-2.0.4-1.el6.x86_64 安装顺序: rpm -ivh kmod-oracleasm-2.0.8-15.el6_9.x86_64.rpm rpm -ivh oracleasm-support-2.1.8...
compat-oracle-rhel4-1.0-5.i386.rpm
kmod-oracleasm-2.0.8-16.el6_10.x86_64.rpm
Oracle数据库体系结构-学习笔记,经过整理梳理让你比较清楚的学习整个Oracle体系
oracleasm-2.6.18-194.el5xen-2.0.5-1.el5.x86_64.rpm
oracleasm-support-2.1.7-1.el5.x86_64.rpm
oracle-instantclient-basic-11.1.0.1-1.x86_64.rpm
oracleasm-support-2.1.8-1.el6.x86_64.rpm
oracleasm-support-2.1.8-1.SLE11.x86_64.rpm oracleasm-support-2.1.8-1.SLE11.x86_64.rpm
09-10-2 第03讲补充 Oracle体系结构--SGAx.pptx
oracleasm-2.6.18-194.32.1.el5-2.0.5-1.el5.x86_64.rpm
安装Oracle专用Linux操作系统 安装过程中,可以省去很多不必要的坑 OracleLinux-R6-U5-Server-x86_64-dvd.[V41362-01].iso