The SHOW FIELD command displays a complete or partial list of
    properties for the field names you specify, provided you have
    read privileges.

    If you do not specify a full path name (or the FROM DATABASE
    clause) for the field name, CDO searches your current default
    directory for the field name. If you do not specify a field name,
    CDO displays the properties of all field names in your default
    directory.

    If you do not specify a version number for a field name, CDO
    displays the properties of the highest visible version.

                                   NOTE

       If you make incompatible changes to the CDD$DATA_ELEMENT
       type, supplied by Oracle CDD/Repository, the SHOW FIELD
       command may not display those properties whose data types
       you have modified.

    If a field has character set attributes, you can display them
    using the SHOW and EXTRACT commands; in addition, you can use
    the SHOW command to display size information of a field in both
    character-based size and octet-based size. See the descriptions
    of SET CHARACTER_SET command and the DATATYPE_Field_Property help
    topic found under the fld-properties topic for
    more information.