Library /sys$common/syshlp/RDOHELP72.HLB  —  Datatypes
    This table summarizes the characteristics of the Oracle Rdb data
    types.

    Table 1 : Oracle Rdb Data Types

    Oracle Rdb       Corresponding    Size     Range          Other
    Data Type     CPU Data Type             Precision      Parameters

    SIGNED        Signed byte      8 bits   -128 to          n = scale
    BYTE          integer                   127              factor

    SIGNED        Signed word     16 bits   -32768 to        n = scale
    WORD          integer                   32767            factor

    SIGNED        Signed          32 bits   -2**31 to        n = scale
    LONGWORD      longword                  (2**31)-1        factor
                  integer

    SIGNED        Signed          64 bits   -2**63 to        n = scale
    QUADWORD      quadword                  (2**63)-1        factor
                  integer)

    F_FLOATING    F_floating      32 bits   0.29 x 10**(-38)    None
                  Single                    to 1.7 x 10**38
                  precision                 Approximately
                  floating                  seven decimal
                  point number              digits

    G_FLOATING    G_floating      64 bits   0.56 x 10**(-308)   None
                  Extended                  to 0.9 x 10**308
                  precision                 Approximately
                  floating                  15 decimal
                  point number              digits

    DATE          Absolute date   64 bits   Not                 None
                  and time                  applicable

    TEXT          ASCII text      n bytes   0 to 32767        n = number of
                                            characters        characters
                                                              (unsigned
                                                              integer)

    VARYING       Varying         Varies    0 to 32765        n = maximum
    STRING        length ASCII              characters        number of
                  text                                        characters
                                                              (unsigned
                                                              integer)

    SEGMENTED     None            Varies    0 to 64k            None
    STRING                                  bytes per
                                            segment

    Note:         For more information on SEGMENTED STRINGS, request HELP
                  on Segment_str.
Additional Information: explode extract
More
Close Help