/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 vote243 views1 answer
Write a query to peint the pattern P(20)
SQL
1 vote246 views1 answer
SQL Integer devision
SQL
-1 vote241 views3 answers
How to restart mysql in linux
SQL
0 vote219 views1 answer
Add plugins to mysql workbench
SQL
3 votes231 views2 answers
Mysql config user password
SQL
6 votes238 views2 answers
What is non relational database
SQL
2 votes263 views3 answers
Xampp mysql database not starting
SQL
0 vote228 views1 answer
Sql character index
SQL
0 vote246 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
1 vote240 views3 answers
Nth highest salary
SQL