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;