Migrate Oracle to PostgreSQL: Roles and Privileges
Summary: In this article, you will learn the roles and privileges, and the differences between Oracle and PostgreSQL.
Migrate Oracle to PostgreSQL: PL/SQL vs PL/pgSQL
Summary: In this article, you will learn the features of procedural languages, and the differences between PL/SQL and PL/pgSQL.
Migrate Oracle to PostgreSQL: Understand the Concept of Schema
Summary: In this article, you will learn the concept of schema, and the differences between Oracle and PostgreSQL.
Migrate Oracle to PostgreSQL: NULL and empty strings
Summary: This article discusses the differences between how Oracle and PostgreSQL evaluate NULL characters and empty strings. Oracle reads empty strings as NULLs, while PostgreSQL treats them as empty. Concatenating NULL values with non-NULL characters results in that character in Oracle, but NULL in PostgreSQL.