emp.sql

来自「oracle常用脚本」· SQL 代码 · 共 15 行

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(2,sysdate,'ְԱ2','1',20,1000);
commit;