oracle创建表

--建表create table emp ( empno number(4) primary key,ename varchar2(10),job varchar2(9),mgr number(4),hiredate date,sal number(7,2),comm number(7,2))-- Create sequence建序列　　create sequence emp_SEQUENCE　　minvalue 1　　maxvalue 999999999999999999999999999　　start with 1　　increment by 1　　cache 20;--插数据insert into emp values(emp_SEQUENCE.Nextval,'guyang','JAVA',1,to_date ('2011-09-28','YYYY-MM-DD'),1000,100)insert into emp values(emp_SEQUENCE.Nextval,'yuanjia','JAVA',1,to_date ('2011-10-01','YYYY-MM-DD'),1000,100)--查询select * from emp