-- create and populate sample table for connection example

create table PERSON
(
	PERSON_ID										NUMBER not null,
	FIRST_NAME										VARCHAR2(50),
	LAST_NAME										VARCHAR2(50),
	PHONE_AREA_CODE								NUMBER(3),
	PHONE_EXCHANGE									NUMBER(3),
	PHONE_NUMBER									NUMBER(4),
	constraint PERSON_PRIMARY_KEY primary key (PERSON_ID)
);
commit;

-- sample data
insert into PERSON values ( 1,  'Douglas','Jeffries',	765,569,2238 );
insert into PERSON values ( 2,  'Shane',	'Milton',	123,456,7890 );
insert into PERSON values ( 3,  'Dale',	'Oexmann',	333,444,5555 );
insert into PERSON values ( 4,  'Bill',	'Cosby',		546,891,2155 );
insert into PERSON values ( 5,  'Mikael',	'Jordan',	534,414,4785 );
insert into PERSON values ( 6,  'Donald',	'Duck',		333,444,8486 );
insert into PERSON values ( 7,  'Doug',	'Smith',		333,443,5215 );
insert into PERSON values ( 8,  'Bill',	'Bongo',		241,546,5154 );
insert into PERSON values ( 9,  'Bubba',	'Smith',		213,220,5772 );
insert into PERSON values ( 10, 'Jack',	'Traik',		312,242,5431 );
insert into PERSON values ( 11, 'Hoosa',	'Bigaas',	213,220,3579 );
insert into PERSON values ( 12, 'Ida',		'Bigough',	244,480,2154 );
insert into PERSON values ( 13, 'Scott',	'Lang',		333,445,0204 );
insert into PERSON values ( 14, 'Peach',	'Tang',		333,445,8015 );
insert into PERSON values ( 15, 'Bugs',	'Bunny',		335,454,5000 );
commit;