Generating massive amounts of data can be useful to test queries, indexes and tuning complex SQL queries on more realistic volumes, to get useful approximations of production like environment. This…
This article gives an overview of how to write and understand hierarchical query in Oracle databases using recursive subquery factoring and using LEVEL clause. Hierarchical query using CONNECT BY Oracle…
RAISE statement in PostgreSQL is used to report messages and raise errors. PostgreSQL provides level option to specify with RAISE that specifies the severity of the statement. Possible levels with…
Database migration is conceptually though a simple task, but there are many uninvited challenges that database migration brings in. You can read more about the challenges during a typical data…
A cloud database is a database service built and accessed through a cloud platform. In simple terms, cloud databases are databases hosted in the cloud vendor's environment and you access…
Cloud computing, often referred to as "The Cloud", is a service provided by vendors to give you access to servers, storage, databases, and a broad set of application services over…
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…
Data is the ultimate asset in today's world. Data is the raw facts and statistics collected during any operation. Types of Data? Structured: Data is categorized as structured or…
Gone are the days when an RDBMS (Relational Database Management System) was the appropriate solution for every database need. Why? Let’s discuss two scenarios in this post. Consider the “Three…
Every PostgreSQL function has some special attributes which greatly determines its behavior. Every function in PostgreSQL has a volatility classification, with the possibility of being VOLATILE, STABLE, or IMMUTABLE. VOLATILE is the default if…