Hi I have a basic easy question. I am learning how to create tables and am
getting this error when I proform the CREATE TABLE command. Any Help?
SQL> CREATE table Ordr_Data
2 (
3 Order_id NUMBER(10) CONSTRAINT pk_order_data_order_id PRIMARY KEY,
4 Cust_id NUMBER(5) NOT NULL,
5 Sales_rep_id NUMBER(5) NOT NULL,
6 Prod_id NUMBER(10) NOT NULL CONSTRAINT uq_ordr_data_prod_id UNIQUE,
7 Quantity NUMBER CONSTRAINT ck_quantity CHECK(Quantity <= 1000),
8 Order_date DATE NOT NULL,
9 Order_Stat VARCHAR2(10) NOT NULL,
10 Ship_Date DATE NOT NULL,
11 Org_User_id NUMBER(5) NOT NULL,
12 Org_User_Date DATE NOT NULL,
13 Upd_User_id NUMBER(5),
14 Upd_User_Date DATE,
15 CONSTRAINT uq_Ordr_Data_Custid_ordrdt UNIQUE (cust_id,Order_date),
16 ck_Ordr_data_order_date CHECK (Order_date > '01-JAN-01'));
ck_Ordr_data_order_date CHECK (Order_date > '01-JAN-01'))
*
ERROR at line 16:
ORA-02438: Column check constraint cannot reference other columns
Received on Sun Oct 14 2001 - 16:03:43 CDT
