(Patch) Dear Patrick, What is an ANTI-JOIN? And what is the difference between the SEMI-JOIN and the ANTI-JOIN?

(David Fitzjarrell) Oracle 12.1.0.2 provides new functionality for finding pattern matches in a data set; using the MATCH_RECOGNIZE function it’s fairly easy to generate results based on a defined pattern in the data. Let’s look at some examples and see how to use MATCH_RECOGNIZE to find and report

(Randolf Geist) Here is another example (besides the fact that Adaptive Cursor Sharing only gets evaluated during a PARSE call (still valid in 12c) and supports a maximum of 14 bind variables) I’ve recently come across at a client site where the default implementation of Adaptive Cursor Sharing fail

(Andrejus Baranovskis) I will describe with practical example, how to authenticate against MCS in Oracle JET using OAuth.

(Bobby Durrett) A coworker passed a test script on to me that was failing with the following memory error:

(Ben) The Oracle TO_NCLOB function is a simple function and is used for conversion. Learn what it does and see some examples in this article.

(Torsten Kleiber) As I want later build Oracle docker images, some of this need a swapfile.

(John Hallas) Back in Nov 2015 I commented on a Oracle-L discussion about What happened to SQL*Developer SQL Formatter asking why people liked to see a comma at the beginning of the line in sql code and there was a fair bit of input into how it was easier to use and amend – think of it like bullet

(Yasin.Baskan) Recently I got a question from a customer about a parallel query which produces wrong results. The query involves a global temporary table and a parallel enabled PL/SQL function. Before talking about this specific query I want to briefly show the effect of using PL/SQL functions in a

(Ben) In this article, I’ll take a look at the Oracle TO_CLOB function, and show you some examples.