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

1 vote155 views3 answers
Alter schema sql server
SQL
0 vote129 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
1 vote127 views2 answers
Mssql show database size
SQL
0 vote141 views1 answer
SQL server datetime compare
SQL
4 votes140 views1 answer
Oracle show errors
SQL
1 vote186 views1 answer
Oracle datafile max size 32gb
SQL
13 votes141 views2 answers
Sql online compiler
SQL
0 vote183 views1 answer
How to compile a function in oracle
SQL
0 vote140 views1 answer
Get the First and Last Word from a String or Sentence
SQL
0 vote170 views1 answer
Create table as select sql server error
SQL