SQI 表格的创建添加数据

例如：

create table dsj               ---新建表格
           (tname VARCHAR(5),
            csdate  DATE,
            tage  NUMBER(2)) ;
select * from  dsj;
insert into dsj(tname,csdate,tage) values ('JD',to_date('1976-08-01','yyyy-mm-dd'),41);--插入行
insert into dsj(tname,csdate,tage) values ('CL',to_date('1955-08-01','yyyy-mm-dd'),62);
insert into dsj(tname,csdate,tage) values ('JD',sysdate,41);
insert into dsj(tname,csdate,tage) values ('CL',to_date('1955-08-01','yyyy-mm-dd'),62);  
insert into dsj(tname,csdate,tage) select tname,csdate,tage from dsj where tage=62;
update dsj set tname='靳东' where tname='JD';
update dsj set tname='LDH';
delete from dsj where csdate=to_date('1955-08-01','yyyy-mm-dd');
alter table dsj add (xb VARCHAR(5),tz NUMBER(2));---增加列
alter table dsj modify (tname VARCHAR(6));     ----修改列属性
update dsj set xb='男',tz=60 where tname='靳东';

rename  dsj to mx;           
select * from  mx;--修改表名

create table wod1 as select tname,csdate,tage from mx;      --新建表格，用 AS subquery 选项，将创建表和插入数据结合起来
select * from  wod1;

select mx.csdate,wod1.csdate from mx,wod1 where mx.csdate=wod1.csdate;--连接

select mx.tname||wod1.tname from mx,wod1 where mx.tname=wod1.tname;  ---自连接
select * from mx cross join wod1;----笛卡尔集
select mx.tname,mx.csdate,mx.tage,mx.tz from mx join wod1 on mx.tname=wod1.tname join; --ON 子句创建多表连接