/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 vote162 views1 answer
Create tables from xsd to sql server database c#
SQL
0 vote284 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL
0 vote182 views1 answer
How to check foreign key constraint in sql
SQL
0 vote151 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
0 vote140 views1 answer
Mysql use password error
SQL
92 votes1.5K views6 answers
Substring
SQL
12 votes161 views5 answers
Sql primary key
SQL
1 vote163 views2 answers
Check if word is in column sql
SQL
2 votes160 views1 answer
Oracle list grants on procedure
SQL
1 vote115 views1 answer
Import in mysql without a software
SQL