Oracle 基本操作之 table

###  建立表

CREATE TABLE Student
       (Sno  CHAR(9)  PRIMARY KEY,
        Sname  CHAR(20) NOT NULL,     
        Ssex  CHAR(4),
        Sage  SMALLINT,
        Sdept  CHAR(20)) tablespace gaospace;

###  插入資料 

INSERT INTO Student VALUES('0201','趙偉','男',18,'cs');
INSERT INTO Student VALUES('0202','張力虹','男',19,'is');
INSERT INTO Student VALUES('0203','徐秀美','女',21,'is');
INSERT INTO Student VALUES('0204','劉平','男',20,'cs');
INSERT INTO Student VALUES('0205','姚家全','男',19,'cs');
INSERT INTO Student VALUES('0206','上關美雲','女',23,'ma');


###  










###  修改表的欄位型別

alter table student modify ssex char(6);