cre_reward.sql

9iSQL新特性试验

DROP TABLE REWARDS;
CREATE TABLE rewards
  (employee_id    NUMBER(6) NOT NULL,
   pay_raise NUMBER(8,2),
   payraise_date DATE NOT NULL
   )
/

insert into rewards
  values(103, 10000, TO_DATE('13-AUG-1992', 'DD-MON-YYYY'));
insert into rewards
  values(141, 2500,TO_DATE( '07-DEC-1997', 'DD-MON-YYYY'));
insert into rewards
  values(201, 4875, TO_DATE( '27-NOV-1998', 'DD-MON-YYYY'));
insert into rewards
  values(206, 1800, TO_DATE( '10-NOV-1996', 'DD-MON-YYYY'));
 
COMMIT;