Oracle synonym

-- Can be a table, package, procedure...
CREATE OR REPLACE SYNONYM syn_name FOR my_schema.my_table;      
CREATE OR REPLACE PUBLIC SYNONYM syn_name FOR my_schema.my_table;

-- Through a dblink:
CREATE OR REPLACE SYNONYM syn_name FOR my_schema.my_table@my_dblink;

SELECT * FROM DBA_SYNONYMS WHERE SYNONYM_NAME = 'synonym_name';

Synonym oracle

CREATE OR REPLACE PUBLIC SYNONYM suppliers FOR app.suppliers;

Similar codes

7 votes185 views3 answers
How ot change name of column mysql
SQL
0 vote185 views1 answer
Sql last time database was accessed
SQL
0 vote175 views1 answer
Android sqlite add column if not exists
SQL
0 vote163 views1 answer
Sql value exists in column
SQL
0 vote182 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
0 vote181 views1 answer
Oracle procedure teamplate
SQL
2 votes171 views1 answer
Oracle apex list connected users
SQL
12 votes172 views1 answer
Docker mysql random root password
SQL
1 vote197 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
103 votes288 views1 answer
Like sql
SQL