After you have created a synonym, it is good practice to ensure that it can retrieve data from a data source. You can quickly test this functionality on a sample of up to 20 rows.
You can test a synonym from either the Web Console or the Data Management Console.
from the Data Management Console, expand the Server node folder.
On the Web Console, the Applications page opens.
The sample data is displayed.