(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:
Tag: Oracle
Recatalog incrementally updated image copy in RMAN
(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
Full Database Caching in #Oracle 12c
(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:
Export-Import Business
(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
Top 5 SQL Monitor Features
(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
ADF and Oracle JET – Integration Pattern with ADF Regions
(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.
Table Definitions in Oracle #GoldenGate #12c Trail Files
(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.
Where did my triggers go ?
(connormcdonald) You need to be careful when coding and using triggers when it comes to Datapump (or anything that transposes triggers between schemas).
Quick Note: How to validate an input field in a list view
(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
KISS video series for Analytic functions
(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.
