/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 vote290 views1 answer
Sql replace id with name from another table
SQL
15 votes280 views6 answers
Psql
SQL
1 vote328 views2 answers
This month mysql where
SQL
0 vote298 views1 answer
How to reset the database value in SQL server
SQL
2 votes273 views3 answers
Replace null in sql
SQL
-1 vote270 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL
1 vote270 views1 answer
How to see all table partition in oracle
SQL
4 votes277 views3 answers
Mysql varchar length
SQL
0 vote276 views1 answer
Postgressql uuid
SQL
0 vote367 views1 answer
How to check common records in 2 table
SQL