Tuesday, June 6, 2017
Dynamic Like Searches in Oracle
https://stackoverflow.com/questions/4612282/dynamic-like-statement-in-sql - Works great in Oracle 11.2.x - join "on column like ...".
Tuesday, March 14, 2017
Shifting of Oracle DBMS Job ScheduleTime
A daily job was scheduled to execute on top of the hour, but by the end of the week, was starting 6 seconds later. Leaving it for a few more weeks, it was by a minute.
Found out it was because of the interval value set as 'SYSDATE+1', making it go slower and slower as the job started later by a few seconds everyday. Adjusting the interval was able to fix it.
- Moving the hour part outside of day calculation:
- Truncating up to the minute to lose seconds:
Found out it was because of the interval value set as 'SYSDATE+1', making it go slower and slower as the job started later by a few seconds everyday. Adjusting the interval was able to fix it.
- Moving the hour part outside of day calculation:
- Truncating up to the minute to lose seconds:
Subscribe to:
Posts (Atom)