emp.sql

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

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,3000);
insert into emp values(2,sysdate,'ְԱ2','1',25,4000);
insert into emp values(3,sysdate,'ְԱ3','1',45,6000);
insert into emp values(4,sysdate,'ְԱ4','1',24,2000);