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.
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