am.groenevelt
09-Oct-14
Nice demo, but the installscript is incomplete - the obe_employees are missing. I reconstructed this from the screenshots:
CREATE TABLE OBE_EMPLOYEES
(
EMPLOYEE_ID NUMERIC(4,0),
CONSTRAINT OBE_EMP_ID_PK PRIMARY KEY (EMPLOYEE_ID),
FIRST_NAME VARCHAR2(30) NOT NULL,
LAST_NAME VARCHAR2(30) NOT NULL,
EMAIL VARCHAR2(30) NOT NULL,
HIRE_DATE DATE NOT NULL
);
insert into OBE_EMPLOYEES values
( 1, 'Sue', 'Littlefield', 'sue.littlefield',to_date('02-06-2001','MM-DD-YYYY'));
insert into OBE_EMPLOYEES values
( 2, 'Mark', 'Ferris', 'mark.ferris',to_date('04-05-2003','MM-DD-YYYY'));
insert into OBE_EMPLOYEES values
( 3, 'Marcie', 'Young', 'marcie.young',to_date('08-08-1997','MM-DD-YYYY'));
insert into OBE_EMPLOYEES values
( 4, 'Joyce', 'Bean', 'joyce.bean',to_date('04-04-2000','MM-DD-YYYY'));
insert into OBE_EMPLOYEES values
( 5, 'Andrew', 'Jarvis', 'andrew.jarvis',to_date('09-01-1999','MM-DD-YYYY'));
insert into OBE_EMPLOYEES values
( 6, 'Anthony', 'Reed', 'anthony.reed',to_date('10-23-2004','MM-DD-YYYY'));
insert into OBE_EMPLOYEES values
( 7, 'Vicki', 'Dean', 'vicky.dean',to_date('12-17-2001','MM-DD-YYYY'));
insert into OBE_EMPLOYEES values
( 8, 'Emily', 'Roberts', 'emily.roberts',to_date('03-03-2002','MM-DD-YYYY'));
insert into OBE_EMPLOYEES values
( 9, 'Teressa', 'Chow', 'teressa.chow',to_date('09-09-1996','MM-DD-YYYY'));
Add it to the install script or just run it afterwards.