Using Oracle 11g virtual columns Oracle virtual columns can be used in SQL*XL without problems. In Oracle 11g virtual columns can be part of tables, computed fields. To read more about virtual colums see:
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1232355973 Retrieving data from tables with virtual columns is no problem with SQL*XL. I tested it using the following providers:
ORAOLEDB - Oracle OLE DB
MSDASQL - Microsoft ODBC
OO4O - Oracle Objects for OLE
MSDAORA - Microsoft OLE DB provider for Oracle