Top
Enterprise Postgres 14 SP1 Application Development Guide
FUJITSU Software

7.1 Overview

Features compatible with Oracle databases are provided. These features enable you to easily migrate to FUJITSU Enterprise Postgres and reduce the costs of reconfiguring applications.

The table below lists features compatible with Oracle databases.

Table 7.1 Features compatible with Oracle databases

Category

Feature

Item

Overview

SQL

Queries

Outer join operator (+)

Operator for outer joins

DUAL table

Table provided by the system

Functions

DECODE

Compares values, and if they match, returns a corresponding value

SUBSTR

Extracts part of a string using characters to specify position and length

NVL

Returns a substitute value when a value is NULL

Package

DBMS_ALERT

Sends alerts

DBMS_ASSERT

Perform assertions on input values

DBMS_OUTPUT

Sends messages to clients

DBMS_PIPE

Execution of inter-session communication

DBMS_RANDOM

Random number generation

DBMS_UTILITY

Addition of various functions

UTL_FILE

Enables text file operations

DBMS_SQL

Enables dynamic SQL execution

See

In addition to the above, refer to the file below for information on the features compatible with Oracle databases.

fujitsuEnterprisePostgresInstallDir/share/doc/extension/README.asciidoc