/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 vote129 views1 answer
How to declare variable date in mysql
SQL
0 vote135 views2 answers
What is 1=2 in sql
SQL
0 vote146 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
8 votes134 views3 answers
Connect python to mysql
SQL
1 vote120 views1 answer
Update mysql centos
SQL
0 vote132 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
0 vote139 views1 answer
Raiserror with nowait
SQL
4 votes165 views1 answer
Mysql delete last row
SQL
0 vote135 views1 answer
Kill thread
SQL
5 votes144 views1 answer
Oracle asynchronous update
SQL