VIEW: SYS.CODE_PIECES

Source

View Text - Preformatted

select i.obj#, i.length
  from sys.idl_ub1$ i
  where i.part in (1,2)
union all
  select i.obj#, i.length
  from sys.idl_ub2$ i
  where i.part in (1,2)
union all
  select i.obj#, i.length
  from sys.idl_sb4$ i
  where i.part in (1,2)
union all
  select i.obj#, i.length
  from sys.idl_char$ i
  where i.part in (1,2)

View Text - HTML Formatted

SELECT I.OBJ#
, I.LENGTH
FROM SYS.IDL_UB1$ I
WHERE I.PART IN (1
, 2) UNION ALL SELECT I.OBJ#
, I.LENGTH
FROM SYS.IDL_UB2$ I
WHERE I.PART IN (1
, 2) UNION ALL SELECT I.OBJ#
, I.LENGTH
FROM SYS.IDL_SB4$ I
WHERE I.PART IN (1
, 2) UNION ALL SELECT I.OBJ#
, I.LENGTH
FROM SYS.IDL_CHAR$ I
WHERE I.PART IN (1
, 2)