upgrade-02-021-to-02-022.sql 453 B

1234567891011121314
  1. -- Licensed Materials - Property of IBM
  2. -- BI and PM: Mobile
  3. -- (C) Copyright IBM Corp. 2007, 2012
  4. -- US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
  5. CREATE OR REPLACE TRIGGER TGR_MOB_RDS_SYNC_UP
  6. AFTER UPDATE OF RENDER_SIZE ON MOB_RENDERS
  7. REFERENCING NEW AS pre
  8. FOR EACH ROW
  9. BEGIN
  10. UPDATE MOB_USER_RENDER SET LAST_VIEWED = SYSDATE
  11. WHERE RENDER_ID = :pre.RENDER_ID;
  12. END;
  13. /