SQL$HELP72.HLB  —  SET_DIALECT, Arguments  ORACLE_LEVEL2
    This includes all the behavior describe for ORACLE LEVEL1 plus
    the following changes:

    o  The same dialect rules as SQL99 are in effect minus reserved
       word checking and the DATE ANSI format.

    o  Concatenate (||) and the CONCAT function allow for all data
       types, not just character types (CHAR, and VARCHAR). The
       numeric, or date/time values are converted to VARCHAR prior
       to the concatenation.

    o  Date subtraction results in a floating result. Partial days
       are now represented by a fraction portion.

    o  This is not an exhaustive list. Refer to Oracle Rdb Release
       Notes for additional semantic changes for dialect ORACLE
       LEVEL2.
Close Help