oracle SQL资料整理.docVIP

-- 一,資料定義語言(Database Definition Language) --/ ***************************** TABLE ***************************************************************/ -- 1 table create table school (sid char(6), name varchar2(20)); create table schoolmaster (nid char(6), name varchar2(20), sid char(6), sex char(1) ); create table school_temp as select * from school; primary key -- constraint pk_school primary key(sid) foreign key -- constraint fk_school_schoolmaster foreign ke