/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 vote200 views1 answer
Sql values that contains certain multiple ids
SQL
10 votes167 views2 answers
Sql where clause multiple values
SQL
3 votes216 views1 answer
Oracle undo tablespace schema
SQL
-1 vote200 views1 answer
Ssql to lowercqse
SQL
1 vote272 views1 answer
Error cs1061 'dbcontextoptionsbuilder' does not contain a definition for 'usesqlserver'
SQL
0 vote234 views1 answer
Use mysql in java program
SQL
0 vote255 views1 answer
Select count concat string sql server
SQL
13 votes195 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote206 views1 answer
Mod in sql
SQL
0 vote238 views1 answer
Mysql 3 months ago
SQL