db.sql

来自「oracle技术手册供初学者」· SQL 代码 · 共 28 行

create table emp
(
    no			numeric(12) not null,
    upd_ts		timestamp not null,
    name		char(20) not null,
    duty		char(1) not null,
    age			numeric(6) not null,
    salary		numeric(12,2) not null,
    primary key (no)
);

create table resume
(
    no			numeric(12) not null,
    resume		blob not null,
    primary key (no)
);

create table seq
(
    seq_id		int auto_increment,
    primary key (seq_id)
);

insert into emp values(0,now(),'ְԱ0','1',20,1000);
insert into emp values(1,now(),'ְԱ1','1',30,2000);
insert into emp values(2,now(),'ְԱ2','1',40,2500);