oracle 創建遞增觸發器代码,PLSQL代码库,德仔网

代码语言
代码分类
【PLSQL】 oracle 創建遞增觸發器
作者:Dezai.CN / 发布于2011/7/7/ 652
<div><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)">1.創建表</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,0,255)">create</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">table</span><span style="color: rgb(0,0,0)"> tb_users
(
id </span><span style="color: rgb(0,0,255)">number</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(128,0,0); font-weight: bold">4</span><span style="color: rgb(0,0,0)">),
userName </span><span style="color: rgb(0,0,255)">varchar2</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(128,0,0); font-weight: bold">20</span><span style="color: rgb(0,0,0)">),
password </span><span style="color: rgb(0,0,255)">varchar2</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(128,0,0); font-weight: bold">20</span><span style="color: rgb(0,0,0)">)
)
</span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)">2.創建序列</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,0,255)">create</span><span style="color: rgb(0,0,0)"> sequence sq_user
start </span><span style="color: rgb(0,0,255)">with</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(0,0,0)">
increment </span><span style="color: rgb(0,0,255)">by</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)">3.創建觸發器 </span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,0,255)">create</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">or</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,255)">replace</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">trigger</span><span style="color: rgb(0,0,0)"> tri_tb_users 
before </span><span style="color: rgb(0,0,255)">insert</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">on</span><span style="color: rgb(0,0,0)"> tb_users 
</span><span style="color: rgb(0,0,255)">for</span><span style="color: rgb(0,0,0)"> each row 
</span><span style="color: rgb(0,0,255)">begin</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(0,0,255)">select</span><span style="color: rgb(0,0,0)"> sq_user.nextval </span><span style="color: rgb(0,0,255)">into</span><span style="color: rgb(0,0,0)"> :new.id </span><span style="color: rgb(0,0,255)">from</span><span style="color: rgb(0,0,0)"> dual; 
</span><span style="color: rgb(0,0,255)">end</span><span style="color: rgb(0,0,0)"> ; 
</span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)">4.添加數據</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,0,255)">begin</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">insert</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">into</span><span style="color: rgb(0,0,0)"> tb_users(username,password) </span><span style="color: rgb(0,0,255)">values</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">xiachufeng</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">xiachufeng</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">);
</span><span style="color: rgb(0,0,255)">insert</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">into</span><span style="color: rgb(0,0,0)"> tb_users(username,password) </span><span style="color: rgb(0,0,255)">values</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">Kevin</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">Kevin</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">);
</span><span style="color: rgb(0,0,255)">commit</span><span style="color: rgb(0,0,0)">;
</span><span style="color: rgb(0,0,255)">end</span><span style="color: rgb(0,0,0)">;
</span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)">5.查詢數據 發現id列是遞增的</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,0,255)">select</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">from</span><span style="color: rgb(0,0,0)"> tb_users
</span></div>
试试其它关键字
　遞增觸發器　
同语言下
可能有用的
Dezai.CN贡献的其它代码(4037)