Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Oracle virtual columns in SQL*XL (Read 2515 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Oracle virtual columns in SQL*XL
19.01.09 at 10:58:08
 
Oracle virtual columns in SQL*XL
 
Oracle 11g virtual columns can be used without problems in SQL*XL. Virtual columns can be included in tables to provide computed information.
 
Querying from tables with virtual columns is no problem. We tried all providers/drivers.  
 
Updating tables with virtual columns is possible. Naturally the virtual column itself cannot be updated. An error is returned when a virtual column is attempted to be updated.
 
Further reading:
Oracle virtual columns  
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1232355973
Using Oracle virtual columns  
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1232357832
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1