/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

2 votes346 views2 answers
Sqlalchemy filter or
SQL
0 vote322 views1 answer
Get last updated row sql server
SQL
0 vote336 views1 answer
Const pool = mysql.createpool()
SQL
1 vote323 views1 answer
Oracle rolling back
SQL
34 votes325 views6 answers
Sql change data type
SQL
0 vote327 views1 answer
Php get closest location by latitude longitude
SQL
0 vote362 views1 answer
Typical max-connect-errors mysql
SQL
3 votes371 views2 answers
Update part of a string in mysql
SQL
0 vote382 views1 answer
Laravel SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = testDB and table_name = migrations and table_type = 'BASE TABLE')
SQL
7 votes322 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL