oracle 数据库插入问题
CREATE TABLE Tb_Dept
(DeptId Char(2) Primary Key NOT NULL,
DeptName VarChar2(20)NOT NULL
);
CREATE TABLE Tb_TeachingYear
(TeachingYearId Char(4) Primary Key NOT NULL,
TeachingYearName VarChar2(13) NOT NULL
);
CREATE TABLE Tb_Term
(TermId Char(2) Primary Key NOT NULL,
TermName VarChar2(8) NOT NULL
);
CREATE TABLE Tb_Class
(
ClassId char(7) NOT NULL Primary key,
ClassName VarChar2(20) NOT NULL ,
DeptId char(2) NOT NULL REFERENCES Tb_Dept(DeptId) ,
StuNumber number DEFAULT '0' NOT NULL
);
CREATE TABLE Tb_Student
(
StuId char(9) NOT NULL primary key,
StuName VarChar2(8) NOT NULL,
ClassId char(7) NOT NULL REFERENCES Tb_Class,
Sex char(1) DEFAULT 'M' NOT NULL CHECK (Sex IN ('M','F')),
Birthday date NOT NULL
);
CREATE TABLE Tb_Course
(CourseId char(6) NOT NULL primary key,
CourseName varchar2(30) NOT NULL,
Deptid char(2) NOT NULL REFERENCES Tb_Dept(DeptId ),
CourseGrade real DEFAULT '0' NOT NULL CHECK (CourseGrade>=0 and CourseGrade<100)
);
CREA
相关问答:
大家好,我现在把oracle服务器上面的原始文件,下载到本机了.我想在本机访问数据库怎么设置啊.是不是类似可以建立一个什么虚拟服务器来实现.请大家出出主意
引用
大家好,我现在把oracle服务器上面 ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
然後按回車鍵 說明: user/password@dbname 分別表示用戶名,密碼和服務名 f ......
在执行包的时候引用oracle spatial空间函数出错,出错情况如下
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......
oracle 11g 安装 01092 错误,
日志信息:
[oracle@linux trace]$ vi alert_orcl.log
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......