/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 vote316 views1 answer
Alter column to not null with default value sql server
SQL
0 vote297 views1 answer
Sql track modification
SQL
6 votes315 views2 answers
Mysql interval 1 day
SQL
1 vote312 views1 answer
Load mysql dumb
SQL
1 vote299 views2 answers
Mysql error 1215
SQL
18 votes279 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL
0 vote338 views1 answer
Cartesian product sql
SQL
1 vote303 views1 answer
Pagination sql
SQL
2 votes281 views2 answers
Insert all in sql
SQL
0 vote280 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL