db.sql

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

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

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

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