/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

9 votes338 views3 answers
Mysql run sql file
SQL
2 votes323 views1 answer
Mysql application.properties spring boot
SQL
1 vote316 views1 answer
Copy postgres table from one schema into another
SQL
1 vote302 views1 answer
Sql server 2016 reseed identity
SQL
1 vote328 views1 answer
Myql find duplicates
SQL
0 vote303 views1 answer
How to print records of employees hired in particular month in oracle
SQL
0 vote297 views1 answer
Mysql terminal list table
SQL
3 votes302 views1 answer
Oracle revoke
SQL
0 vote365 views1 answer
Why do we need data structure in sql
SQL
5 votes315 views4 answers
Select random rows sql
SQL