(Dimitri Gielis) When reviewing Oracle APEX applications I often see hardcoded date or timestamp formats.

(Harry Dragstra) Recently, while migrating AIX 11gR2 Databases to Oracle Linux 12cR1 on an ODA X5-2, our setup of Sequence Replication by Oracle Golden Gate appeared to be faulty. The target side sequences were not automatically incremented.

(Roel Hartman) We upgraded our environment from 11.2 to 12c last week. This week we noticed an error in one of our APEX pages, a rather simple form for entering data. Nothing fancy, nothing spectacular – only a spectacular error when you tried to edit a record.

(Ben Brumm) What’s the difference between UNION and UNION ALL in Oracle SQL? There are a few. Learn what they are in this article.

(mdinh) When using integrated extract, info command does not show Seqno, RBA, e.g. Seqno 3292, RBA 79236752.

(Jeff Smith) People seemed to like the Instance Viewer we built for version 4.1.

(Job Oprel) Let’s clear about this: Oracle Management Cloud (OMC) is NOT a replacement of Oracle Enterprise Manager Cloud Control (OEM CC) or even an equivalant. Rumours are that this will be Oracle’s policy in a far away future, but in the meantime we focus on what they do best.

(Ben Brumm) Are you getting an “ORA-00911 invalid character” error when running an SQL statement? Find out what causes it and how to resolve it in this article.

(Hemant K Chitale) My 2node RAC environment has 1 PDB. Here I add (create) a new Service to the PDB.

(Jeff Smith) A friend, let’s call her ‘Helen’ for the sake of this post, texted me the other day, wondering why she had all these dozens/hundreds (?) of files in her Windows home directory.