(Scott Wesley) Let’s say you’re experimenting with a report (IR or classic) column and you would only like it to appear in you development environment.
Tag: Oracle
How To Create a Pivot Table Structure in SQL
(Ben) As part of my web app, I needed to create a pivot-table style output for my reports. I’ll explain what the requirements were and what my solution was in this article.
OSB Thread handling recommendations
(Martien van den Akker) I have got questions on performance of OSB quite a few times already, during the years. A few years ago on a project I got eyes on a set of recommendations on workmanagers for OSB.
Convert Single Geometry to Multi-part Geometry in Oracle Spatial
(Simon Greener) We are trying to exclude the REPLICAT user in OGG 12.1.2 capturing from Oracle 12.1.0.2 bi-directional. But using EXTRACT TRANLOGOPTIONS EXCLUDEUSER to exclude a user in one of the PDBs:
GoldenGate 12.2 EXCLUDEUSER
(mdinh) Here’s a good reason to always use the latest version.
It’s A Match
(David Fitzjarrell) With every new release Oracle provides new features that are very useful, even if you didn’t think of them before. In 12.1.0.2 Oracle provides a new functionality for finding pattern matches in a data set; using the MATCH_RECOGNIZE function it’s fairly easy to generate results ba
Working With Interval Datatype
(mdinh) Here is the scope: The job takes 42m to complete and monitoring threshold is 30m.
‘ORA-20001: Application ID and current security group ID are not consistent’ encountered during APEX Upgrade from 4.x to 5.x
(Jason Straub) Recently, our QA team at Oracle was testing database upgrades, and the following error appeared in the database upgrade log while the APEX component was being upgraded:
Connecting PL/SQL Developer
(Patch72) In SQL Developer you have a lot of options when connecting to the database. You can use the TNS entries defined but you can also give the hostname, port and SID or Servicename for instance. PL/SQL Developer doesn’t supply these options, but you can still use them…
The curious case of the missing semctl call
(Frits Hoogland) This article is about the internals of how the Oracle database handles transactions. In this case the communication mechanism of foreground sessions to the logwriter process is examined.
