Cannot reference other columns Oracle SQL

Question

Here is my table declaration for Oracle SQL.

create table students (
    sid char(4) primary key check (sid like 'B%'),
    firstname varchar2(15) not null,
    lastname varchar2(15) not null,
    status varchar2(10) check (status in (‘freshman’, ‘sophomore’, ‘junior’, ‘senior’, ‘graduate’)),
    gpa number(3,2) check (gpa between 0 and 4.0),
    email varchar2(20) unique
    );

Why does the following error occur

ORA-02438: Column check constraint cannot reference other columns

Egor Skriptunoff · Accepted Answer · 2013-04-07 16:58:10Z

3

Use single quotes: 'freshman',...

answered Apr 7, 2013 at 16:58

Egor Skriptunoff

23.8k2 gold badges38 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Cannot reference other columns Oracle SQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related