第9章-表和约束.pdfVIP

IT 3 Sept. 2008Copyright 2008 By Neusoft Group. All rights reserved © Neusoft Confidential 3 Sept. 2008 Confidential • • • • • • 3 Sept. 2008 Confidential • Oracle – 1–30 – A–Z, a–z, 0–9, _ ()$ # – Oracle – Oracle – 3 Sept. 2008 Confidential • CREATE TABLE [schema.]table CREATE TABLE [schema.]table (column datatype [DEFAULT expr][, ...]); (column datatype [DEFAULT expr][, ...]); 3 Sept. 2008 Confidential CREATE TABLE DOSSIER ( CREATE TABLE DOSSIER ( ID NUMBER(4), ID NUMBER(4), CNAME VARCHAR2(20 ), CNAME VARCHAR2(20 ), BIRTHDAY DATE, BIRTHDAY DATE, STATURE NUMBER(3), STATURE NUMBER(3), WEIGHT NUMBER(5, 2), WEIGHT NUMBER(5, 2), COUNTRY_CODE CHAR(2 ) DEFAULT ‘01’); COUNTRY_CODE CHAR(2 ) DEFAULT ‘01’); 3 Sept. 2008 Confidential • insert into dossier insert into dossier (ID,CNAME,BIRTHDAY, STATURE,WEIGHT ) (ID,CNAME,BIRTHDAY, STATURE,WEIGHT ) values values (2, , to_date(1980.9.12,yyyy.mm.dd),226, 134 ); (2, , to_date(1980.9.12,yyyy.mm.dd),226, 134 ); 1 1 • update dossier set country_code =default where id=2; update dossier set country_code =default where id=2; 3 Sept. 2008 Confidential • CREA