/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 vote98 views3 answers
Average salary in sql
SQL
1 vote95 views1 answer
Oracle rolling back
SQL
0 vote106 views1 answer
Print mysql
SQL
1 vote102 views1 answer
How to install mysql 8.0 windows service
SQL
12 votes98 views4 answers
Install mysql ubuntu 18.04
SQL
0 vote114 views1 answer
Character count sql
SQL
5 votes120 views6 answers
In operator sql
SQL
5 votes104 views1 answer
Oracle find foreign key dependencies
SQL
4 votes98 views1 answer
Alter session set nls_date_format
SQL
2 votes99 views1 answer
Flask sqlalchemy boolean field
SQL