SQL reference v16
This SQL reference information applies to organizations migrating their Oracle applications to use EDB Postgres Advanced Server.
A subset of the EDB Postgres Advanced Server SQL language is compatible with Oracle databases. These SQL syntaxes, data types, and functions work in both EDB Postgres Advanced Server and Oracle.
Note
The EDB Postgres Advanced Server also includes syntax and commands for extended functionality (functionality that doesn't provide database compatibility for Oracle or support Oracle-styled applications) that aren't included here.
SQL syntax
Provides basic information about the general syntax
Data types
Provides descriptive information about specific data types
Functions and operators
Provides descriptions of functions and operators for the built-in data types