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




Posts: 75
Using Oracle interval columns
19.01.09 at 15:00:45
 
Using Oracle interval columns
 
Without problems SQL*XL can retrieve information from Oracle interval columns. There are two types of interval columns: interval year to month and interval day to second. Information from both data types can be queried using SQL*XL without problems using the following providers/drivers:
ORAOLEDB
OO4O
 
Only with the ORAOLEDB provider can interval data also be updates through the update multiple rows feature.
 
Provider MSDASQL: ODBC cannot deal with interval columns.
Provider MSDAORA : Oracle OLE DB can also not deal with interval data.
 
See also:
The Oracle interval data type  
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1232369558/0
Back to top
 
« Last Edit: 19.01.09 at 16:01:46 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Entering a new interval
Reply #1 - 19.01.09 at 15:03:43
 
Entering a new interval
 
A new interval can simply be entered as tekst for example in the update multiple rows function of SQL*XL.
 
Examples of year to month intervals:
+10-04 : plus 10 months and 4 days
-11-01 : minus 11 months and 1 day.
Back to top
 
« Last Edit: 19.01.09 at 15:04:12 by Gerrit-Jan Linker »  

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