Advertisement
blacklight

Untitled

Nov 14th, 2011
133
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. EXECUTE IMMEDIATE '
  2.  INSERT INTO DMN_SYS_C_AUDIT_BACKUP
  3.  SELECT *
  4.  FROM DMN_SYS_C_PLATFORM_AUDIT
  5.  WHERE DMN_LASTUPD < TRUNC(SYSDATE) - INTERVAL :x DAY
  6. ' USING keep_last_days;
  7.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement