Oracle gurus: Percent

[Hawkeye-X]

I need to add a percent check on a alter table query

something like this:

ALTER TABLE REP
ADD CHECK (RATE < 0.15D)

How do I do this?

[Hawkeye-X]

1. kick

HELP!

[Bozola]

2. yer close....

drop table poopy;

create table poopy(
id int not null,
pct decimal(10,4) not null,
oth decimal(10,4) not null,
);


ALTER TABLE poopy
ADD CONSTRAINT PctCheck CHECK (pct >= 0 and pct < 1.0),
CONSTRAINT Othcheck CHECK (oth < 0.15);

--hits constraint
insert into poopy(id,pct,oth) values (1,1,0.5);

--okie dokie
insert into poopy(id,pct,oth) values (1,.99, 0.14);

select * from poopy;