1  –  type-name

    Specifies the type of the generic element whose properties you
    are displaying. This type cannot be MCS_BINARY, a subtype of MCS_
    BINARY, MCS_COLLECTION, MCS_CONTEXT, or MCS_PARTITION. See the
    Oracle CDD/Repository Information Model for information on these
    types.

2  –  element-name

    Specifies the generic element whose properties you are
    displaying.

    When you use the FROM DATABASE clause, specify only one element
    name for each SHOW GENERIC command.

    Specify an asterisk (*)  wildcard character for the entire
    element-name parameter only. If you use a wildcard character
    as part of the element-name, an error occurs.

3  –  database-name

    Specifies the Oracle Rdb database that contains the element. CDO
    requires this parameter for elements from an Oracle Rdb database.
    You can include wildcard characters in the database name.