三个主流数据库（Oracle、MySQL和SQL Server）的“单表造数

1.oracle

创建表

CREATE TABLE "YZH2_ORACLE" (
  "VARCHAR2_COLUMN" VARCHAR2(20) NOT NULL ENABLE,
  "NUMBER_COLUMN" NUMBER,
  "DATE_COLUMN" DATE,
  "CLOB_COLUMN" CLOB,
  "BLOB_COLUMN" BLOB,
  "BINARY_DOUBLE_COLUMN" BINARY_DOUBLE,
  "BINARY_FLOAT_COLUMN" BINARY_FLOAT,
  "CHAR_COLUMN" CHAR(1),
  "CHAR_VARYING_COLUMN" VARCHAR2(20),
  "DEC_COLUMN" NUMBER(*, 0),
  "DECIMAL_COLUMN" NUMBER(*, 0),
  "DOUBLE_PRECISION_COLUMN" FLOAT(126),
  "CHARACTER_COLUMN" CHAR(1),
  "CHARACTER_VARYING_COLUMN" VARCHAR2(20),
  "FLOAT_COLUMN" FLOAT(126),
  "INT_COLUMN" NUMBER(*, 0),
  "INTEGER_COLUMN" NUMBER(*, 0),
  "NATIONAL_CHAR_COLUMN" NCHAR(1),
  "NATIONAL_CHAR_VARYING_COLUMN" NVARCHAR2(20),
  "NATIONAL_CHARACTER_COLUMN" NCHAR(1),
  "NATIONAL_CHARACTER_VARY_COLUMN" NVARCHAR2(20),