Oracle R Enterprise has data types that map R data types to SQL data types. In an R session, when you create database objects from R objects or you create R objects from database data, Oracle R Enterprise translates R data types to SQL data types and the reverse where possible.
Oracle R Enterprise creates objects that are instances of Oracle R Enterprise classes. Oracle R Enterprise overloads many standard R functions so that they use Oracle R Enterprise classes and data types. R language constructs and syntax are supported for objects that are mapped to Oracle Database objects.
Table 1-1 Mappings Between R, Oracle R Enterprise, and SQL Data Types
R Data Type | Oracle R Enterprise Data Type | SQL Data Type |
---|---|---|
character mode |
|
|
integer mode |
|
|
logical mode |
|
The |
numeric mode |
|
|
|
|
|
|
|
|
|
|
|
None |
Not supported |
User defined data types Reference data types |
Note:
Objects of type ore.datetime
do not support a time zone setting, instead they use the system time zone Sys.timezone
if it is available or GMT if Sys.timezone
is not available.
Related Topics