VIEW: SYS.TAB

Source

View Text - Preformatted

select o.name,
      decode(o.type#, 2, 'TABLE', 3, 'CLUSTER',
             4, 'VIEW', 5, 'SYNONYM'), t.tab#
  from  sys.tab$ t, sys."_CURRENT_EDITION_OBJ" o
  where o.owner# = userenv('SCHEMAID')
  and o.type# >=2
  and o.type# <=5
  and o.linkname is null
  and o.obj# = t.obj# (+)

View Text - HTML Formatted

SELECT O.NAME
, DECODE(O.TYPE#
, 2
, 'TABLE'
, 3
, 'CLUSTER'
, 4
, 'VIEW'
, 5
, 'SYNONYM')
, T.TAB#
FROM SYS.TAB$ T
, SYS."_CURRENT_EDITION_OBJ" O
WHERE O.OWNER# = USERENV('SCHEMAID')
AND O.TYPE# >=2
AND O.TYPE# <=5
AND O.LINKNAME IS NULL
AND O.OBJ# = T.OBJ# (+)