This article gives tips and tricks on how to write and understand hierarchical query in Oracle databases implemented using CONNECT BY clause and then how to convert using recursive WITH…
Database migration is conceptually though a simple task, but there are many uninvited challenges that database migration brings in. You can read our article Challenges during a typical data migration…
Managing databases to run at scale with high availability and reliability is difficult, time consuming and expensive. This is why, many companies are moving their databases to cloud to explore…
In this article, you will understand when and where to use single and double quotes in Oracle. To begin with, let's first understand what is a Literal and what are…