/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 vote221 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
0 vote218 views1 answer
Excel vba import data to sql server
SQL
34 votes202 views6 answers
Install mysql client ubuntu
SQL
0 vote206 views1 answer
Turnicate in mysql
SQL
3 votes198 views2 answers
Coalesce mysql
SQL
0 vote195 views1 answer
How to define a save method in ruby for sql databases
SQL
0 vote194 views1 answer
Pl sql search in all packages
SQL
16 votes210 views4 answers
Find duplicates mysql
SQL
0 vote212 views1 answer
Order child below the parent in mysqli
SQL
0 vote209 views2 answers
Select index table oracle
SQL