DBA Data[Home] [Help]

VIEW: SYS.KU$_TTS_TYPES_VIEW

Source

View Text - Preformatted

select tabobjno, typeobjno, typename, typeowner
    from  ku$_table_types_view
  UNION ALL
    select tabobjno, typeobjno, typename, typeowner
    from  ku$_xmlschema_types_view
View Text - HTML Formatted

SELECT TABOBJNO
, TYPEOBJNO
, TYPENAME
, TYPEOWNER
FROM KU$_TABLE_TYPES_VIEW UNION ALL SELECT TABOBJNO
, TYPEOBJNO
, TYPENAME
, TYPEOWNER
FROM KU$_XMLSCHEMA_TYPES_VIEW