|
Pivot
|
Condition
|
Datatype
|
|---|---|---|
|
P-AutoIdentifier
|
|
NUMBER
|
|
P-Binary
|
|
RAW(@L)
|
|
P-Boolean
|
L<2 or L ø
|
RAW(1)
|
|
L>1
|
RAW(@L)
|
|
|
P-Byte
|
|
RAW(1)
|
|
P-Character
|
Not Unicode and (L<2001 or L ø)
|
CHAR(@L)
|
|
L>4000
|
LONG
|
|
|
Unicode and (L<2001 or L ø)
|
NCHAR(@L)
|
|
|
Unicode and 2000<L<4001
|
NVARCHAR2(@L)
|
|
|
Not Unicode and 2000<L<4001
|
VARCHAR2(@L)
|
|
|
P-Currency
|
|
NUMBER(@L,@D)
|
|
P-Date
|
|
DATE
|
|
P-Datetime
|
|
DATE
|
|
P-Decimal
|
|
NUMBER(@L,@D)
|
|
P-Double
|
|
NUMBER(@L,@D)
|
|
P-Float
|
0<L<127
|
FLOAT(@L)
|
|
L=0 or L>126 or L ø
|
FLOAT
|
|
|
P-Integer
|
|
NUMBER(@L)
|
|
P-Long Integer
|
|
NUMBER(@L)
|
|
P-Long Real
|
|
NUMBER(@L,@D)
|
|
P-Numeric
|
L=0 or L ø
|
NUMBER
|
|
L>0 and D ø
|
NUMBER(@L)
|
|
|
L>0 and D not ø
|
NUMBER(@L,@D)
|
|
|
P-Real
|
|
NUMBER(@L,@D)
|
|
P-Smallint
|
|
NUMBER(@L)
|
|
P-String
|
|
LONG
|
|
P-Text
|
Unicode
|
NVARCHAR2(@L)
|
|
Not Unicode
|
VARCHAR2(@L)
|
|
|
P-Time
|
|
DATE
|
|
P-Timestamp
|
L<10
|
TIMESTAMP(@L)
|
|
L>9 or L ø
|
TIMESTAMP
|
|
|
P-Tinyint
|
|
NUMBER(@L)
|
|
P-Varchar
|
L>4000 or L=0 or L ø
|
LONG
|
|
Unicode and 0<L<4001
|
NVARCHAR2(@L)
|
|
|
Not Unicode and 0<L<4001
|
VARCHAR2(@L)
|
|
Datatype
|
Condition
|
Pivot
|
|---|---|---|
|
CHAR(L)
|
|
P-Character
|
|
DATE
|
|
P-Date
|
|
FLOAT
|
|
P-Float
|
|
FLOAT(L)
|
|
P-Float
|
|
LONG
|
|
P-String
|
|
NUMBER
|
|
P-Numeric
|
|
NUMBER(L)
|
|
P-Numeric
|
|
NUMBER(L,D)
|
|
P-Numeric
|
|
RAW(1)
|
|
P-Boolean
|
|
RAW(L)
|
|
P-Boolean
|
|
TIMESTAMP
|
|
P-Timestamp
|
|
TIMESTAMP(L)
|
|
P-Timestamp
|
|
VARCHAR2(L)
|
|
P-Varchar
|