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

Oracle

Ben Brumm in Oracle

10 Best Practices for Writing Oracle SQL

There is often more than one way to write a query that returns the same results, but some methods may...

30 August 2018 13 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...

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...

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...

20 February 2018 8 min read

Containers and Virtualization

Anand Joshi

Yogesh Bhate in Containers and Virtualization

Overcoming the Challenges of Microservices and Docker Containerisation

A microservice architecture can provide great benefits to certain types of applications that have pronounced troughs and peaks in demand,...

19 September 2017 22 min read

David Njoku

Oracle for Absolute Beginners: Users, Synonyms, Privileges, & Roles

I accidentally locked myself out of my house this evening, and so I had to climb up the wall like...

01 March 2017 11 min read

Aman Sharma

Getting started with Oracle Database 12c Multitenant Architecture

Oracle database, since its inception, has always used a very specific and unique architecture which served it very well. In...

22 February 2017 15 min read

David Njoku

JSON For Absolute Beginners: Part 6 – Generating JSON post-12c Release 2

In this sixth and final installment in this introductory series on JSON I’d like to revisit the question of generating...

22 February 2017 6 min read