/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 vote210 views1 answer
Postgresql datetrunc too slow
SQL
1 vote245 views1 answer
Mysql find most common value
SQL
0 vote217 views1 answer
Pgadmin see indexes
SQL
0 vote172 views1 answer
Oracle sql developer script output limit
SQL
0 vote219 views1 answer
Sql list dates between two dates
SQL
0 vote484 views1 answer
Create pl/sql stored procedure
SQL
14 votes209 views1 answer
Excel is not a database
SQL
0 vote218 views1 answer
Function sum(text) does not exist postgres
SQL
4 votes218 views4 answers
Oracle tablespace tables list
SQL
4 votes211 views1 answer
Mysql set max connections
SQL