This chapter describes the subset of the Postgres Plus Advanced Server SQL language that is Oracle compatible. The SQL syntax, commands, data types, functions, etc. described in this chapter work in both Postgres Plus Advanced Server and in Oracle.

Other aspects of the Postgres Plus Advanced Server SQL language that are not Oracle compatible can be found in the Postgres Plus documentation set. Thus, certain functionality that may not be found in this guide may be doable using the syntax and commands found in the Postgres Plus documentation set.

This chapter is organized into the following sections:

● General discussion of Postgres Plus Advanced Server SQL syntax and language elements

● Data types

● Summary of SQL commands

● Built-in functions