# org.apache.hop.databases.oracle.OracleDatabaseMeta
# Generated by OracleFieldDefinitionGoldenTest. Do not hand-edit.
# Records current behaviour including known bugs. See the class javadoc.

[plain]
STRING       len=      -1 prec=  -1 -        -> VARCHAR2(2000)
STRING       len=       0 prec=   0 -        -> VARCHAR2(2000)
STRING       len=       4 prec=   0 -        -> VARCHAR2(4)
STRING       len=       9 prec=   0 -        -> VARCHAR2(9)
STRING       len=      10 prec=   2 -        -> VARCHAR2(10)
STRING       len=      15 prec=   0 -        -> VARCHAR2(15)
STRING       len=      18 prec=   0 -        -> VARCHAR2(18)
STRING       len=      20 prec=   0 -        -> VARCHAR2(20)
STRING       len= 9999999 prec=   0 -        -> CLOB
INTEGER      len=      -1 prec=  -1 -        -> INTEGER
INTEGER      len=       0 prec=   0 -        -> INTEGER
INTEGER      len=       4 prec=   0 -        -> INTEGER
INTEGER      len=       9 prec=   0 -        -> INTEGER
INTEGER      len=      10 prec=   2 -        -> INTEGER
INTEGER      len=      15 prec=   0 -        -> INTEGER
INTEGER      len=      18 prec=   0 -        -> INTEGER
INTEGER      len=      20 prec=   0 -        -> INTEGER
INTEGER      len= 9999999 prec=   0 -        -> INTEGER
NUMBER       len=      -1 prec=  -1 -        -> NUMBER
NUMBER       len=       0 prec=   0 -        -> NUMBER
NUMBER       len=       4 prec=   0 -        -> NUMBER(4)
NUMBER       len=       9 prec=   0 -        -> NUMBER(9)
NUMBER       len=      10 prec=   2 -        -> NUMBER(10, 2)
NUMBER       len=      15 prec=   0 -        -> NUMBER(15)
NUMBER       len=      18 prec=   0 -        -> NUMBER(18)
NUMBER       len=      20 prec=   0 -        -> NUMBER(20)
NUMBER       len= 9999999 prec=   0 -        -> NUMBER(9999999)
BIGNUMBER    len=      -1 prec=  -1 -        -> NUMBER
BIGNUMBER    len=       0 prec=   0 -        -> NUMBER
BIGNUMBER    len=       4 prec=   0 -        -> NUMBER(4)
BIGNUMBER    len=       9 prec=   0 -        -> NUMBER(9)
BIGNUMBER    len=      10 prec=   2 -        -> NUMBER(10, 2)
BIGNUMBER    len=      15 prec=   0 -        -> NUMBER(15)
BIGNUMBER    len=      18 prec=   0 -        -> NUMBER(18)
BIGNUMBER    len=      20 prec=   0 -        -> NUMBER(20)
BIGNUMBER    len= 9999999 prec=   0 -        -> NUMBER(9999999)
DATE         len=      -1 prec=  -1 -        -> DATE
DATE         len=       0 prec=   0 -        -> DATE
DATE         len=       4 prec=   0 -        -> DATE
DATE         len=       9 prec=   0 -        -> DATE
DATE         len=      10 prec=   2 -        -> DATE
DATE         len=      15 prec=   0 -        -> DATE
DATE         len=      18 prec=   0 -        -> DATE
DATE         len=      20 prec=   0 -        -> DATE
DATE         len= 9999999 prec=   0 -        -> DATE
TIMESTAMP    len=      -1 prec=  -1 -        -> DATE
TIMESTAMP    len=       0 prec=   0 -        -> DATE
TIMESTAMP    len=       4 prec=   0 -        -> DATE
TIMESTAMP    len=       9 prec=   0 -        -> DATE
TIMESTAMP    len=      10 prec=   2 -        -> DATE
TIMESTAMP    len=      15 prec=   0 -        -> DATE
TIMESTAMP    len=      18 prec=   0 -        -> DATE
TIMESTAMP    len=      20 prec=   0 -        -> DATE
TIMESTAMP    len= 9999999 prec=   0 -        -> DATE
BOOLEAN      len=      -1 prec=  -1 -        -> CHAR(1)
BOOLEAN      len=       0 prec=   0 -        -> CHAR(1)
BOOLEAN      len=       4 prec=   0 -        -> CHAR(1)
BOOLEAN      len=       9 prec=   0 -        -> CHAR(1)
BOOLEAN      len=      10 prec=   2 -        -> CHAR(1)
BOOLEAN      len=      15 prec=   0 -        -> CHAR(1)
BOOLEAN      len=      18 prec=   0 -        -> CHAR(1)
BOOLEAN      len=      20 prec=   0 -        -> CHAR(1)
BOOLEAN      len= 9999999 prec=   0 -        -> CHAR(1)
BINARY       len=      -1 prec=  -1 -        -> BLOB
BINARY       len=       0 prec=   0 -        -> BLOB
BINARY       len=       4 prec=   0 -        -> BLOB
BINARY       len=       9 prec=   0 -        -> BLOB
BINARY       len=      10 prec=   2 -        -> BLOB
BINARY       len=      15 prec=   0 -        -> BLOB
BINARY       len=      18 prec=   0 -        -> BLOB
BINARY       len=      20 prec=   0 -        -> BLOB
BINARY       len= 9999999 prec=   0 -        -> BLOB
INET         len=      -1 prec=  -1 -        -> VARCHAR2(45)
INET         len=       0 prec=   0 -        -> VARCHAR2(45)
INET         len=       4 prec=   0 -        -> VARCHAR2(45)
INET         len=       9 prec=   0 -        -> VARCHAR2(45)
INET         len=      10 prec=   2 -        -> VARCHAR2(45)
INET         len=      15 prec=   0 -        -> VARCHAR2(45)
INET         len=      18 prec=   0 -        -> VARCHAR2(45)
INET         len=      20 prec=   0 -        -> VARCHAR2(45)
INET         len= 9999999 prec=   0 -        -> VARCHAR2(45)
JSON         len=      -1 prec=  -1 -        -> JSON
JSON         len=       0 prec=   0 -        -> JSON
JSON         len=       4 prec=   0 -        -> JSON
JSON         len=       9 prec=   0 -        -> JSON
JSON         len=      10 prec=   2 -        -> JSON
JSON         len=      15 prec=   0 -        -> JSON
JSON         len=      18 prec=   0 -        -> JSON
JSON         len=      20 prec=   0 -        -> JSON
JSON         len= 9999999 prec=   0 -        -> JSON
VECTOR       len=      -1 prec=  -1 -        -> VECTOR(*, *)
VECTOR       len=       0 prec=   0 -        -> VECTOR(*, *)
VECTOR       len=       4 prec=   0 -        -> VECTOR(4, FLOAT32)
VECTOR       len=       9 prec=   0 -        -> VECTOR(9, FLOAT32)
VECTOR       len=      10 prec=   2 -        -> VECTOR(10, FLOAT32)
VECTOR       len=      15 prec=   0 -        -> VECTOR(15, FLOAT32)
VECTOR       len=      18 prec=   0 -        -> VECTOR(18, FLOAT32)
VECTOR       len=      20 prec=   0 -        -> VECTOR(20, FLOAT32)
VECTOR       len= 9999999 prec=   0 -        -> VECTOR(9999999, FLOAT32)

[strings]
STRING       len=     254 prec=   0 -        -> VARCHAR2(254)
STRING       len=     255 prec=   0 -        -> VARCHAR2(255)
STRING       len=     256 prec=   0 -        -> VARCHAR2(256)
STRING       len=    1999 prec=   0 -        -> VARCHAR2(1999)
STRING       len=    2000 prec=   0 -        -> VARCHAR2(2000)
STRING       len=    2001 prec=   0 -        -> CLOB
STRING       len=    3999 prec=   0 -        -> CLOB
STRING       len=    4000 prec=   0 -        -> CLOB
STRING       len=    4001 prec=   0 -        -> CLOB
STRING       len=    7999 prec=   0 -        -> CLOB
STRING       len=    8000 prec=   0 -        -> CLOB
STRING       len=    8001 prec=   0 -        -> CLOB
STRING       len=   21843 prec=   0 -        -> CLOB
STRING       len=   21844 prec=   0 -        -> CLOB
STRING       len=   32663 prec=   0 -        -> CLOB
STRING       len=   32664 prec=   0 -        -> CLOB
STRING       len=   32671 prec=   0 -        -> CLOB
STRING       len=   32672 prec=   0 -        -> CLOB
STRING       len=   32699 prec=   0 -        -> CLOB
STRING       len=   32700 prec=   0 -        -> CLOB
STRING       len=   32719 prec=   0 -        -> CLOB
STRING       len=   32720 prec=   0 -        -> CLOB
STRING       len=   32766 prec=   0 -        -> CLOB
STRING       len=   32767 prec=   0 -        -> CLOB
STRING       len=   32768 prec=   0 -        -> CLOB
STRING       len=   65532 prec=   0 -        -> CLOB
STRING       len=   65533 prec=   0 -        -> CLOB
STRING       len=   65534 prec=   0 -        -> CLOB
STRING       len=   65535 prec=   0 -        -> CLOB
STRING       len=   65536 prec=   0 -        -> CLOB
STRING       len= 1999999 prec=   0 -        -> CLOB
STRING       len= 2000000 prec=   0 -        -> CLOB
STRING       len= 2000001 prec=   0 -        -> CLOB
STRING       len= 9999998 prec=   0 -        -> CLOB
STRING       len= 9999999 prec=   0 -        -> CLOB
STRING       len=10000000 prec=   0 -        -> CLOB
STRING       len=16777215 prec=   0 -        -> CLOB
STRING       len=16777216 prec=   0 -        -> CLOB

[keys]
INTEGER      len=      -1 prec=  -1 tk       -> INTEGER
INTEGER      len=      -1 prec=  -1 pk       -> INTEGER
INTEGER      len=      -1 prec=  -1 autoinc  -> INTEGER
INTEGER      len=       0 prec=   0 tk       -> INTEGER
INTEGER      len=       0 prec=   0 pk       -> INTEGER
INTEGER      len=       0 prec=   0 autoinc  -> INTEGER
INTEGER      len=       4 prec=   0 tk       -> INTEGER
INTEGER      len=       4 prec=   0 pk       -> INTEGER
INTEGER      len=       4 prec=   0 autoinc  -> INTEGER
INTEGER      len=       9 prec=   0 tk       -> INTEGER
INTEGER      len=       9 prec=   0 pk       -> INTEGER
INTEGER      len=       9 prec=   0 autoinc  -> INTEGER
INTEGER      len=      10 prec=   2 tk       -> INTEGER
INTEGER      len=      10 prec=   2 pk       -> INTEGER
INTEGER      len=      10 prec=   2 autoinc  -> INTEGER
INTEGER      len=      15 prec=   0 tk       -> INTEGER
INTEGER      len=      15 prec=   0 pk       -> INTEGER
INTEGER      len=      15 prec=   0 autoinc  -> INTEGER
INTEGER      len=      18 prec=   0 tk       -> INTEGER
INTEGER      len=      18 prec=   0 pk       -> INTEGER
INTEGER      len=      18 prec=   0 autoinc  -> INTEGER
INTEGER      len=      20 prec=   0 tk       -> INTEGER
INTEGER      len=      20 prec=   0 pk       -> INTEGER
INTEGER      len=      20 prec=   0 autoinc  -> INTEGER
INTEGER      len= 9999999 prec=   0 tk       -> INTEGER
INTEGER      len= 9999999 prec=   0 pk       -> INTEGER
INTEGER      len= 9999999 prec=   0 autoinc  -> INTEGER
NUMBER       len=      -1 prec=  -1 tk       -> NUMBER
NUMBER       len=      -1 prec=  -1 pk       -> NUMBER
NUMBER       len=      -1 prec=  -1 autoinc  -> NUMBER
NUMBER       len=       0 prec=   0 tk       -> NUMBER
NUMBER       len=       0 prec=   0 pk       -> NUMBER
NUMBER       len=       0 prec=   0 autoinc  -> NUMBER
NUMBER       len=       4 prec=   0 tk       -> NUMBER(4)
NUMBER       len=       4 prec=   0 pk       -> NUMBER(4)
NUMBER       len=       4 prec=   0 autoinc  -> NUMBER(4)
NUMBER       len=       9 prec=   0 tk       -> NUMBER(9)
NUMBER       len=       9 prec=   0 pk       -> NUMBER(9)
NUMBER       len=       9 prec=   0 autoinc  -> NUMBER(9)
NUMBER       len=      10 prec=   2 tk       -> NUMBER(10, 2)
NUMBER       len=      10 prec=   2 pk       -> NUMBER(10, 2)
NUMBER       len=      10 prec=   2 autoinc  -> NUMBER(10, 2)
NUMBER       len=      15 prec=   0 tk       -> NUMBER(15)
NUMBER       len=      15 prec=   0 pk       -> NUMBER(15)
NUMBER       len=      15 prec=   0 autoinc  -> NUMBER(15)
NUMBER       len=      18 prec=   0 tk       -> NUMBER(18)
NUMBER       len=      18 prec=   0 pk       -> NUMBER(18)
NUMBER       len=      18 prec=   0 autoinc  -> NUMBER(18)
NUMBER       len=      20 prec=   0 tk       -> NUMBER(20)
NUMBER       len=      20 prec=   0 pk       -> NUMBER(20)
NUMBER       len=      20 prec=   0 autoinc  -> NUMBER(20)
NUMBER       len= 9999999 prec=   0 tk       -> NUMBER(9999999)
NUMBER       len= 9999999 prec=   0 pk       -> NUMBER(9999999)
NUMBER       len= 9999999 prec=   0 autoinc  -> NUMBER(9999999)
BIGNUMBER    len=      -1 prec=  -1 tk       -> NUMBER
BIGNUMBER    len=      -1 prec=  -1 pk       -> NUMBER
BIGNUMBER    len=      -1 prec=  -1 autoinc  -> NUMBER
BIGNUMBER    len=       0 prec=   0 tk       -> NUMBER
BIGNUMBER    len=       0 prec=   0 pk       -> NUMBER
BIGNUMBER    len=       0 prec=   0 autoinc  -> NUMBER
BIGNUMBER    len=       4 prec=   0 tk       -> NUMBER(4)
BIGNUMBER    len=       4 prec=   0 pk       -> NUMBER(4)
BIGNUMBER    len=       4 prec=   0 autoinc  -> NUMBER(4)
BIGNUMBER    len=       9 prec=   0 tk       -> NUMBER(9)
BIGNUMBER    len=       9 prec=   0 pk       -> NUMBER(9)
BIGNUMBER    len=       9 prec=   0 autoinc  -> NUMBER(9)
BIGNUMBER    len=      10 prec=   2 tk       -> NUMBER(10, 2)
BIGNUMBER    len=      10 prec=   2 pk       -> NUMBER(10, 2)
BIGNUMBER    len=      10 prec=   2 autoinc  -> NUMBER(10, 2)
BIGNUMBER    len=      15 prec=   0 tk       -> NUMBER(15)
BIGNUMBER    len=      15 prec=   0 pk       -> NUMBER(15)
BIGNUMBER    len=      15 prec=   0 autoinc  -> NUMBER(15)
BIGNUMBER    len=      18 prec=   0 tk       -> NUMBER(18)
BIGNUMBER    len=      18 prec=   0 pk       -> NUMBER(18)
BIGNUMBER    len=      18 prec=   0 autoinc  -> NUMBER(18)
BIGNUMBER    len=      20 prec=   0 tk       -> NUMBER(20)
BIGNUMBER    len=      20 prec=   0 pk       -> NUMBER(20)
BIGNUMBER    len=      20 prec=   0 autoinc  -> NUMBER(20)
BIGNUMBER    len= 9999999 prec=   0 tk       -> NUMBER(9999999)
BIGNUMBER    len= 9999999 prec=   0 pk       -> NUMBER(9999999)
BIGNUMBER    len= 9999999 prec=   0 autoinc  -> NUMBER(9999999)

[alter]
STRING       len=      -1 prec=  -1 add      -> ALTER TABLE TBL ADD ( COL VARCHAR2(2000) )
STRING       len=      -1 prec=  -1 modify   -> ALTER TABLE TBL ADD ( COL_KTL VARCHAR2(2000) ) ; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP ( COL ) ; ALTER TABLE TBL ADD ( COL VARCHAR2(2000) ) ; UPDATE TBL SET COL=COL_KTL; ALTER TABLE TBL DROP ( COL_KTL )
STRING       len=      10 prec=   2 add      -> ALTER TABLE TBL ADD ( COL VARCHAR2(10) )
STRING       len=      10 prec=   2 modify   -> ALTER TABLE TBL ADD ( COL_KTL VARCHAR2(10) ) ; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP ( COL ) ; ALTER TABLE TBL ADD ( COL VARCHAR2(10) ) ; UPDATE TBL SET COL=COL_KTL; ALTER TABLE TBL DROP ( COL_KTL )
STRING       len=      15 prec=   0 add      -> ALTER TABLE TBL ADD ( COL VARCHAR2(15) )
STRING       len=      15 prec=   0 modify   -> ALTER TABLE TBL ADD ( COL_KTL VARCHAR2(15) ) ; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP ( COL ) ; ALTER TABLE TBL ADD ( COL VARCHAR2(15) ) ; UPDATE TBL SET COL=COL_KTL; ALTER TABLE TBL DROP ( COL_KTL )
INTEGER      len=      -1 prec=  -1 add      -> ALTER TABLE TBL ADD ( COL INTEGER )
INTEGER      len=      -1 prec=  -1 modify   -> ALTER TABLE TBL ADD ( COL_KTL INTEGER ) ; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP ( COL ) ; ALTER TABLE TBL ADD ( COL INTEGER ) ; UPDATE TBL SET COL=COL_KTL; ALTER TABLE TBL DROP ( COL_KTL )
INTEGER      len=      10 prec=   2 add      -> ALTER TABLE TBL ADD ( COL INTEGER )
INTEGER      len=      10 prec=   2 modify   -> ALTER TABLE TBL ADD ( COL_KTL INTEGER ) ; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP ( COL ) ; ALTER TABLE TBL ADD ( COL INTEGER ) ; UPDATE TBL SET COL=COL_KTL; ALTER TABLE TBL DROP ( COL_KTL )
INTEGER      len=      15 prec=   0 add      -> ALTER TABLE TBL ADD ( COL INTEGER )
INTEGER      len=      15 prec=   0 modify   -> ALTER TABLE TBL ADD ( COL_KTL INTEGER ) ; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP ( COL ) ; ALTER TABLE TBL ADD ( COL INTEGER ) ; UPDATE TBL SET COL=COL_KTL; ALTER TABLE TBL DROP ( COL_KTL )
NUMBER       len=      -1 prec=  -1 add      -> ALTER TABLE TBL ADD ( COL NUMBER )
NUMBER       len=      -1 prec=  -1 modify   -> ALTER TABLE TBL ADD ( COL_KTL NUMBER ) ; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP ( COL ) ; ALTER TABLE TBL ADD ( COL NUMBER ) ; UPDATE TBL SET COL=COL_KTL; ALTER TABLE TBL DROP ( COL_KTL )
NUMBER       len=      10 prec=   2 add      -> ALTER TABLE TBL ADD ( COL NUMBER(10, 2) )
NUMBER       len=      10 prec=   2 modify   -> ALTER TABLE TBL ADD ( COL_KTL NUMBER(10, 2) ) ; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP ( COL ) ; ALTER TABLE TBL ADD ( COL NUMBER(10, 2) ) ; UPDATE TBL SET COL=COL_KTL; ALTER TABLE TBL DROP ( COL_KTL )
NUMBER       len=      15 prec=   0 add      -> ALTER TABLE TBL ADD ( COL NUMBER(15) )
NUMBER       len=      15 prec=   0 modify   -> ALTER TABLE TBL ADD ( COL_KTL NUMBER(15) ) ; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP ( COL ) ; ALTER TABLE TBL ADD ( COL NUMBER(15) ) ; UPDATE TBL SET COL=COL_KTL; ALTER TABLE TBL DROP ( COL_KTL )
BIGNUMBER    len=      -1 prec=  -1 add      -> ALTER TABLE TBL ADD ( COL NUMBER )
BIGNUMBER    len=      -1 prec=  -1 modify   -> ALTER TABLE TBL ADD ( COL_KTL NUMBER ) ; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP ( COL ) ; ALTER TABLE TBL ADD ( COL NUMBER ) ; UPDATE TBL SET COL=COL_KTL; ALTER TABLE TBL DROP ( COL_KTL )
BIGNUMBER    len=      10 prec=   2 add      -> ALTER TABLE TBL ADD ( COL NUMBER(10, 2) )
BIGNUMBER    len=      10 prec=   2 modify   -> ALTER TABLE TBL ADD ( COL_KTL NUMBER(10, 2) ) ; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP ( COL ) ; ALTER TABLE TBL ADD ( COL NUMBER(10, 2) ) ; UPDATE TBL SET COL=COL_KTL; ALTER TABLE TBL DROP ( COL_KTL )
BIGNUMBER    len=      15 prec=   0 add      -> ALTER TABLE TBL ADD ( COL NUMBER(15) )
BIGNUMBER    len=      15 prec=   0 modify   -> ALTER TABLE TBL ADD ( COL_KTL NUMBER(15) ) ; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP ( COL ) ; ALTER TABLE TBL ADD ( COL NUMBER(15) ) ; UPDATE TBL SET COL=COL_KTL; ALTER TABLE TBL DROP ( COL_KTL )
DATE         len=      -1 prec=  -1 add      -> ALTER TABLE TBL ADD ( COL DATE )
DATE         len=      -1 prec=  -1 modify   -> ALTER TABLE TBL ADD ( COL_KTL DATE ) ; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP ( COL ) ; ALTER TABLE TBL ADD ( COL DATE ) ; UPDATE TBL SET COL=COL_KTL; ALTER TABLE TBL DROP ( COL_KTL )
DATE         len=      10 prec=   2 add      -> ALTER TABLE TBL ADD ( COL DATE )
DATE         len=      10 prec=   2 modify   -> ALTER TABLE TBL ADD ( COL_KTL DATE ) ; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP ( COL ) ; ALTER TABLE TBL ADD ( COL DATE ) ; UPDATE TBL SET COL=COL_KTL; ALTER TABLE TBL DROP ( COL_KTL )
DATE         len=      15 prec=   0 add      -> ALTER TABLE TBL ADD ( COL DATE )
DATE         len=      15 prec=   0 modify   -> ALTER TABLE TBL ADD ( COL_KTL DATE ) ; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP ( COL ) ; ALTER TABLE TBL ADD ( COL DATE ) ; UPDATE TBL SET COL=COL_KTL; ALTER TABLE TBL DROP ( COL_KTL )
TIMESTAMP    len=      -1 prec=  -1 add      -> ALTER TABLE TBL ADD ( COL DATE )
TIMESTAMP    len=      -1 prec=  -1 modify   -> ALTER TABLE TBL ADD ( COL_KTL DATE ) ; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP ( COL ) ; ALTER TABLE TBL ADD ( COL DATE ) ; UPDATE TBL SET COL=COL_KTL; ALTER TABLE TBL DROP ( COL_KTL )
TIMESTAMP    len=      10 prec=   2 add      -> ALTER TABLE TBL ADD ( COL DATE )
TIMESTAMP    len=      10 prec=   2 modify   -> ALTER TABLE TBL ADD ( COL_KTL DATE ) ; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP ( COL ) ; ALTER TABLE TBL ADD ( COL DATE ) ; UPDATE TBL SET COL=COL_KTL; ALTER TABLE TBL DROP ( COL_KTL )
TIMESTAMP    len=      15 prec=   0 add      -> ALTER TABLE TBL ADD ( COL DATE )
TIMESTAMP    len=      15 prec=   0 modify   -> ALTER TABLE TBL ADD ( COL_KTL DATE ) ; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP ( COL ) ; ALTER TABLE TBL ADD ( COL DATE ) ; UPDATE TBL SET COL=COL_KTL; ALTER TABLE TBL DROP ( COL_KTL )
BOOLEAN      len=      -1 prec=  -1 add      -> ALTER TABLE TBL ADD ( COL CHAR(1) )
BOOLEAN      len=      -1 prec=  -1 modify   -> ALTER TABLE TBL ADD ( COL_KTL CHAR(1) ) ; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP ( COL ) ; ALTER TABLE TBL ADD ( COL CHAR(1) ) ; UPDATE TBL SET COL=COL_KTL; ALTER TABLE TBL DROP ( COL_KTL )
BOOLEAN      len=      10 prec=   2 add      -> ALTER TABLE TBL ADD ( COL CHAR(1) )
BOOLEAN      len=      10 prec=   2 modify   -> ALTER TABLE TBL ADD ( COL_KTL CHAR(1) ) ; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP ( COL ) ; ALTER TABLE TBL ADD ( COL CHAR(1) ) ; UPDATE TBL SET COL=COL_KTL; ALTER TABLE TBL DROP ( COL_KTL )
BOOLEAN      len=      15 prec=   0 add      -> ALTER TABLE TBL ADD ( COL CHAR(1) )
BOOLEAN      len=      15 prec=   0 modify   -> ALTER TABLE TBL ADD ( COL_KTL CHAR(1) ) ; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP ( COL ) ; ALTER TABLE TBL ADD ( COL CHAR(1) ) ; UPDATE TBL SET COL=COL_KTL; ALTER TABLE TBL DROP ( COL_KTL )
BINARY       len=      -1 prec=  -1 add      -> ALTER TABLE TBL ADD ( COL BLOB )
BINARY       len=      -1 prec=  -1 modify   -> ALTER TABLE TBL ADD ( COL_KTL BLOB ) ; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP ( COL ) ; ALTER TABLE TBL ADD ( COL BLOB ) ; UPDATE TBL SET COL=COL_KTL; ALTER TABLE TBL DROP ( COL_KTL )
BINARY       len=      10 prec=   2 add      -> ALTER TABLE TBL ADD ( COL BLOB )
BINARY       len=      10 prec=   2 modify   -> ALTER TABLE TBL ADD ( COL_KTL BLOB ) ; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP ( COL ) ; ALTER TABLE TBL ADD ( COL BLOB ) ; UPDATE TBL SET COL=COL_KTL; ALTER TABLE TBL DROP ( COL_KTL )
BINARY       len=      15 prec=   0 add      -> ALTER TABLE TBL ADD ( COL BLOB )
BINARY       len=      15 prec=   0 modify   -> ALTER TABLE TBL ADD ( COL_KTL BLOB ) ; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP ( COL ) ; ALTER TABLE TBL ADD ( COL BLOB ) ; UPDATE TBL SET COL=COL_KTL; ALTER TABLE TBL DROP ( COL_KTL )
INET         len=      -1 prec=  -1 add      -> ALTER TABLE TBL ADD ( COL VARCHAR2(45) )
INET         len=      -1 prec=  -1 modify   -> ALTER TABLE TBL ADD ( COL_KTL VARCHAR2(45) ) ; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP ( COL ) ; ALTER TABLE TBL ADD ( COL VARCHAR2(45) ) ; UPDATE TBL SET COL=COL_KTL; ALTER TABLE TBL DROP ( COL_KTL )
INET         len=      10 prec=   2 add      -> ALTER TABLE TBL ADD ( COL VARCHAR2(45) )
INET         len=      10 prec=   2 modify   -> ALTER TABLE TBL ADD ( COL_KTL VARCHAR2(45) ) ; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP ( COL ) ; ALTER TABLE TBL ADD ( COL VARCHAR2(45) ) ; UPDATE TBL SET COL=COL_KTL; ALTER TABLE TBL DROP ( COL_KTL )
INET         len=      15 prec=   0 add      -> ALTER TABLE TBL ADD ( COL VARCHAR2(45) )
INET         len=      15 prec=   0 modify   -> ALTER TABLE TBL ADD ( COL_KTL VARCHAR2(45) ) ; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP ( COL ) ; ALTER TABLE TBL ADD ( COL VARCHAR2(45) ) ; UPDATE TBL SET COL=COL_KTL; ALTER TABLE TBL DROP ( COL_KTL )
JSON         len=      -1 prec=  -1 add      -> ALTER TABLE TBL ADD ( COL JSON )
JSON         len=      -1 prec=  -1 modify   -> ALTER TABLE TBL ADD ( COL_KTL JSON ) ; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP ( COL ) ; ALTER TABLE TBL ADD ( COL JSON ) ; UPDATE TBL SET COL=COL_KTL; ALTER TABLE TBL DROP ( COL_KTL )
JSON         len=      10 prec=   2 add      -> ALTER TABLE TBL ADD ( COL JSON )
JSON         len=      10 prec=   2 modify   -> ALTER TABLE TBL ADD ( COL_KTL JSON ) ; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP ( COL ) ; ALTER TABLE TBL ADD ( COL JSON ) ; UPDATE TBL SET COL=COL_KTL; ALTER TABLE TBL DROP ( COL_KTL )
JSON         len=      15 prec=   0 add      -> ALTER TABLE TBL ADD ( COL JSON )
JSON         len=      15 prec=   0 modify   -> ALTER TABLE TBL ADD ( COL_KTL JSON ) ; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP ( COL ) ; ALTER TABLE TBL ADD ( COL JSON ) ; UPDATE TBL SET COL=COL_KTL; ALTER TABLE TBL DROP ( COL_KTL )
VECTOR       len=      -1 prec=  -1 add      -> ALTER TABLE TBL ADD ( COL VECTOR(*, *) )
VECTOR       len=      -1 prec=  -1 modify   -> ALTER TABLE TBL ADD ( COL_KTL VECTOR(*, *) ) ; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP ( COL ) ; ALTER TABLE TBL ADD ( COL VECTOR(*, *) ) ; UPDATE TBL SET COL=COL_KTL; ALTER TABLE TBL DROP ( COL_KTL )
VECTOR       len=      10 prec=   2 add      -> ALTER TABLE TBL ADD ( COL VECTOR(10, FLOAT32) )
VECTOR       len=      10 prec=   2 modify   -> ALTER TABLE TBL ADD ( COL_KTL VECTOR(10, FLOAT32) ) ; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP ( COL ) ; ALTER TABLE TBL ADD ( COL VECTOR(10, FLOAT32) ) ; UPDATE TBL SET COL=COL_KTL; ALTER TABLE TBL DROP ( COL_KTL )
VECTOR       len=      15 prec=   0 add      -> ALTER TABLE TBL ADD ( COL VECTOR(15, FLOAT32) )
VECTOR       len=      15 prec=   0 modify   -> ALTER TABLE TBL ADD ( COL_KTL VECTOR(15, FLOAT32) ) ; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP ( COL ) ; ALTER TABLE TBL ADD ( COL VECTOR(15, FLOAT32) ) ; UPDATE TBL SET COL=COL_KTL; ALTER TABLE TBL DROP ( COL_KTL )
