Return
-
Title
Table Names additional number being added in subqueries -
Description
When modifying an existing query and adding a new subquery, table names now have _# after them. For example, ACTIVITY_2, ACTIVITYCODEDESCRIPTION_2, etc.
Each time a new subquery is added, the table name gets a number added.
When selecting the same table name for the new sub query, there are not any duplicates of the same table in any of the sub queries.
-
Cause
Oracle is very sophisticated and it may not need specific aliases for sub queries.But it's been found that this is not true for other providers and is a problem when publishing to Toad Intelligence Central.So, in TDP 4.0, unique aliases have been added to all tables in sub queries, in order to avoid any issues. -
Resolution
TDP users may assign their own alias by right clicking on the table, when adding it to the sub query, and clicking on properties if they need to.