DBA Data[Home] [Help]

VIEW: SYS.KU$_TTS_INDPARTVIEW

Source

View Text - Preformatted

SELECT i.bo#, NULL, ts.name, ts.ts#
    from  (     sys.indpart$ ip
     inner join sys.ind$     i  on i.obj#=ip.bo#
     inner join sys.ts$      ts on ip.ts#=ts.ts#)
View Text - HTML Formatted

SELECT I.BO#
, NULL
, TS.NAME
, TS.TS#
FROM ( SYS.INDPART$ IP INNER JOIN SYS.IND$ I ON I.OBJ#=IP.BO# INNER JOIN SYS.TS$ TS ON IP.TS#=TS.TS#)