Compiled guide for quick start with Postgres
The best way to start working with Postgres is to launch Docker container from official Postgres image. Such approach allows you to launch up databases for any Postgres version with the possibility to run them in parallel. Great benefit of such approach is that everything is done with a single command.
Comparative "How To" between Oracle and Postgres
Following text describes Oracle as it was before its pluggable era which started from 12th major version. While majority (if not all) of these examples will work as described there might be new features that will make some cases from not possible to already exists in Oracle.
One of such examples is added OFFSET clause in SELECT which was absent in latest 11.2 version.
Postgres version described is mainly latest 11th range version which is 11.7.
In general, provided examples are not version specific and should work on both latest versions of Oracle and Postgres.