Here is the list of the Oracle SQL types and their internal codes:
SELECT t.typecode,o.name
FROM sys.TYPE$ t, sys.obj$ o
WHERE
BITAND (t.properties, 16) = 16
AND t.toid = o.oid$
ORDER BY t.typecode
FROM sys.TYPE$ t, sys.obj$ o
WHERE
BITAND (t.properties, 16) = 16
AND t.toid = o.oid$
ORDER BY t.typecode
‘
