Oracle 实用教程(第二版) 范例数据库,表及表数据
来源:互联网 发布:scboy淘宝店 编辑:程序博客网 时间:2024/06/10 00:11
CREATE TABLE kc ("KCH" CHAR(3 byte) NOT NULL,
"KCM" CHAR(16 byte) NOT NULL, "KKXQ" NUMBER(1) NOT NULL, "XS"
NUMBER(2) NOT NULL, "XF" NUMBER(1),
CONSTRAINT "CHECK_KKXQ_1" CHECK(kkxq between 1
and 8),
CONSTRAINT "PK_KCH_1" PRIMARY KEY("KCH")
USING INDEX
TABLESPACE "USERS"
STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255,
CONSTRAINT "XF_1" CHECK(xf between 0
and 10))
TABLESPACE "USERS" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS
255
STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0)
LOGGING
MONITORING
CREATE TABLE xs ("XH" CHAR(6 byte) NOT NULL, "XM"
VARCHAR2(8 byte) NOT NULL, "ZYM" CHAR(10 byte), "XB" CHAR(2
byte) NOT NULL, "CSSJ" DATE NOT NULL, "ZXF" NUMBER(2), "BZ"
VARCHAR2(200 byte),
CONSTRAINT "PK_XH_1" PRIMARY KEY("XH")
USING INDEX
TABLESPACE "USERS"
STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
TABLESPACE "USERS" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS
255
STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0)
LOGGING
MONITORING
CREATE TABLE xs_kc ("XH" CHAR(6 byte) NOT NULL,
"KCH" CHAR(3 byte) NOT NULL, "CJ" NUMBER(2), "XF" NUMBER(1),
CONSTRAINT "PK_XS_KC_1" PRIMARY KEY("XH", "KCH")
USING INDEX
TABLESPACE "USERS"
STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
TABLESPACE "USERS" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS
255
STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0)
LOGGING
MONITORING
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061101',' 王林','计算机','男',to_date('19860210','yyyymmdd'),50);
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061102','王平','计算机','女',to_date('19860902','yyyymmdd'),38);
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061103','王燕','计算机','女',to_date('19851006','yyyymmdd'),40);
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061104','韦严平','计算机','女',to_date('19860826','yyyymmdd'),40);
insert into xs(xh,xm,zym,xb,cssj,zxf,bz) values('061105','吴庆红','计算机','男',to_date('19851230','yyyymmdd'),36,'有两门课不及格');
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061106','李方方','计算机','男',to_date('19861120','yyyymmdd'),40);
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061107','李明','计算机','男',to_date('19860501','yyyymmdd'),40);
insert into xs(xh,xm,zym,xb,cssj,zxf,bz) values('061108','林一凡','计算机','男',to_date('19850805','yyyymmdd'),40,'已提前修完一门课');
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061109','张强民','计算机','男',to_date('19840811','yyyymmdd'),40);
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061110','张蔚','计算机','女',to_date('19870722','yyyymmdd'),40);
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061111','赵琳','计算机','女',to_date('19860318','yyyymmdd'),40);
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061112','罗琳琳','计算机','女',to_date('19840130','yyyymmdd'),40);
/
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061201','王敏','通讯工程','男',to_date('19840610','yyyymmdd'),42);
insert into xs(xh,xm,zym,xb,cssj,zxf,bz) values('061202','王林','通讯工程','男',to_date('19850129','yyyymmdd'),40,'有一门课不及格,待补考');
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061203','王玉民','通讯工程','男',to_date('19860326','yyyymmdd'),42);
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061204','马琳琳','通讯工程','女',to_date('19840210','yyyymmdd'),42);
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061206','李计','通讯工程','女',to_date('19850920','yyyymmdd'),42);
insert into xs(xh,xm,zym,xb,cssj,zxf,bz) values('061210','李红庆','通讯工程','女',to_date('19850501','yyyymmdd'),44,'已提前修完一门课成,并获得学分');
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061216','孙祥欣','通讯工程','女',to_date('19840309','yyyymmdd'),42);
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061218','孙研','通讯工程','男',to_date('19861009','yyyymmdd'),42);
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061220','吴薇华','通讯工程','女',to_date('19860318','yyyymmdd'),42);
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061221','刘燕敏','通讯工程','女',to_date('19851112','yyyymmdd'),42);
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061241','罗琳琳','通讯工程','女',to_date('19860130','yyyymmdd'),50);
insert into kc values('101','计算机基础 ', 1,80,5);
insert into kc values('102','程序设计语言', 2,68,4);
insert into kc values('206','离散数学 ', 4,68,4);
insert into kc values('208','数据结构', 5,68,4);
insert into kc values('109','操作系统', 6,68,4);
insert into kc values('210','计算机原理',7,85,5);
insert into kc values('212','数据库原理', 7,68,4);
insert into kc values('301','计算机网络', 7,51,3);
insert into kc values('302','软件工程',7,51,3);
insert into xs_kc(xh,kch,cj) values('061101','101', 80);
insert into xs_kc(xh,kch,cj) values('061101','102', 78);
insert into xs_kc(xh,kch,cj) values('061101','206', 76);
insert into xs_kc(xh,kch,cj) values('061103','101', 62);
insert into xs_kc(xh,kch,cj) values('061103','102', 70);
insert into xs_kc(xh,kch,cj) values('061103','206', 81);
insert into xs_kc(xh,kch,cj) values('061104','101', 90);
insert into xs_kc(xh,kch,cj) values('061107','101', 78);
insert into xs_kc(xh,kch,cj) values('061107','102', 80);
insert into xs_kc(xh,kch,cj) values('061107','206', 68);
insert into xs_kc(xh,kch,cj) values('061108','101', 85);
insert into xs_kc(xh,kch,cj) values('061108','102', 64);
insert into xs_kc(xh,kch,cj) values('061108','106', 87);
insert into xs_kc(xh,kch,cj) values('061109','101', 66);
insert into xs_kc(xh,kch,cj) values('061111','206', 76);
insert into xs_kc(xh,kch,cj) values('061113','101', 63);
insert into xs_kc(xh,kch,cj) values('061113','102', 79);
insert into xs_kc(xh,kch,cj) values('061113','206', 60);
insert into xs_kc(xh,kch,cj) values('061201','101', 80);
insert into xs_kc(xh,kch,cj) values('061202','101', 65);
insert into xs_kc(xh,kch,cj) values('061203','101', 87);
insert into xs_kc(xh,kch,cj) values('061104','102', 84);
insert into xs_kc(xh,kch,cj) values('061104','206', 65);
insert into xs_kc(xh,kch,cj) values('061102','102', 78);
insert into xs_kc(xh,kch,cj) values('061102','206', 78);
insert into xs_kc(xh,kch,cj) values('061106','101', 65);
insert into xs_kc(xh,kch,cj) values('061106','102', 71);
insert into xs_kc(xh,kch,cj) values('061106','206', 80);
insert into xs_kc(xh,kch,cj) values('061109','102', 83);
insert into xs_kc(xh,kch,cj) values('061109','206', 70);
insert into xs_kc(xh,kch,cj) values('061110','101', 95);
insert into xs_kc(xh,kch,cj) values('061110','102', 90);
insert into xs_kc(xh,kch,cj) values('061110','206', 89);
insert into xs_kc(xh,kch,cj) values('061111','101', 91);
insert into xs_kc(xh,kch,cj) values('061111','102', 70);
insert into xs_kc(xh,kch,cj) values('061204','101', 91);
insert into xs_kc(xh,kch,cj) values('061210','101', 76);
insert into xs_kc(xh,kch,cj) values('061216','101', 81);
insert into xs_kc(xh,kch,cj) values('061218','101', 70);
insert into xs_kc(xh,kch,cj) values('061220','101', 82);
insert into xs_kc(xh,kch,cj) values('061221','101', 76);
insert into xs_kc(xh,kch,cj) values('061241','101', 90);
- Oracle 实用教程(第二版) 范例数据库,表及表数据
- Oracle 外部表说明及简单范例
- oracle数据库备份数据及表结构
- ORACLE数据库表及数据恢复
- plsql导出oracle数据库表结构及表数据
- oracle数据库表结构及数据的导出
- (oracle数据库基础)第二章 表管理和查询
- 第二章 Oracle 表及表空间
- 【Oracle】Oracle实用教程总结(一)
- 自建数据库表,并在ALV报表中直接向更新自建表中写数据范例(非常感谢JACK WU)
- oracle 同步数据库表数据
- 重读两本书:《Java就业培训教程》和《JSP实用教程(第二版)》
- 通用SQL数据库查询语句范例(多表查询)
- 通用SQL数据库查询语句范例(多表查询)
- 通用SQL数据库查询语句范例(多表查询)
- 通用SQL数据库查询语句范例(多表查询)
- ORACLE复制表及数据
- Oracle 11gR2 安装 example(范例数据库)
- SoapClientBase ,A Good Class provide a mean to WebServices
- inode是什么?
- Party animal 聚会狂
- a new job,a new start
- [英语阅读]代金券成热门圣诞礼物
- Oracle 实用教程(第二版) 范例数据库,表及表数据
- 飞行射击的最基本算法实现 躲子弹的游戏
- 如何尽快获得晋升
- 圣诞节:奉献与分享
- [双语阅读]英媒称拉登失踪家人现栖身伊朗
- 《阿凡达》影评:真实的虚幻
- 使用STMP和yahoo发送邮件
- Wishy-washy 拿不定主意
- 浅谈c++里拷贝构造函数和拷贝赋值函数