The CREATE SYNONYM statement allows you to create a synonym which is an alternative name or alias name for a database object such as a table, procedure, view, sequence, stored function, and materialized view.
following is the basic syntax of creating a new synonym:
CREATE [OR REPLACE] [PUBLIC] SYNONYM schema.synonym_name FOR schema.object;
following is the basic example of creating a new synonym:
CREATE PUBLIC SYNONYM product FOR jward.products_data; After the public synonym is created, you can query the table PRODUCT_DATA with a simple SQL statement: SELECT * FROM product;