For example I was told that oracle as no auto increment.
Oracle has sequences; it’s just a different notation. The idea of a column value that’s automatically incremented on INSERT is certainly there.
Oracle will have you add primary and foreign keys as constraints, separate from the table definition.
PostgreSQL is the closest thing to Oracle among the open source databases. It, too, has sequences.