Oracle built-in datatypes system view

Question

Folks!

Does somebody know an Oracle built-in datatypes system dictionary view?

Example:

SELECT DUMP ('HASAN') FROM DUAL;

returns

Typ=96 Len=5: 72,65,83,65,78

Oracle documentation says that it is CHAR or NCHAR datatype.

But is there a view, where I can find this datatype by code returned (Typ=96)?

Does it exist at all?

Answer 1

  SELECT t.typecode, name
  FROM sys.type$ t, sys.obj$ o
  WHERE t.toid = o.oid$ and t.typecode = 96;