/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 vote110 views1 answer
Get only one row in mysql
SQL
0 vote115 views2 answers
How to display enum value sql server
SQL
0 vote103 views1 answer
What is between keyword used for
SQL
0 vote118 views1 answer
SQL Error 1040 : Too many connections
SQL
0 vote105 views1 answer
What is between operator
SQL
0 vote111 views1 answer
Oracle enable chain
SQL
14 votes107 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
0 vote101 views2 answers
Show slave status mysql
SQL
-1 vote121 views1 answer
Pl sql drop trigger
SQL
0 vote115 views1 answer
Sub query in linq
SQL