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 (*1) | Enables dynamic SQL execution | ||
Fujitsu Enterprise Postgres 17 includes enhancements to the DBMS_SQL package and changes to the function interface for better migration from Oracle databases. If you are using an application developed prior to Fujitsu Enterprise Postgres 16 SPz, simply upgrading the database will not take advantage of DBMS_SQL. Take one of the following actions. The "z" in SPz indicates the number at which the product is upgraded.
If you want to use the conventional interface as it is
Refer to "G.1 When using the DBMS_SQL package compatible with Fujitsu Enterprise Postgres 16 SPz or earlier" to change to a compatible DBMS_SQL package so that functions from the DBMS_SQL package prior to Fujitsu Enterprise Postgres 16 SPz are still available.
If you use the old interface as is, you can use only the functional range of the compatible DBMS_SQL package (Functional range up to Fujitsu Enterprise Postgres 16 SPz).
If you want to take advantage of the new enhanced interface
Refer to "G.2 How to Migrate Applications that Use the DBMS_SQL Package" and modify the functions used by your application to support the new interface.
Note
The DBMS_SQL package for Fujitsu Enterprise Postgres 16 SPz and earlier is provided as a deprecated feature for compatibility reasons, and will not be supported in the future. Please check the support status in advance when upgrading your system in the future.
See
Refer to the file below for information on the features compatible with Oracle databases.
Linux:
fujitsuEnterprisePostgresInstallDir/share/doc/extension/README.asciidoc
Windows(R):
fujitsuEnterprisePostgresInstallDir\doc\extension\README.asciidoc
