(Szymon Skorupinski) A little bit scary title, isn’t it? Please keep in mind that definitely it is neither supported nor advised method to solve your problems and you should be really careful while doing it – hopefully not on production environment.

(Kim Berg Hansen) I’ve been playing around with MATCH_RECOGNIZE – the data pattern matching extension to SELECT that was introduced in version 12.

(Andrejus Baranovskis) This post is based on Steve Muench sample Nr. 156. In my personal opinion, ADF samples implemented by Steve Muench still remain one of the best source of examples and solutions for various ADF use cases.

(mwidlake) Most of us know that the Oracle DATE datatype has upper and lower limits. From the Oracle 11g Database Concepts manual:

(John Hallas) I thought I would refresh my knowledge of creating a standby database and at the same time include some DataGuard Broker configuration which also throws in some changes that came along with 12c

(Andrejus Baranovskis) This post is based on Steve Muench sample Nr. 156. In my personal opinion, ADF samples implemented by Steve Muench still remain one of the best source of examples and solutions for various ADF use cases.

(mwidlake) Most of us know that the Oracle DATE datatype has upper and lower limits. From the Oracle 11g Database Concepts manual:

(John Hallas) I thought I would refresh my knowledge of creating a standby database and at the same time include some DataGuard Broker configuration which also throws in some changes that came along with 12c

(David Fitzjarrell) One of the more confusing statistics in Oracle is, apparently, one called the clustering factor. Associated with an index (as evidenced by the columns in DBA_INDEXES) it’s actually dependent on the table data, more specifically the distance between ‘jumps’ for a given index key.

(Uwe Hesse) After invisible indexes got introduced in 11g, they have now been enhanced in 12c: You can have multiple indexes on the same set of columns with that feature. Why would you want to use that?