For details about the type attribute for <column> elements. The supported types are mapped as follows:
|
Column type |
Oracle type |
SQL server type |
|---|---|---|
|
id |
NUMBER |
BIGINT |
|
text |
VARCHAR2 |
NVARCHAR() |
|
numeric |
NUMBER |
BIGINT |
|
date |
DATE |
DATETIME |
|
timestamp |
DATE |
DATETIME |
|
icon |
VARCHAR2 |
NVARCHAR() |
|
list |
VARCHAR2 |
NVARCHAR() |
|
link |
VARCHAR2 |
NVARCHAR() |
|
quantity |
NUMBER |
BIGINT |
|
boolean |
PLS_INTEGER |
BIT |
|
real |
NUMBER(38,n) |
REAL |
|
Copyright © 2014 CA.
All rights reserved.
|
|