/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 vote125 views1 answer
Get null value in sql
SQL
0 vote129 views1 answer
Sql cheetsheet
SQL
14 votes132 views1 answer
Sql value of string
SQL
0 vote135 views1 answer
Mysql listing get a particu particular user firsdt
SQL
0 vote135 views1 answer
Sql server python connection
SQL
2 votes121 views1 answer
Sql update from different table
SQL
2 votes132 views2 answers
Insert all in sql
SQL
0 vote120 views1 answer
Postgresql interview questions
SQL
0 vote130 views1 answer
Guid string to binary better
SQL
0 vote143 views1 answer
Play framework connection via windows sql server
SQL