Oracle数据库操作示例：查询与自增技巧

--创建表空间及空间自增长大小 
create tablespace spaced datafile 'D:\show.dbf'size 6M
autoextend on next 1m
--创建用户名和密码
create user dasais identified by qhit default tablespace spaced;
--给用户授权
grant connect,resource to dasais;
-----------------------------------------以上是创建的表空间----------------
create table student(
       sid int primary key not null,
       sname nvarchar2(20) not null,
       sage int,
       sdaate date,
       sal number(5,2),
       ssex nvarchar2(20)not null,
       sdeptno number(3)
); 

create table showinfo(
       iid int primary key not null,
       iname nvarchar2(20) not null,
       iage int,
       isex nvarchar2(20)not null,
       isal number(8,2),
       ideptno number(3)
); 

select * from showinfo;--查询表
select * from student;--查询表
commit;  --提交事物

rollback;--回滚事务
drop table student;--删除表
drop table showinfo;--删除表

insert into showinfo values(1,'李紧',19,'1',1200,30);
insert into showinfo values(2,'姚大神',25,'0',1100,20);
insert into showinfo values(3,'谢大神',31,'1',1000,10);
insert into showinfo values(4,'胖子',33,'0',1300,20);
insert into showinfo values(5,'孙为民',31,'1',1000,10);
insert into showinfo values(6,'胡八一',33,'0',1300,30);

--一种直接给值的不用给字段的添加
insert into student values(5,'李紧',21,to_date('2014-10-30','yyyy-mm-dd'),120,'0',30);
insert into student values(6,'姚大神',25,to_date('2014-10-30','yyyy-mm-dd'),105,'0',20);
insert into student values(7,'谢大神',28,to_date('2014-10-30','yyyy-mm-dd'),90,'0',20);
insert into student values(8,'大赛',21,to_date('2014-10-30','yyyy-mm-dd'),85,'0',30);

--一种给值的给字段的添加
insert into student(sid,sname,sage,sdaate,sal,ssex,sdeptno)
values(1,'李紧紧',22,to_date('2014-10-30','yyyy-mm-dd'),165,'0',20);
insert into student(sid,sname,sage,sdaate,sal,ssex,sdeptno)
values(2,'大赛',23,to_date('2014-10-30','yyyy-mm-dd'),150,'1',20);
insert into student(sid,sname,sage,sdaate,sal,ssex,sdeptno)
values(3,'藏涛',25,to_date('2014-10-30','yyyy-mm-dd'),210,'0',30);
insert into student(sid,sname,sage,sdaate,sal,ssex,sdeptno)
values(4,'梁宽',29,to_date('2014-10-30','yyyy-mm-dd'),110,'1',30);

select * from student;--查询表

commit;  --提交事物