(connormcdonald) We had a question on AskTom the other day, talking about comparing clobs. (Paraphrasing) the question inquired as to why we had a DBMS_LOB.COMPARE function, when you can you just compare clobs directly, using the following example:

(ilmarkerm) For our backup strategy we are using incrementally updated image copies on most Oracle databases. This method can save a lot of time during restore operations, since you don’t need to restore full backup and then apply all the incremental backups, you can either restore the full backup d

(Uwe Hesse) If your Oracle Database fits into the buffer cache, we will put all segments into it now upon access – no more direct reads:

(David Fitzjarrell) Numbers mean a lot of things, and in Oracle 12.1.0.2 they can spell trouble for interval-partitioned tables. Oracle Support received notification of this back in March of 2015 and as of the most recent update to the SR the issue hasn’t been solved. Let’s look at what can happen w

(Kellyn Pot’Vin) SQL Monitor is one cool tool. Via EM12c, it empowers everyone, (yes, that means the developer, too, so give them the access to view this data via Cloud Control, please!) This is a top five list, but it doesn’t stop there, just remember, this is my favorite features when using Clou

(Andrejus Baranovskis) In my previous post I have shared basic example for Oracle JET integration into ADF – Oracle JET and ADF Faces Integration in ADF. Today I would like to share a bit more than that – integration pattern with ADF Regions.

(Bobby Curtis) Oracle GoldenGate 12c (12.2.0.1.0) has changed the information that is stored in the trail files. All the standard information is still there. What Oracle changed has to do with the meta data that is used to define a table.

(connormcdonald) You need to be careful when coding and using triggers when it comes to Datapump (or anything that transposes triggers between schemas).

(Frank Nimphius) This article is a quick note on how to validate an input field added to an amx:listView and how to reset the list item value back to the original value. The use case in the sample code snippet is a field service application that technicians use to protocol service incidents, the sta

(connormcdonald) Analytic functions still bamboozle many SQL practitioners out there. So I’m building a suite of videos to walk people through some of the common questions we get asked that we need to solve with SQL, and look at how we can often solve them most simply using Analytic functions.