2 The SQL Language

EDB Postgres Cloud Database Service

A complete managed service, delivering enterprise-ready EDB Postgres databases on the Amazon Web Services (AWS) Cloud.

Take advantage of our full-featured trial today — no credit card required.

Try it Now Free

Already have an account? Log in

2 The SQL Language

2 The SQL Language

The following sections describe the subset of the Advanced Server SQL language compatible with Oracle databases. The following SQL syntax, commands, data types, and functions work in both EDB Postgres Advanced Server and Oracle.

The Advanced Server documentation set includes syntax and commands for extended functionality (functionality that does not provide database compatibility for Oracle or support Oracle-styled applications) that is not included in this guide.

This section is organized into the following sections:

•

General discussion of Advanced Server SQL syntax and language elements

•

Data types

•

Summary of SQL commands

•

Built-in functions

2 The SQL Language