Escape Single Quotes in Oracle SQL
Single quotes are used in databases to represent string and date values. The single quotes indicates the start and end position of your string. SQL> SELECT 'This is your string'…
Migrating Cursors from Oracle to PostgreSQL
Cursor is a mechanism by which you can assign a name to a SELECT statement and manipulate the information within that SQL statement. A cursor is a pointer to the…
Difference between single quote and double quote in Oracle SQL
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…
Deep dive into NULL and Empty string in PostgreSQL
PostgreSQL database treats NULL as unknown. NULL is not same as empty or zero value. This is why you can not compare NULL with anything in PostgreSQL database. Comparison of…
NULL in Oracle vs. NULL in PostgreSQL
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…
String concatenation using pipe “||” operator in PostgreSQL
PostgreSQL supports pipe "||" operator which is also called as string concatenation operator. PostgreSQL database also has CONCAT function to perform string concatenation. postgres=# SELECT 'This'||' is string'||' concat'||' example'…
PostgreSQL generate_series() function examples for random data generation
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…
CONNECT BY and WITH Recursive queries in Oracle
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…
RAISE Statement in PostgreSQL to debug your query messages
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…
What is DBaaS?
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…