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 vote194 views1 answer
Postgresql create table with timestamp
SQL
0 vote180 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
16 votes198 views5 answers
Select last row in sql
SQL
0 vote196 views1 answer
Sql last time database was accessed
SQL
0 vote172 views1 answer
Create function syntax sql server
SQL
0 vote201 views1 answer
Insert data from stored procedure into table
SQL
0 vote207 views1 answer
Netstat -tln mysql
SQL
1 vote194 views1 answer
Spark sql concatenate string and int
SQL
0 vote167 views1 answer
Declaring variables in pl sql
SQL
4 votes177 views4 answers
Sqlite describe table
SQL