/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

3 votes149 views4 answers
Mysql delete duplicate rows
SQL
0 vote198 views1 answer
Adding generated time in row mysql workbench
SQL
2 votes192 views1 answer
Mysql Incorrect column specifier for column
SQL
3 votes185 views1 answer
Postgres kill running query
SQL
3 votes191 views1 answer
Oracle APEX elapsed time
SQL
3 votes199 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL
-1 vote194 views5 answers
Online sql to linq generator
SQL
1 vote188 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
4 votes183 views1 answer
Mysql copy table with new name
SQL
3 votes183 views2 answers
To_char oracle
SQL