/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

1 vote183 views1 answer
Sql update table remove spaces
SQL
0 vote188 views1 answer
Oracle get running queries
SQL
0 vote178 views1 answer
Update set with inner join oracle
SQL
5 votes186 views1 answer
How to check nls format in oracle
SQL
2 votes186 views1 answer
Mariadb JSON_EXTRACT
SQL
0 vote194 views1 answer
Create sql table from script inline primary key constraint
SQL
0 vote198 views1 answer
Install sql server in ubuntu 20.04
SQL
0 vote231 views1 answer
Mysql faster delete
SQL
14 votes198 views4 answers
Online sql compiler
SQL
0 vote176 views1 answer
How to search query in python3 sqlite3
SQL