If the table you want is not listed in the current database, you can navigate to other accounts and databases and select tables from those accounts.
To access other accounts in other databases:
In
the Query window, click in the Icon
Bar to display the Select Data Tables dialog box.
Click the list above the list of tables, then choose Databases.
Note: If you are unable to connect to a listed database, it may be due to an invalid link caused by a network problem or a changed remote password. Contact your database administrator for assistance.
Accessing other accounts in the current database (Query Builder)
Defining a query using Query Builder
Copyright © 1984, 2005, Oracle. All rights reserved.