Hasan Alizada Hasan Alizada - 1 year ago 68
SQL Question

Oracle built-in datatypes system view

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 Source
  SELECT t.typecode, name
  FROM sys.type$ t, sys.obj$ o
  AND t.toid = o.oid$ and t.typecode = 96;
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download