create_table.sql

来自「一本介绍oracle的书籍」· SQL 代码 · 共 18 行

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;