Hey guys,

I was trying to do a procedure so if the rate is greater than 20000 certain values will be inserted in a table but the following code doesn't work and I was just wondering where I went wrong?

Thanks in advance.

CREATE OR REPLACE PROCEDURE sch_1 IS
BEGIN

IF T.RATE > 20000

INSERT INTO SCH
(SCHID, NAME)
vALUES(98, JO);
END SCH_1;
/