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

0 vote355 views1 answer
Copied text from internet not inserting in mysql
SQL
0 vote358 views1 answer
Get number of rows in every table mysql
SQL
0 vote387 views1 answer
Sql delete caracter list
SQL
0 vote361 views2 answers
Call to undefined function mysqli_fetch_all()
SQL
2 votes346 views3 answers
Write sql query to find the second highest salary of employee
SQL
0 vote353 views1 answer
Mysql shell set time_zone
SQL
0 vote316 views1 answer
Query for maximum salary
SQL
0 vote391 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
0 vote338 views1 answer
First mysql
SQL
0 vote392 views1 answer
Mysql last 6 months
SQL