/SQL/How to get list of synonyms in oracle

How to get list of synonyms in oracle

-- Depending on connected user grants:
SELECT * FROM USER_SYNONYMS WHERE SYNONYM_NAME = 'syn_name';  -- User synonyms
SELECT * FROM ALL_SYNONYMS WHERE TABLE_NAME = 'table_name';	  -- Available to user
SELECT * FROM DBA_SYNONYMS WHERE TABLE_OWNER = 'schema_name'; -- All schemas

Source: grepper.com

Similar codes

23 votes286 views4 answers
How to uninstall postgresql in ubuntu
SQL
3 votes291 views3 answers
How to add month in update sql
SQL
0 vote295 views1 answer
Sql replace id with name from another table
SQL
16 votes311 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote247 views1 answer
Sql new line output
SQL
0 vote282 views1 answer
Limit and offset in stored procedure mssql
SQL
0 vote279 views1 answer
IS THEre any difference between using default and := in plsql
SQL
0 vote311 views1 answer
T-sql email validation
SQL
0 vote300 views1 answer
Alter table engine mysql
SQL
6 votes278 views1 answer
Update left join mysql
SQL