/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 vote175 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
6 votes169 views1 answer
Wordpress change user password sql
SQL
0 vote161 views1 answer
Stop psql server windows
SQL
19 votes194 views5 answers
Display table in sql
SQL
1 vote178 views1 answer
Raise application error in oracle
SQL
0 vote187 views1 answer
Oracle sql copy table without data
SQL
0 vote164 views1 answer
Rabbitmq ui not working
SQL
0 vote168 views1 answer
Mysql add to value
SQL
0 vote180 views1 answer
How convert into in in sql query
SQL
3 votes208 views2 answers
@sqlresultsetmapping
SQL