Oracle Jonathan Lewis in Oracle Oracle optimizer Or Expansion Transformations The previous installment of this series examined aggregate subquery removal and subquery coalescing, describing the latter as similar in some ways to an inverse for... 26 October 2022 15 min read
Oracle Jonathan Lewis in Oracle The effects of NULL with NOT IN on Oracle transformations IN and NOT IN subqueries are frequently used in Oracle. Jonathan Lewis explains how the optimizer handles NULL with IN and NOT IN.… 22 February 2022 11 min read
BI Sanil Mhatre in BI Text Mining and Sentiment Analysis: Oracle Text Oracle has built-in functionality to analyze text. Sanil Mhatre demonstrates how to perform a sentiment analysis on data stored in a table using Oracle Text.… 30 August 2021 12 min read
Oracle Jonathan Lewis in Oracle Oracle sequences – 12c features including “identity” Oracle added several enhancements to the sequence object in version 12c, including an “identity” column feature. Jonathan Lewis explains how to work with these new... 19 August 2021 16 min read
Oracle Jonathan Lewis in Oracle Oracle archived redo size – the research Oracle archived redo size may be smaller than that of online redo log files. In this article, Jonathan Lewis takes a deeper look.… 11 January 2021 15 min read
Oracle Mike Smithers in Oracle utPLSQL 3.0 – How To Have Your Cake and Eat It This article was originally published on mikesmithers.wordpress.com. “You can’t have your cake and eat it!” This seems to be a regular refrain from the EU in... 08 May 2018 27 min read
Oracle Samuel Nitsche in Oracle Strongholds of Confidence: Self-Testing Your Database Unit testing and even Test-Driven Development is possible for databases. In this article Samuel Nitsche makes the case for introducing unit tests to your database... 04 April 2018 17 min read
Oracle Nick Buytaert in Oracle Validating naming conventions in Oracle Most development teams have agreed upon some sort of naming convention as it typically increases the readability and comprehension of the source code. Defining these... 20 February 2018 8 min read
David Njoku JSON For Absolute Beginners: Part 4 – Retrieving JSON in Oracle There’s a possibility you’ve parachuted into this series on JSON and Oracle at this point. If you are already familiar with what JSON is and... 03 October 2016 11 min read
David Njoku XQuery for Absolute Beginners: Part 3 – FLWOR This is the third instalment in a series of articles that I’m hoping will serve as a primer for Oracle developers interested in learning about... 21 March 2016 9 min read
David Njoku XQuery for Absolute Beginners: Part 2 – XQuery and the Oracle Database In this series of articles I’m hoping to provide a primer for newish Oracle developers who are curious about XQuery and are looking to dip... 02 March 2016 7 min read
David Njoku Introduction to Analytic Functions (Part 2) In the first part of this series I introduced you to the analytic functions family, outlined its close relationship to aggregate functions, and illustrated my... 17 September 2015 7 min read
Steve Harville Data Masking using SQL Loader I use Enterprise Manager Cloud Control to mask Oracle databases so they can be shared with our ERP vendor. I intended to do the same with our... 25 February 2015 5 min read
Randolf Geist Parallel Execution Skew – Addressing Skew Using Manual Rewrites In this part of the series we will have a look at different approaches to how Parallel Execution Skew can be addressed via manual re-writes... 23 June 2014 13 min read
David Njoku Oracle for Absolute Beginners: Part 7 – Creating Tables, Constraints and Triggers A wise man once said: start at the beginning and go on till you come to the end: then stop. We’ve done things a little... 10 June 2014 9 min read
David Njoku Oracle for Absolute Beginners: Part 6 – Procedures and Functions A wise man once said, insanity is doing the same thing over and over again but expecting different results. If that is the case then... 07 May 2014 13 min read
Kirill Loifman High Availability and SLA requirements for Oracle database Designing a highly available database system involves taking various elements and combining them to suit your business needs and requirements. At the beginning of architecting... 24 November 2013 1 min read
Michael Sorens TortoiseSVN and Subversion Cookbook Part 11: Subversion and Oracle It is only recently that the tools have existed to make source-control easy for database developers. Although entire build-scripts for databases could be stored in... 03 April 2013 17 min read
Richard Morris Kohsuke Kawaguchi: Geek of the Week Jenkins, formerly called Hudson, is an open-source server-based Continuous Integration tool that works with all the major Source Control Management (SCM) tools including TFS, and... 17 July 2012 11 min read
Patrick Barel Working with Table Functions in PL/SQL Table functions are functions that produce a collection or rows (either a nested table or a varray) that can be queried like a physical database... 20 July 2011 2 min read
