/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

0 vote181 views1 answer
Shows all databases created by user in ms sql
SQL
0 vote173 views1 answer
Cast float mysql
SQL
0 vote164 views1 answer
Drop all tables db2
SQL
1 vote199 views2 answers
Sql select only row with the max date
SQL
4 votes116 views1 answer
Generate class from sql table c#
SQL
0 vote203 views1 answer
Mysql command line top 10
SQL
1 vote154 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
12 votes158 views4 answers
Install mysql ubuntu 18.04
SQL
1 vote163 views1 answer
How to find median of a column sql
SQL
19 votes193 views1 answer
Sqrt(-1)
SQL