oracle 10g»ù´¡

²Ù×÷±í
 1´´½¨Ð±í
1.1´Ó²éѯµ½µÄ±í´´½¨±í
 create table temp as select stuName,stuNo,stuSex from stuInfo where stuAge>25;
1.2´´½¨Ð±í
/*ѧÉúÐÅÏ¢±í*/
create table stuInfo(
    stuName varchar2(10) ,
    stuNo varchar2(10),
    stuSex varchar2(4),
    stuAge number(2),
    stuSeat number(10),
    stuAddress varchar2(400));
/*ѧÉú³É¼¨±í*/
create table stuMark(
    examNo varchar2(10),
    stuNo varchar2(10),
    writtenExam number(4),
    labExam number(4));
2 Ð޸ıí
2.1 Ôö¼Ó×Ö¶Î
alter table stuInfo add(Zip number(6));
2.2 ɾ³ý×Ö¶Î
alter table stuInfo drop column Zip
2.3 ÐÞ¸Ä×Ö¶ÎÀàÐÍ
alter table stuInfo modify(Zip varchar2(6));
2.4ÐÞ¸Ä×ֶδóС
alter table stuInfo modify(Zip number(4));
2.5 ɾ³ý±í
    drop table stuInfo
3Ô¼Êø
3.1Ìí¼ÓÔ¼Êø
alter table stuInfo add constraint PK_stuNo primary key(stuNo);
alter table stuInfo add constraint CK_stuSex check(stuSex in('ÄÐ','Å®'));
alter table stuInfo add constraint CK_stuAge check(stuAge between 15 and 40);
alter table stuInfo add constraint CK_stuSeat check(stuSeat between 1 and 30);
    
alter table stuMark add constraint PK_ExamNo_stuMark  primary key(examNo);
alter table stuMark add constraint FK_stuNo_stuMark  foreign key(stuNo) references stuInfo(stuNo);
 select stuName,decode(stuSex,'ÄÐ','ÄÐͬ־'),
    (stuSex,'Å®','Ůͬ־')
     from stuInfo;
alter table stuInfo modify(stuSex not null);
3.2ɾ³ýÔ¼Êø
3.2.1ɾ³ýÆÕͨԼÊø
alter table stuInfo drop constraint CK_stuSex;
3.2.2ɾ³ý±»Íâ¼ü²ÎÕÕµÄÖ÷¼üÔ¼Êø
alter table stuInfo drop primary key PK_StuNo
4Ë÷Òý
4.1´´½¨Ë÷Òý
create index stuName_index on stuInfo(stuName);
4.2ɾ³ýË÷Òý
drop index stuName_index;
5´´½¨ÐòÁÐ
5.1 ´´½¨ÐòÁÐ
create se