/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

1 vote223 views1 answer
Nested if in mysql
SQL
0 vote222 views1 answer
How to check if there is no database schema
SQL
27 votes247 views5 answers
Add column in table
SQL
6 votes239 views4 answers
Mysql group by month
SQL
2 votes227 views2 answers
Join update query in sql
SQL
0 vote234 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
0 vote226 views1 answer
Query on date sqlite flutter
SQL
0 vote235 views4 answers
Sql server date format yyyy-mm-dd
SQL
16 votes217 views3 answers
Order by sql query
SQL
0 vote250 views2 answers
CREATE OR REPLACE FUNCTION
SQL