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 interval columns (Read 3575 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Oracle interval columns
19.01.09 at 16:07:33
 
Oracle interval columns
 
Using the ORAOLEDB provider/driver, SQL*XL can work fine with columns in Oracle of the data type interval. OO4O can also deal with interval data. A small code change was needed in SQL*XL to allow querying interval data through the OO4O driver. Unfortunately the OO4O driver cannot be used to alter values using the multiple rows update feature.
 
The recommendation is therefore that you use the ORAOLEDB provider: the Oracle OLE DB provider, when working with interval data. SQL*XL can query and update information using this driver.
 
See also:
Using Oracle interval columns  
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1232373646/0
The Oracle interval data type  
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1232369558/0
Back to top
 
 

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