/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 vote275 views1 answer
Mysql current running queries
SQL
0 vote281 views4 answers
Stored procedure sql
SQL
8 votes252 views1 answer
Sql remove characters from string right
SQL
0 vote271 views1 answer
Systems sql
SQL
13 votes280 views2 answers
Sql online compiler
SQL
0 vote285 views1 answer
List all indexes postgres
SQL
1 vote269 views1 answer
Postgres set column equal to another
SQL
0 vote271 views1 answer
SQL Server Enterprise
SQL
0 vote275 views1 answer
Drop constraint in ms sql
SQL
0 vote274 views1 answer
Docker open terminal mysql server
SQL