Synonym oracle

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

9 votes355 views3 answers
Find all tables with column name
SQL
2 votes339 views1 answer
Oracle generated column
SQL
0 vote330 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
6 votes346 views2 answers
Difference between join vs union
SQL
8 votes341 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
0 vote342 views1 answer
Update sql sintax
SQL
0 vote282 views1 answer
Create bakupd database sqlserver
SQL
1 vote332 views1 answer
Drop function
SQL
11 votes317 views4 answers
Round in sql
SQL
1 vote282 views2 answers
OSError: mysql_config not found mysql_config --version mariadb_config --version mysql_config --libs ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command outpu
SQL