cre_emphistory.sql

9iSQL新特性试验

DROP TABLE emp_history;
CREATE TABLE emp_history
  (employee_id    NUMBER(6) NOT NULL,
   resignation_date DATE)
   
/

insert into emp_history
  values(1, TO_DATE('13-AUG-1992', 'DD-MON-YYYY'));
insert into emp_history
  values(10,TO_DATE( '07-DEC-1997', 'DD-MON-YYYY'));
insert into emp_history
  values(20, TO_DATE( '27-NOV-1998', 'DD-MON-YYYY'));
insert into emp_history
  values(30, TO_DATE( '10-NOV-1996', 'DD-MON-YYYY'));
 
COMMIT;