2、lename .但是第二种方式会在某些情况下导致原表无法使用,具体的还没弄清楚呢。(4) 至于sql语句表现不同应该就是oracle与db2各自的语法了。比如说oracle的rownum,db2可以使用fetch first n only,或row_number() over()等。DB2有更好的扩展性和性能。Oracle触发器无法支持并行 oracle 触发器例子: CREATE OR REPLACE TRIGGER CRM.T_SUB_USERINFO_AUR_NAME AFTER UPDATE OF STAFF
3、_NAME ON CRM.T_SUB_USERINFO REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW declare begin if :NEW.STAFF_NAME!=:OLD.STAFF_NAME then begin 客户投诉 update T_COMPLAINT_MANAGE set SERVE_NAME=:NEW.STAFF_NAME where SERVE_SEED=:OLD.SEED; oracle 存储过程例子:create or replace
4、 PROCEDURE p_insert_t (v_x in NUMBER) IS temp_id number; BEGIN FOR i IN 1..v_x LOOP select SEQ_B_USER_ID.nextval into temp_id from dual; insert into buser (id, username, nickname, status, createdtime) values(temp_id, to_char(temp_id), to_char(temp_id), 0, s