insert into patient(patient_id, patient_fname, patient_lname)
values(1, 'Tobiah', 'Gettone');
insert into patient(patient_id, patient_fname, patient_lname)
values(2, 'Gonzales', 'Zunaelli');
insert into patient(patient_id, patient_fname, patient_lname)
values(3, 'Francois', 'Aldwinckle');
insert into patient(patient_id, patient_fname, patient_lname)
values(4, 'Brit', 'Rizzoto');
insert into patient(patient_id, patient_fname, patient_lname)
values(5, 'Wynne', 'Truman');
insert into patient(patient_id, patient_fname, patient_lname)
values(6, 'Woodman', 'Braiden');
insert into patient(patient_id, patient_fname, patient_lname)
values(7, 'Archaimbaud', 'Ashelford');
insert into patient(patient_id, patient_fname, patient_lname)
values(8, 'Ansely', 'Med');
insert into patient(patient_id, patient_fname, patient_lname)
values(9, 'Brook', 'Attwool');
insert into patient(patient_id, patient_fname, patient_lname)
values(10, 'Felizio', 'Corah');
insert into patient(patient_id, patient_fname, patient_lname)
values(11, 'Hector', 'Codman');
insert into patient(patient_id, patient_fname, patient_lname)
values(12, 'Sammy', 'Impleton');
insert into patient(patient_id, patient_fname, patient_lname)
values(13, 'Marwin', 'Calafato');
insert into patient(patient_id, patient_fname, patient_lname)
values(14, 'Fowler', 'Macken');
insert into patient(patient_id, patient_fname, patient_lname)
values(15, 'Yuri', 'Andrin');
insert into patient(patient_id, patient_fname, patient_lname)
values(16, 'Thacher', 'Fewkes');
insert into patient(patient_id, patient_fname, patient_lname)
values(17, 'Caroll', 'Falser');
insert into patient(patient_id, patient_fname, patient_lname)
values(18, 'Benjy', 'Addlestone');
insert into patient(patient_id, patient_fname, patient_lname)
values(19, 'Curico', 'Stud');
insert into patient(patient_id, patient_fname, patient_lname)
values(20, 'Ethelind', 'Bryns');
insert into patient(patient_id, patient_fname, patient_lname)
values(21, 'Nanny', 'Rignall');
insert into patient(patient_id, patient_fname, patient_lname)
values(22, 'Gael', 'Snugg');
insert into patient(patient_id, patient_fname, patient_lname)
values(23, 'Lee', 'Voules');
insert into patient(patient_id, patient_fname, patient_lname)
values(24, 'Francisco', 'Drawmer');
insert into patient(patient_id, patient_fname, patient_lname)
values(25, 'Cordy', 'ODare');
insert into patient(patient_id, patient_fname, patient_lname)
values(2, 'Gonzales', 'Zunaelli');
insert into patient(patient_id, patient_fname, patient_lname)
values(3, 'Francois', 'Aldwinckle');
insert into patient(patient_id, patient_fname, patient_lname)
values(4, 'Brit', 'Rizzoto');
insert into patient(patient_id, patient_fname, patient_lname)
values(5, 'Wynne', 'Truman');
insert into patient(patient_id, patient_fname, patient_lname)
values(6, 'Woodman', 'Braiden');
insert into patient(patient_id, patient_fname, patient_lname)
values(7, 'Archaimbaud', 'Ashelford');
insert into patient(patient_id, patient_fname, patient_lname)
values(8, 'Ansely', 'Med');
insert into patient(patient_id, patient_fname, patient_lname)
values(9, 'Brook', 'Attwool');
insert into patient(patient_id, patient_fname, patient_lname)
values(10, 'Felizio', 'Corah');
insert into patient(patient_id, patient_fname, patient_lname)
values(11, 'Hector', 'Codman');
insert into patient(patient_id, patient_fname, patient_lname)
values(12, 'Sammy', 'Impleton');
insert into patient(patient_id, patient_fname, patient_lname)
values(13, 'Marwin', 'Calafato');
insert into patient(patient_id, patient_fname, patient_lname)
values(14, 'Fowler', 'Macken');
insert into patient(patient_id, patient_fname, patient_lname)
values(15, 'Yuri', 'Andrin');
insert into patient(patient_id, patient_fname, patient_lname)
values(16, 'Thacher', 'Fewkes');
insert into patient(patient_id, patient_fname, patient_lname)
values(17, 'Caroll', 'Falser');
insert into patient(patient_id, patient_fname, patient_lname)
values(18, 'Benjy', 'Addlestone');
insert into patient(patient_id, patient_fname, patient_lname)
values(19, 'Curico', 'Stud');
insert into patient(patient_id, patient_fname, patient_lname)
values(20, 'Ethelind', 'Bryns');
insert into patient(patient_id, patient_fname, patient_lname)
values(21, 'Nanny', 'Rignall');
insert into patient(patient_id, patient_fname, patient_lname)
values(22, 'Gael', 'Snugg');
insert into patient(patient_id, patient_fname, patient_lname)
values(23, 'Lee', 'Voules');
insert into patient(patient_id, patient_fname, patient_lname)
values(24, 'Francisco', 'Drawmer');
insert into patient(patient_id, patient_fname, patient_lname)
values(25, 'Cordy', 'ODare');
create table patient(
patient_id number(3),
patient_fname varchar(30),
patient_lname varchar(30)
);
create table physician(
physician_id number(3),
physician_fname varchar(30),
physician_lname varchar(30),
physician_specality varchar(30)
);
create table treatment_info(
patient_id number(3),
treatment_date date,
treatment_time varchar(15),
treatment_result varchar(30)

);

insert into patient(patient_id, patient_fname, patient_lname)
values(1, 'Tobiah', 'Gettone');
insert into patient(patient_id, patient_fname, patient_lname)
values(2, 'Gonzales', 'Zunaelli');
insert into patient(patient_id, patient_fname, patient_lname)
values(3, 'Francois', 'Aldwinckle');
insert into patient(patient_id, patient_fname, patient_lname)
values(4, 'Brit', 'Rizzoto');
insert into patient(patient_id, patient_fname, patient_lname)
values(5, 'Wynne', 'Truman');
insert into patient(patient_id, patient_fname, patient_lname)
values(6, 'Woodman', 'Braiden');
insert into patient(patient_id, patient_fname, patient_lname)
values(7, 'Archaimbaud', 'Ashelford');
insert into patient(patient_id, patient_fname, patient_lname)
values(8, 'Ansely', 'Med');
insert into patient(patient_id, patient_fname, patient_lname)
values(9, 'Brook', 'Attwool');
insert into patient(patient_id, patient_fname, patient_lname)
values(10, 'Felizio', 'Corah');
insert into patient(patient_id, patient_fname, patient_lname)
values(11, 'Hector', 'Codman');
insert into patient(patient_id, patient_fname, patient_lname)
values(12, 'Sammy', 'Impleton');
insert into patient(patient_id, patient_fname, patient_lname)
values(13, 'Marwin', 'Calafato');
insert into patient(patient_id, patient_fname, patient_lname)
values(14, 'Fowler', 'Macken');
insert into patient(patient_id, patient_fname, patient_lname)
values(15, 'Yuri', 'Andrin');
insert into patient(patient_id, patient_fname, patient_lname)
values(16, 'Thacher', 'Fewkes');
insert into patient(patient_id, patient_fname, patient_lname)
values(17, 'Caroll', 'Falser');
insert into patient(patient_id, patient_fname, patient_lname)
values(18, 'Benjy', 'Addlestone');
insert into patient(patient_id, patient_fname, patient_lname)
values(19, 'Curico', 'Stud');
insert into patient(patient_id, patient_fname, patient_lname)
values(20, 'Ethelind', 'Bryns');
insert into patient(patient_id, patient_fname, patient_lname)
values(21, 'Nanny', 'Rignall');
insert into patient(patient_id, patient_fname, patient_lname)
values(22, 'Gael', 'Snugg');
insert into patient(patient_id, patient_fname, patient_lname)
values(23, 'Lee', 'Voules');
insert into patient(patient_id, patient_fname, patient_lname)
values(24, 'Francisco', 'Drawmer');
insert into patient(patient_id, patient_fname, patient_lname)
values(25, 'Cordy', 'ODare');

select 1 from patient;
create table patient(
patient_id number(3),
patient_fname varchar(30),
patient_lname varchar(30)
);
create table physician(
physician_id number(3),
physician_fname varchar(30),
physician_lname varchar(30),
physician_specality varchar(30)
);
create table treatment_info(
patient_id number(3),
treatment_date date,
treatment_time varchar(15),
treatment_result varchar(30)

);

insert into patient(patient_id, patient_fname, patient_lname)
values(1, 'Tobiah', 'Gettone');
insert into patient(patient_id, patient_fname, patient_lname)
values(2, 'Gonzales', 'Zunaelli');
insert into patient(patient_id, patient_fname, patient_lname)
values(3, 'Francois', 'Aldwinckle');
insert into patient(patient_id, patient_fname, patient_lname)
values(4, 'Brit', 'Rizzoto');
insert into patient(patient_id, patient_fname, patient_lname)
values(5, 'Wynne', 'Truman');
insert into patient(patient_id, patient_fname, patient_lname)
values(6, 'Woodman', 'Braiden');
insert into patient(patient_id, patient_fname, patient_lname)
values(7, 'Archaimbaud', 'Ashelford');
insert into patient(patient_id, patient_fname, patient_lname)
values(8, 'Ansely', 'Med');
insert into patient(patient_id, patient_fname, patient_lname)
values(9, 'Brook', 'Attwool');
insert into patient(patient_id, patient_fname, patient_lname)
values(10, 'Felizio', 'Corah');
insert into patient(patient_id, patient_fname, patient_lname)
values(11, 'Hector', 'Codman');
insert into patient(patient_id, patient_fname, patient_lname)
values(12, 'Sammy', 'Impleton');
insert into patient(patient_id, patient_fname, patient_lname)
values(13, 'Marwin', 'Calafato');
insert into patient(patient_id, patient_fname, patient_lname)
values(14, 'Fowler', 'Macken');
insert into patient(patient_id, patient_fname, patient_lname)
values(15, 'Yuri', 'Andrin');
insert into patient(patient_id, patient_fname, patient_lname)
values(16, 'Thacher', 'Fewkes');
insert into patient(patient_id, patient_fname, patient_lname)
values(17, 'Caroll', 'Falser');
insert into patient(patient_id, patient_fname, patient_lname)
values(18, 'Benjy', 'Addlestone');
insert into patient(patient_id, patient_fname, patient_lname)
values(19, 'Curico', 'Stud');
insert into patient(patient_id, patient_fname, patient_lname)
values(20, 'Ethelind', 'Bryns');
insert into patient(patient_id, patient_fname, patient_lname)
values(21, 'Nanny', 'Rignall');
insert into patient(patient_id, patient_fname, patient_lname)
values(22, 'Gael', 'Snugg');
insert into patient(patient_id, patient_fname, patient_lname)
values(23, 'Lee', 'Voules');
insert into patient(patient_id, patient_fname, patient_lname)
values(24, 'Francisco', 'Drawmer');
insert into patient(patient_id, patient_fname, patient_lname)
values(25, 'Cordy', 'ODare');

insert into physician(physician_id, physician_fname, physician_lname, speciality)
values(100, );
insert into physician(physician_id, physician_fname, physician_lname, speciality)
values(100, );
insert into physician(physician_id, physician_fname, physician_lname, speciality)
values(100, );
insert into physician(physician_id, physician_fname, physician_lname, speciality)
values(100, 'Elayne', 'Meininking', 'N/A' );
insert into physician(physician_id, physician_fname, physician_lname, specality)
values(100, 'Elayne', 'Meininking', 'N/A' );
insert into physician(physician_id, physician_fname, physician_lname, physician_specality)
values(100, 'Elayne', 'Meininking', 'N/A' );
insert into physician(physician_id, physician_fname, physician_lname, physician_specality)
values(103, 'Noelani', Bettlestone, 'N/A');
insert into physician(physician_id, physician_fname, physician_lname, physician_specality)
values(103, 'Noelani', Bettlestone, 'N/A');
insert into physician(physician_id, physician_fname, physician_lname, physician_specality)
values(103, 'Noelani', Bettlestone, 'N/A');
insert into physician(physician_id, physician_fname, physician_lname, physician_specality)
values(103, 'Noelani', Bettlestone, 'N/A');
insert into treatment_info(patient_id, treatment_date, treatment_time, treatment_result)
values(2, '19-Sept-17', '1050 AM', 'N/A');
insert into treatment_info(patient_id, treatment_date, treatment_time, treatment_result)
values(3, '15-Aug-15', '954 AM', 'Loc 2nd osteoarth-shlder');
insert into treatment_info(patient_id, treatment_date, treatment_time, treatment_result)
values(7, '04-Jan-17', '1052 AM', 'Bechet arthritis-ankle');
insert into treatment_info(patient_id, treatment_date, treatment_time, treatment_result)
values(7, '14-Feb-17', '454 PM', '');
insert into treatment_info(patient_id, treatment_date, treatment_time, treatment_result)
values(9, '1-Sep-17', '439 PM', '');
insert into treatment_info(patient_id, treatment_date, treatment_time, treatment_result)
values(11, '09-Jan-17', '233 PM', 'Louping ill');
insert into treatment_info(patient_id, treatment_date, treatment_time, treatment_result)
values(12, '06-Jul-17', '1010 AM', 'Malig neo corpus uteri');
insert into treatment_info(patient_id, treatment_date, treatment_time, treatment_result)
values(14, '01-Mar-17', '1212 PM', '');
insert into treatment_info(patient_id, treatment_date, treatment_time, treatment_result)
values(19, '', '', '');
insert into treatment_info(patient_id, treatment_date, treatment_time, treatment_result)
values(14, '01-Mar-17', '1212 PM', '');
insert into treatment_info(patient_id, treatment_date, treatment_time, treatment_result)
values(16, '06-Jun-17', '322 PM', 'RR acc NEC-pedestrian');
insert into treatment_info(patient_id, treatment_date, treatment_time, treatment_result)
values(17, '15-Nov-17', '1242 PM', 'Gend idem dis,adol/adult');
insert into treatment_info(patient_id, treatment_date, treatment_time, treatment_result)
values(19, '', '', '');