/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 vote267 views1 answer
Php get closest location by latitude longitude
SQL
0 vote275 views1 answer
Running percentage of total postgres
SQL
1 vote318 views1 answer
Best configuration for display table in sqlplus
SQL
0 vote239 views1 answer
Sql requete number pair
SQL
0 vote236 views1 answer
Duplicate foreign key constraint name
SQL
3 votes288 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
5 votes285 views3 answers
Sql server utc to local
SQL
0 vote262 views1 answer
Oracle exchange partition
SQL
0 vote248 views1 answer
Sql change default collation to utf8
SQL
1 vote253 views1 answer
Add current timestamp in mysql
SQL