/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 vote188 views1 answer
Tsql create unique index composite
SQL
0 vote197 views1 answer
Selecting duplicates
SQL
0 vote196 views1 answer
SQL: calculate hours from two dates
SQL
-1 vote239 views2 answers
Mysql get day of week
SQL
3 votes272 views1 answer
Apex call duration
SQL
0 vote180 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
6 votes224 views2 answers
Install psql mac
SQL
31 votes203 views4 answers
How to get duplicate records with multiple field in sql
SQL
6 votes186 views3 answers
Mysql change auto_increment start value
SQL
0 vote198 views1 answer
Change magento database url usimg musql
SQL