test3_oracle.sql

来自「hibernate的经典练习」· SQL 代码 · 共 19 行

drop table  COURSES1 cascade constraints;
drop table  STUDENTS1;
drop table Student_Course;
create table COURSES1 (
   ID varchar(15) not null,
   NAME varchar(15),
   primary key (ID)
);
create table STUDENTS1 (
   ID varchar(15) not null,
   STUDENT_NUMBER varchar(15),
   primary key (ID)
);
create table Student_Course (
   STUDENT_ID varchar(15),
   COURSE_ID varchar(15),
   primary key (STUDENT_ID,COURSE_ID)
);