I have a table with an XMLTYPE column and it contains 3 others virtual columns which use an xmlquery operation on the xmltype column.
I am unable to export the dataset of query to insert format, however both CLOB and XMLTYPE are unchecked and Virtual cols is checked in "Columns to exclude" list. Toad shows the following popup: "All columns were excluded from table XLS_STYLES. There is nothing to export from this table. "
If I use an alias what differs from the original name of xmltype column then Toad generates the Insert statements.