返回与 相同的类型。

    from BINARY_FLOAT, BINARY_DOUBLEfrom CHAR, VARCHAR2from NUMBERfrom DATETIME/INTERVALfrom RAWfrom NCHAR, NVARCHAR2
    to BINARY_FLOAT, BINARY_DOUBLEyesyesyesnonoyes
    to CHAR, VARCHAR2yesyesyesyesyesno
    to NUMBERyesyesyesnonoyes
    to DATETIME, INTERVALnoyesnoyesnono
    to RAWyesyesyesnoyesno
    to NCHAR, NVARCHAR2yesnoyesyesyesyes

    1To DATETIME/INTERVAL 数据类型包括 DATE、、TIMESTAMP WITH TIMEZONE、INTERVAL DAY TO SECOND 和 。

    查询结果如下：