select_statement

The SQL statement SELECT (select_statement) is supported in MaxDB with restricted syntax (SELECT statement).

·        MaxDB does not support the specification of START WITH <condition> or CONNECT BY <condition>.

·        MaxDB sometimes rejects outer joins with more than two tables in the FROM clause valid in Oracle.

·        If the results in a table that are obtained from a SELECT statement are to be updateable, the syntax element FOR UPDATE must be entered.