ivorysql_ora

Overview

from contrib/ivorysql_ora/ivorysql_ora.control and package metadata

Version

Install

You can install ivorysql directly. First, make sure the PGDG and PIGSTY repositories are added and enabled:

pig repo add pgsql -u          # Add repo and update cache

Install the extension using pig or apt/yum/dnf:

• Install
• pig
• dnf
• apt

pig install ivorysql;          # Install for current active PG version

pig ext install -y ivorysql -v 18  # PG 18

dnf install -y ivorysql5       # PG 18

apt install -y ivorysql-5   # PG 18

Create Extension:

CREATE EXTENSION ivorysql_ora;

Usage

ivorysql_ora: Oracle Compatible extension on Postgres Database

The ivorysql_ora extension provides Oracle compatibility features for PostgreSQL as part of the IvorySQL project. It adds Oracle-compatible data types, functions, and PL/SQL behavior.

Enabling

CREATE EXTENSION ivorysql_ora;

Oracle-Compatible Data Types

The extension adds Oracle-style data types including:

• NUMBER / NUMBER(p,s) - Oracle-compatible numeric type
• VARCHAR2(n) - Oracle-compatible variable-length string
• DATE - Oracle-style DATE with time component
• BINARY_FLOAT / BINARY_DOUBLE - IEEE floating point types

Oracle-Compatible Functions

Provides Oracle-style built-in functions for string manipulation, date arithmetic, numeric operations, and type conversion that behave consistently with Oracle semantics.

Compatibility Mode

IvorySQL supports an Oracle compatibility mode that changes parser behavior:

SET compatible_mode TO oracle;  -- enable Oracle compatibility
SET compatible_mode TO pg;      -- revert to standard PostgreSQL

In Oracle mode, the SQL parser accepts Oracle-style syntax including:

• Oracle-style outer joins ((+) syntax)
• CONNECT BY hierarchical queries
• Oracle-style sequences (sequence.NEXTVAL)
• Package-style object references