/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

4 votes141 views1 answer
Ms sql truncate table vs delete
SQL
1 vote156 views1 answer
Apex run 404
SQL
0 vote124 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
1 vote121 views1 answer
Show per page table in xampp
SQL
150 votes280 views10 answers
Grepper
SQL
0 vote113 views1 answer
See the structure of a table mysql
SQL
5 votes141 views2 answers
Postgresql add not null constraint
SQL
-1 vote121 views1 answer
Sql select data from one database and insert into a different database
SQL
0 vote68 views1 answer
How to set field to null in sql
SQL
4 votes118 views2 answers
Oracle drop job
SQL