/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 vote173 views1 answer
Vbscript create ADODB.Connection
SQL
11 votes194 views2 answers
How to import mysql database command line
SQL
1 vote172 views1 answer
Mysql get character set
SQL
2 votes170 views2 answers
Mysql all columns
SQL
0 vote194 views1 answer
Snowflake drop column
SQL
25 votes216 views3 answers
Mysql command show tables
SQL
0 vote212 views1 answer
Renommer schema sql
SQL
-1 vote156 views1 answer
Mysql if example
SQL
1 vote183 views1 answer
Flask sqlalchemy default value
SQL
8 votes177 views1 answer
Sql limit results returned
SQL