oracle8.1.6 update clickthrough_log set click_count = click_count + :cached_click_count where local_url = :cached_local_url and foreign_url = :cached_foreign_url and package_id = :cached_package_id and trunc(entry_date) = trunc(sysdate)