In previous versions of Toad a query such as select col1, tab1.* from tab1 would give you col1 from tab plus all the tab1 columns. This is useful for adhoc queries in a table with a large number of columns if you want to present certain priority columns but may see the remaining columns. The duplicated column(s) would be shown with column name col1_1.
Having upgrade to Toad 18.104.22.1682 this is giving an error when there is an xmltype column on the table.
In its simplest form on a table with no data
create table tab1 (
--insert no data
select col1, col1 from tab1
But this fails
select col1, tab1.* from tab1
-- Gives error
[Error] Execution (142: 16): ORA-00904: "T"."COL1_1": invalid identifier
Is this a bug?