create_table.sql

一本介绍oracle的书籍

create table question
(
    question_id			number(12) not null,
    content			varchar2(300) not null,
    correct_choice		number(6) not null,
    primary key (question_id)
);

create table answer
(
    question_id			number(12) not null,
    choice			number(6) not null,
    content			varchar2(100) not null,
    primary key (question_id,choice)
);

create sequence question_seq start with 1 increment by 1 nocycle nomaxvalue;