/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

1 vote18 views1 answer
Restart identity postgresql
SQL
0 vote54 views1 answer
Pl sql constraint user function
SQL
0 vote61 views1 answer
Mysql docker image for macbook m1
SQL
0 vote67 views1 answer
Stratified sampling sql
SQL
0 vote59 views3 answers
Fetlife
SQL
1 vote67 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
16 votes73 views1 answer
Sql comment'
SQL
0 vote64 views1 answer
List all functions and procedures in postgres query
SQL
0 vote66 views1 answer
Get employees if not contains in sql
SQL
0 vote64 views1 answer
Sql datediff month
SQL