DBA Data[Home] [Help]

VIEW: SYS.KU$_TEMP_SUBPARTLOBFRG_VIEW

Source

View Text - Preformatted

SELECT
              lf.parentobj#,
              lf.ts#,
              lf.fragobj#,
              row_number() OVER
                 (partition by lf.parentobj# order by lf.frag#) - 1,
              lf.tabfragobj#
        FROM sys.lobfrag$ lf
View Text - HTML Formatted

SELECT LF.PARENTOBJ#
, LF.TS#
, LF.FRAGOBJ#
, ROW_NUMBER() OVER (PARTITION BY LF.PARENTOBJ# ORDER BY LF.FRAG#) - 1
, LF.TABFRAGOBJ#
FROM SYS.LOBFRAG$ LF