sm_create.sql

orale培训教材包括了所有的sql说明和实例

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;