/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 vote135 views1 answer
Mysql uuid
SQL
0 vote135 views1 answer
Grant privileges of databse to user
SQL
0 vote141 views1 answer
Create database store
SQL
1 vote141 views1 answer
Sql server list locks
SQL
0 vote139 views1 answer
Delete record by id sql
SQL
0 vote163 views1 answer
Connect laravel to mysql on mac
SQL
10 votes141 views6 answers
Between sql
SQL
2 votes146 views1 answer
Query any digits record
SQL
-1 vote154 views1 answer
How to Activate the database
SQL
0 vote147 views1 answer
Select into table variable
SQL