/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

6 votes218 views2 answers
Postgresql pg_dump
SQL
0 vote204 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL
4 votes199 views6 answers
Sql select statement
SQL
0 vote199 views1 answer
Show database not empty tables postgres
SQL
1 vote207 views1 answer
How to see logical reads in sql server
SQL
0 vote269 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
0 vote200 views1 answer
Mysql where don't have string
SQL
0 vote236 views1 answer
Delete a temporary table mysql
SQL
0 vote198 views1 answer
Left join in codeigniter query builder
SQL
0 vote272 views1 answer
Mssql describe stored procedure sqlcmd
SQL