(Oren Nakdimon) One of the first posts I wrote in this blog (almost five years ago) was about the FIRST and LAST aggregate functions.

(Arun Gupta) Rolling upgrade with Transient Logical Standby is known as a MAA (Maximum Availability Architecture) technique, to minimize downtime during upgrade of Oracle database.

(Scott Wesley) In my Exploring AJAX presentation I had a frame that mentioned the ability for the Chrome browser to emulate the behaviour of a mobile device.

(Andrejus Baranovskis) What if you need to verify – if row with given key exists in fetched rowset? This could be useful while implementing validation logic. ADF BC API method findByKey – will trigger SQL call and fetch row from DB, if row with given key doesn’t exist in fetched rowset.

(Anuradha Mudgal) Today we are going to have look at the “MONITORING ALERT LOG ORA-ERRORS”. With help of this script DBA can monitor all the ORA-Errors from the alert log and used to send to our mailboxes, he schedules this through a cronjob.

(Simon Greener) The following article results from customers downloading the free source code (eg for Oracle SDO_GEOMETRY) on this site without fully understanding that the code is not for ESRI’s ST_GEOMETRY spatial type and then requesting changes to the source code to support that foreign type.

(Dirk Nachbar) 2 years ago, I have published an article series about the undocumented feature “ALTER USER RENAME”:

(Syed Jaffar Hussain) Data Guard was configured a few days back at one of the customers site. An ORA-19527 error is continuously reported in the standby database alert.log (database name is changed)

(Gokhan Atil) One of my customers had a problem about logging in to Oracle Data Integrator (ODI) Studio. Their ODI implementation is configured to use external authentication (Microsoft Active Directory).

(Bobby Curtis) One of the nice things about Oracle GoldenGate 12.3 Microserivces, is the flexibility we now have to interact with Oracle GoldenGate. Additionally, what comes with Oracle GoldenGate 12.3 Microservices is a new role based security frame work.