RDBMS side by side - GradedJestRisk/db-training GitHub Wiki
| Object | Oracle | PostgreSQL |
|---|---|---|
| value out-of table | DUAL as virtual table | SELECT without FROM |
| Object | Oracle | PostgreSQL |
|---|---|---|
| DDL validate transaction | Yes | No |
| Object | Oracle | PostgreSQL |
|---|---|---|
| Package | X | |
| Named parameter | X | X |
| access I/O (eg. fs) | X | X (use untrusted) |
| add languages (eg. C) | X |