Top
Symfoware Server V12.1.0 Application Development Guide
FUJITSU Software

9.1 Overview

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

The following compatible features are provided:

Table 9.1 Features compatible with Oracle databases

Category

Features compatible with Oracle databases

Item

Overview

SQL

Queries

Outer join operator (+)

Operator for outer joining

DUAL table

Tables provided by the system

Functions

DECODE

Compares and converts values

SUBSTR

Extracting part of a character string

NVL

NULL value conversion

Package

DBMS_OUTPUT

Message sending

UTL_FILE

File operation

DBMS_SQL

Dynamic SQL execution