Oracle create 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;

Synonym oracle

CREATE OR REPLACE PUBLIC SYNONYM suppliers FOR app.suppliers;

Similar codes

3 votes207 views2 answers
Check data in table mysql
SQL
1 vote168 views1 answer
How to select random rows from table
SQL
1 vote170 views1 answer
Pl sql insert into table
SQL
0 vote159 views1 answer
Default column value in sql same as other column
SQL
0 vote192 views2 answers
Oracle chain rules
SQL
0 vote154 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
0 vote164 views1 answer
Default value false mysql
SQL
0 vote186 views1 answer
What logs are available on RDS MySQL?
SQL
17 votes177 views6 answers
Current date in sql
SQL
8 votes171 views1 answer
How to remove tables from postgresql
SQL