Oracle Chandra Rawat in Oracle A Guide to INSERT, UPDATE, and DELETE Statements in Oracle In this article, we’ll be focusing on three of the most used SQL commands in Oracle: INSERT, UPDATE, and DELETE.... 09 June 2023 19 min read
Oracle Chandra Rawat in Oracle The SELECT Statement in Oracle The SELECT statement is used to retrieve information from a database. Following the execution of a SELECT statement, a tabular... 16 March 2023 19 min read
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... 26 October 2022 15 min read
Oracle Jonathan Lewis in Oracle Oracle optimizer removing or coalescing subqueries The Oracle optimizer often changes the query to get better performance. In this article, Jonathan Lewis explains two more optimizations... 27 April 2022 17 min read
Oracle Samuel Nitsche in Oracle Why your PL/SQL needs to be testable – and how to do it: Part 1 Part 1: What is testable code, why is it important, and first glimpses on practices that can help Anyone familiar... 05 April 2022 15 min read
Oracle Jonathan Lewis in Oracle Oracle subquery caching and subquery pushing In this article, Jonathan Lewis discusses why you might want to stop the optimizer from unnesting some subqueries and how... 18 March 2022 12 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... 22 February 2022 11 min read
Oracle Jonathan Lewis in Oracle Transformations by the Oracle Optimizer To troubleshoot poorly performing SQL in Oracle, you must understand which transformations the optimizer has made. Jonathan Lewis demonstrates several... 14 January 2022 16 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... 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... 19 August 2021 16 min read
Oracle Jonathan Lewis in Oracle Typical uses of Oracle sequences Oracle sequences supply unique numbers that can be used when populating tables. In this article, Jonathan Lewis explains the typical... 14 July 2021 17 min read
Oracle Jonathan Lewis in Oracle Oracle Sequences: RAC Using sequences when scaling up with Oracle RAC presents more issues with contention. In this article, Jonathan Lewis explains how... 11 May 2021 19 min read
Oracle Jonathan Lewis in Oracle Oracle sequences: The basics Oracle sequences can be used to create artificial IDs for a table. In this article, Jonathan Lewis explains how they... 26 March 2021 14 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... 11 January 2021 15 min read
Oracle Jonathan Lewis in Oracle Are your Oracle archived log files much too small? Oracle sometimes generates smaller archived redo logs than you might expect based on the size of the online redo logs.... 30 November 2020 12 min read
Oracle Srinivasan Suresh in Oracle SQL Developer – A great tool and better ways to use it SQL Developer is a popular free tool for working with Oracle databases. In this article Srinivasan Suresh explains several features... 19 November 2020 14 min read
Oracle Cynthia Dzikiti in Oracle Why choose Oracle? Oracle has been established as one of the top database systems used in enterprises throughout the world. In this article,... 28 September 2020 11 min read
Oracle Kellyn Pot'Vin-Gorman in Oracle What is Oracle ASM to Azure IaaS? Kellyn Pot'Vin-Gorman explains Oracle Automatic Storage Management and why it’s impossible to do a comparison to Azure IaaS.… 14 September 2020 11 min read
Oracle David Njoku in Oracle Oracle for Absolute Beginners: Problem-Solving as a New Developer Learning programming logic and syntax is just the beginning. In this article, David Njoku talks about how to debug and... 30 April 2019 9 min read
Oracle Cynthia Dzikiti in Oracle Security Considerations for ERP Applications Security is, or at least should be, the priority for any IT system. In this article, Cynthia Dzikiti discusses the... 01 April 2019 16 min read