/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

7 votes146 views2 answers
Add column table pl sql
SQL
0 vote155 views1 answer
Delete duplicate rows
SQL
0 vote200 views1 answer
Sql commands in android
SQL
0 vote134 views1 answer
Oracle DROP PROGRAM
SQL
2 votes141 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL
1 vote142 views1 answer
Sql only five first row
SQL
0 vote149 views1 answer
Oracle simple quote
SQL
0 vote142 views1 answer
Monthly Birthday SQL Query
SQL
10 votes147 views2 answers
Oracle alter sequence nextval
SQL
0 vote149 views1 answer
Null column as zero in mysql
SQL