建表

mysql

CREATE TABLE `INSTRUMENT` (
`INSTRUMENTID` varchar(31) DEFAULT NULL,
`EXCHANGEID` varchar(9) DEFAULT NULL,
`DIRECTION` char(1) DEFAULT NULL,
`VOLUMEMULTIPLE` decimal(6,0) DEFAULT NULL,
`PRICE` decimal(6,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

oracle

CREATE TABLE instrument(

InstrumentID VARCHAR2(31),

ExchangeID VARCHAR2(9),

Direction CHAR(1),

VolumeMultiple NUMBER(6),

Price NUMBER(6,2)

);

oracle vs mysql SQL语句