/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 vote244 views1 answer
Sql revert migration
SQL
0 vote282 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote252 views7 answers
Les jointures sql server
SQL
1 vote258 views1 answer
Sql how to duplicate a table
SQL
0 vote253 views1 answer
Leftjoin in sql
SQL
2 votes268 views2 answers
Postgres add column integer
SQL
0 vote304 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
0 vote253 views1 answer
Search In the Data using ObjectName
SQL
13 votes249 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL
0 vote250 views1 answer
Get week day name sql server
SQL