摘要:
http://www.cnblogs.com/luxh/archive/2012/08/16/2640411.html存储过程基本语法CREATE OR REPLACE PROCEDURE <procedure_name> [(<parameters>)] IS [declare section] BEGIN [<statement(s)>][EXCEPTION <exception handler(s);]END [<procedure_name>]; <>表示必须有,[]表示可选。简单的例子1、直接往表里插入一条记录 1)建 阅读全文
摘要:
oracle触发器模板:oracle触发器用于操作过一个表要对另一个表产生影响,这是可以用触发器;Create Or Replace Trigger huiTrig After Insert Or Delete Or Update On dept For Each RowBegin If Inserting Then Insert Into emp Values (999,'insert', 0); Elsif Updating Then Insert Into emp Values (999,'update', 0); Elsif Deleting Then 阅读全文