COLUMN OWNER format a20 COLUMN SYNONYM_NAME format a30 COLUMN TABLE_OWNER format a20 COLUMN TABLE_NAME format a30 COLUMN DB_LINK format a20 select * from dba_synonyms where owner like upper('&1') and synonym_name like upper('&2') order by owner,synonym_name;