posted 10 years ago
Hi everyone
create table Customers
(
CustNo number(4) primary key,
First_Name varchar2(30) not null,
Last_Name varchar2(30) not null,
CustType char(1) not null,
Credit_Limit number(7,2),
Credit_Card_No number(16),
Credit_Card_Type varchar2(8)
);
I understood the above code but can't understand the following code.
please explain the following code::
alter table Customers add check(Credit_Limit<10001);
thanks in advance.