Oracle笔记 十一、PL/SQL函数和触发器

<div id="codeSnippetWrapper"> <div style="border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; border-right-style: none; background-color: #f4f4f4; padding-left: 0px; width: 100%; padding-right: 0px; font-family: 'Courier New',courier,monospace; direction: ltr; border-top-style: none; color: black; font-size: 10pt; border-left-style: none; overflow: visible; padding-top: 0px" id="codeSnippet">
<pre style="border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; border-right-style: none; background-color: white; margin: 0em; padding-left: 0px; width: 100%; padding-right: 0px; font-family: 'Courier New',monospace; direction: ltr; border-top-style: none; color: black; font-size: 10pt; border-left-style: none; overflow: visible; padding-top: 0px">--创建函数

  replace  add_sal(sSal number)

 number

 (sSal > 5000) 

 sSal + 51;

 3000) 

 sSal + 111;

 sSal + 222;

 ;

;

 sal,add_sal(sal)  emp;
  deptLog(
 varchar2(20),

   可以触发多条，当你的语言影响多少条记录就会触发多少次
  replace  trig_dept2
 insert      dept2
 inserting 
 deptLog (,,sysdate);

,monospace; direction: ltr; border-top-style: none; color: black; font-size: 10pt; border-left-style: none; overflow: visible; padding-top: 0px">  elsif deleting 
,monospace; direction: ltr; border-top-style: none; color: black; font-size: 10pt; border-left-style: none; overflow: visible; padding-top: 0px">   ; 
 *  dept2;
 *  deptLog;
 dept2 (55,,);
 dept2  loc =   deptno (30);
 dept2  deptno = 55;
  replace  trig_emp
   dept   

 emp  emp.deptno =: .deptno  emp.deptno = :.deptno;
;
 dept  deptno = 11      deptno = 10;
 *  emp;
  replace  trg_ins_dept2
 insert
 dept2
   ()       
);
 ;
  tgr_Name disable | enable;
  tableName disable   | enable  ;
                        
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!