/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 vote253 views1 answer
Zsh-syntax-highlighting zsh-autosuggestions
SQL
9 votes249 views3 answers
Pyodbc connect to sql server
SQL
0 vote197 views1 answer
Sql contains vs like
SQL
0 vote215 views1 answer
Compare field sql server
SQL
1 vote201 views1 answer
Group_concat max length mysql
SQL
0 vote216 views1 answer
Intellij idea add mysql connector
SQL
13 votes200 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
34 votes252 views6 answers
Alter table add foreign key mysql
SQL
4 votes202 views1 answer
Group by mysql and concatenate string
SQL
0 vote221 views1 answer
Group by 15 minute interval sql server
SQL