create_table.sql

create table db1.table1 (id number(10));create table db1.table1 (id number(10), name varchar2(255));

CREATE TABLE "TEST"."T1"
(
    "ID" NUMBER(*,0)
) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM";

create table db1.table1 (id number(10) primary key);

create table db1.table1 (id number(10), unique (id) enable);

create table db1.table1 (id number(10), primary key (id) enable);

create table db1.table1 (id number(10), CONSTRAINT pk primary key (id) enable);

create table db1.table1 (id number(10), primary key (id) using index enable);

create table db1.table1 (id number(10,3) primary key);

CREATE TABLE test."persons" ( NUMERIC_NAME NUMERIC ( 15, 2 ), Decimal_NAME DECIMAL ( 15, 2 ), Dec_NAME DEC ( 15, 2 ), INTEGER_NAME INTEGER );

create table TEST.T21 (t CHAR(255));

create table TEST.T21 (t character(255));

CREATE TABLE TEST.INTERVAL_YEAR_COLUMNS(ID INT, C_INTERVAL_YEAR INTERVAL YEAR TO MONTH);

CREATE TABLE TEST.INTERVAL_YEAR_COLUMNS(ID INT, C_INTERVAL_YEAR INTERVAL YEAR(3) TO MONTH);

create table db1.table1 (primary varchar(255));

create table db1.table1 (id int, xml_data XMLTYPE);

create table db1.table1 (id int unique not deferrable not null);

create table db1.table1 (id int) organization heap no inmemory;

create table db1.table1 (id int) organization heap inmemory no memcompress no duplicate;

create table db1.table1 (id number(10), CONSTRAINT pk primary key (id) not deferrable initially deferred);

create table db1.table1 (id number(10), CONSTRAINT pk primary key (id) initially deferred not deferrable);

create table db1.table1 (id number(10) not null);

create table db1.table1 (id number(10) not null unique);

create table db1.table1 (id number(10) unique not null);

create table db1.table1 (id number(10) unique not deferrable not null);

create table db1.table1 (id number(10) unique not
    deferrable not null);

create table db1.table1 (id number(10) unique not
    deferrable not null);

create table db1.table1 (start_time timestamp(5));

CREATE TABLE sbtest1 (
id INTEGER NOT NULL,
k INTEGER,
c CHAR(120) DEFAULT '' NOT NULL,
pad CHAR(60) DEFAULT '' NOT NULL,
PRIMARY KEY (id)
);

create table db1.table_1 (id_1 int);
create table db1.table#1 (id#1 int);
create table db1.table$1 (id$1 int);
create table db1.table$#_1 (id$1_ int);

create table db1.table1 (ts TIMESTAMP);
create table db1.table1 (ts TIMESTAMP(6));
create table db1.table1 (ts TIMESTAMP WITH TIME ZONE);
create table db1.table1 (ts TIMESTAMP WITH LOCAL TIME ZONE);
create table db1.table1 (ts TIMESTAMP(6) WITH TIME ZONE);
create table db1.table1 (ts TIMESTAMP(6) WITH LOCAL TIME ZONE);