oracle数据库例外处理与视图

declare
--定义
v_ename emp.ename%type;
begin
--
select ename into v_ename from emp where empno = &gno;
dbms.output.put_line(‘名字：‘||v_ename);
exception
when no_data_found then
dbms_output.put_line(‘编号没有!‘)；
end;

create or replace procedure ex_test(spNo number)
is
--定义例外
myexcep exception;
begin
--更新
update emp set sal = sal + 1000 where empno = spNo;

--sql%notfound这是表示没有update
--raise myexcep 触发myexcep

if sql%notfound then 
raise myexcep;
end if;
exception
when myexcep then
dbms_output.put_line(‘没有update‘)；

end;

创建视图
create view myview as select * from emp where sal<1000;
使用视图
select * from myview;
利用视图简化操作
create view myview2 as select emp.deptno,emp.name,dept.deptno from emp,dept where emp.deptno = 
dept.deptno;
select * from myview2;