kongkong的专栏

  可以使用AutoCommit方法解决。例如： CREATE OR REPLACE TRIGGER TRIGGER_NAME [BEFORE|AFTER] ACTION ON TABLE_NAME FOR EACH ROW DECLARE PRAGMA AUTONOMOUS_TRANSACTION BEGIN ...... COMMIT; END;     触发无法包含COMMIT语句...

----- 添加20条数据--------------------------------------------------------------------------- -- for declare       V_START NUMBER := 1; begin    FOR V_START IN 1..20 LOOP        INSERT INTO BONUS VALUES('K...

1. rownum oracle前10条select * from accounts t where rownum<11   分页 取 10 到20条 :select * from (select t.*,rownum r from accounts t) a  where  a.r>=10   and   a.r<=20;   分页: select * from (sele...