altertable t
addconstraint pk_id primarykey(object_id);
更改列名和属性
//更改列名
altertable tablename remane column a to b;
//更改属性
altertable records modify(a timestamp);
//增加一列
altertable records add(a numeric(8));
简单触发器
createor replace TRIGGER pointchange
AFTER INSERT ON records
FOREACH ROW
DECLARE
tag NUMERIC(6);
BEGINSELECT COUNT(cno) INTO tag FROM MEM_CARD WHERE cno = :new.cno;
if (tag > 0) THEN
UPDATE mem_card
SET point = point + :new.cchange
WHERE cno = :new.cno;
else
RAISE_APPLICATION_ERROR(-20001,'没有该会员');
endif;
END;