DBA Data[Home] [Help]

VIEW: SYS.PUBLICSYN

Source

View Text - Preformatted

select sname, creator, tname, database, tabtype
  from  synonyms
  where syntype = 'PUBLIC'
View Text - HTML Formatted

SELECT SNAME
, CREATOR
, TNAME
, DATABASE
, TABTYPE
FROM SYNONYMS
WHERE SYNTYPE = 'PUBLIC'