/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 vote176 views1 answer
Create relationship with betwen two tables in postgersql
SQL
1 vote168 views1 answer
Postgres format date in select
SQL
1 vote188 views1 answer
Create sqlite database in laravel
SQL
0 vote183 views1 answer
Sql insert query list of dictionaries
SQL
10 votes165 views3 answers
How to fetch first 5 characters in sql
SQL
10 votes150 views3 answers
Join multiple tables sql
SQL
0 vote161 views1 answer
Postgresql print sessions using the database
SQL
0 vote199 views1 answer
Mysql show schema
SQL
0 vote171 views1 answer
Check if a column is a primary key in sql server
SQL
0 vote131 views2 answers
Postgresql display subquery as json
SQL