I just had cause to write the following, because it fit into the framework slightly better than the procedural equivalent would have. It's code to clear out a hash table on a weekly basis to provide a delta export:
DELETE FROM ps_um_accom_std_hsWHERE to_char(sysdate, 'DAY') = rpad('SATURDAY', 9);
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---