/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

8 votes291 views1 answer
Check mysql version phpmyadmin
SQL
1 vote279 views1 answer
Select from describe sql
SQL
1 vote265 views1 answer
Add sequence postgres
SQL
0 vote300 views1 answer
Is not numeric sql
SQL
1 vote271 views1 answer
How to make a select in sql
SQL
0 vote274 views1 answer
Regex mongoose
SQL
0 vote328 views1 answer
Postgres docs /copy metacomand
SQL
0 vote288 views4 answers
User defined function sql
SQL
0 vote280 views1 answer
Create bdd mysql
SQL
0 vote296 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL