Oracle: internal sql types

Here is the list of the Oracle SQL types and their internal codes:

SELECT t.typecode,
FROM sys.type$ t, sys.obj$ o
BITAND (, 16) = 16
AND t.toid = o.oid$
ORDER BY t.typecode

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.