Author Archives

Install latest patch of APEX 4.2 (4.2.5)

A few days ago Oracle brought out a new patch for APEX 4.2, this will be the latest version of this build, the next version of APEX will be 5.0.If you already have APEX 4.2.x installed you can download a patch from support.oracle.com, the patch number …

SQL: Start day and End day of week

I just got an interesting question: how do you know for a date, in which week (Monday – Sunday) it falls.I created a little test script to get 31 days of data:(date_c is the same as date_d, but in a more readable output. c stands for char, d for date)s…