| Convert from/to | CHAR, VARCHAR2 | NVHAR, NVARCHAR2 | DATETIME, INTERVAL | NUMBER | RAW | ROWID, UROWID |
|---|---|---|---|---|---|---|
| CHAR, VARCHAR2 | Yes | No | Yes | Yes | Yes | Yes |
| NVHAR, NVARCHAR2 | No | Yes | Yes | Yes | Yes | Yes |
| DATETIME, INTERVAL | Yes | No | Yes | No | No | No |
| NUMBER | Yes | No | No | Yes | No | No |
| RAW | Yes | No | No | No | Yes | No |
| ROWID, UROWID | Yes | No | No | No | No | Yes |