sm_create.sql

来自「orale培训教材包括了所有的sql说明和实例」· SQL 代码 · 共 11 行

drop table sm_emp;
create table sm_emp
(EmpID char(10) ,
Name   varchar2(10),
salary number(8,2),
TelNo  char(8));

insert into sm_emp values('0000000007','007',77,'77777777');
insert into sm_emp values('0000000009','009',99,'99999999');
commit;
select * from sm_emp;