Oracle SYNONYMS

SELECT * FROM USER_SYNONYMS WHERE SYNONYM_NAME = 'syn_name';  -- User synonyms
SELECT * FROM ALL_SYNONYMS WHERE TABLE_OWNER = 'JINJI';	  -- Available to user
SELECT * FROM DBA_SYNONYMS WHERE TABLE_OWNER = 'schema_name'; -- All schemas

SELECT 
  'CREATE OR REPLACE EDITIONABLE PUBLIC SYNONYM "' || SYNONYM_NAME 
  || '" FOR "' || SYNONYM_NAME || '"@' ||  TABLE_OWNER || '.' || DBLINK_NAME || ';' SQL 
FROM ALL_SYNONYMS WHERE TABLE_OWNER = 'SCHEMA_NAME';