AnsweredAssumed Answered

creating table with conditions in oracle 11g

Question asked by reza840 on Aug 5, 2011
Latest reply on Aug 5, 2011 by ronald.van.kuijk
create table sales_order
(orderno varchar2(6) primary key,
clientno varchar2(6),
orderdate date not null,
delyaddr varchar2(25),
salesmanno varchar2(6),
delytype char(1),
billyn char(1),
delydate date can not be less than order_date,
orderstatus varchar2(10) values('In process','Fulfilled','Backorder','Cancelled'),
foreign key(clientno) references client_master(clientno),
foreign key(salesmanno) references salesman_master(salesmanno));
what is the correct form of using conditions in oracle 11g while creating a table? Hope you'll provide a satisfactory solution to this problem. Please its urgent!!!