In a stored query, it is not immediately apparent whether a particular table has a user-defined name or its original name.
To find out if a particular table has been renamed:
If the table has been renamed, the alias name appears in the New Name: field and a different name (the original table name) in the Default Table Name: field.
SQL users can also identify renamed tables
by clicking in the Icon
Bar to display the Show SQL dialog box, where any name changes appear
in the SELECT statement in standard SQL syntax for table aliases.
Renaming a table (Query Builder)
Defining a query using Query Builder
Copyright © 1984, 2005, Oracle. All rights reserved.