/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

8 votes369 views1 answer
How to check mysql version in xampp
SQL
1 vote363 views1 answer
Mysql check string don't have number
SQL
1 vote372 views3 answers
Rename table snowflake
SQL
0 vote375 views2 answers
Sql having multiple conditions
SQL
0 vote346 views1 answer
Zerar auto increment mysql
SQL
1 vote322 views1 answer
Update from select join
SQL
2 votes338 views1 answer
Mysql find tables with name
SQL
1 vote372 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
0 vote334 views2 answers
Php convert dbf to mysql
SQL
0 vote348 views1 answer
Query archive mode
SQL