1.The Insert Row trigger has the following syntax.
CREATE OR REPLACE TRIGGER trigger_name
AFTER|BEFORE INSERT ON table_name
FOR EACH ROW
[WHEN (Boolean expression)]
DECLARE
Local declarations
BEGIN
Trigger Body written PL/SQL
END;
2.TYPE IS TABLE OF
如果想使用PL/SQL表中的具體一列,再加上:
TYPE cg$table_type IS TABLE OF I_FIELD_MAPPED_COLUMN%ROWTYPE
INDEX BY BINARY_INTEGER;
cg$table cg$table_type;
--cg$I_FIELD_MAPPED_COLUMN包名
idx BINARY_INTEGER := 1;
cg$I_FIELD_MAPPED_COLUMN.cg$table(cg$I_FIELD_MAPPED_COLUMN.idx).FIELD_MAPPED_COLUMN_ID
:= cg$rec.FIELD_MAPPED_COLUMN_ID;
posted on 2008-05-19 18:08
譚明 閱讀(222)
評論(0) 編輯 收藏 所屬分類:
Oracle