have a simple question. Please help me!# Database - 数据库
DW
1 楼
In the table, there are two columns, one is calleld start_letter and the other
is called end_letter. The type of both of them is Char(1). The condition is
end_letter must be greater than start_letter. So what I write like this:
start_letter CHAR(1) NOT NULL,
end_letter CHAR(1) NOT NULL CHECK(end_letter>start_letter)
The error message is
ORA-02438: Column check constraint cannot reference other columns
How should I do to set this condition?
Thank you!
is called end_letter. The type of both of them is Char(1). The condition is
end_letter must be greater than start_letter. So what I write like this:
start_letter CHAR(1) NOT NULL,
end_letter CHAR(1) NOT NULL CHECK(end_letter>start_letter)
The error message is
ORA-02438: Column check constraint cannot reference other columns
How should I do to set this condition?
Thank you!