1.

Give An Example Of Synonyms?

Answer»

CREATE PUBLIC SYNONYM SALES FOR jward.sales_data;
After the public synonym is created, you can QUERY the table SALES_DATA with a SIMPLE SQL statement:
SELECT * FROM sales;

CREATE PUBLIC SYNONYM sales FOR jward.sales_data;
After the public synonym is created, you can query the table SALES_DATA with a simple SQL statement:
SELECT * FROM sales;


Discussion

No Comment Found

Related InterviewSolutions