text: --------------------------------------------------------
  --  File created - Friday-April-03-2015   
  --------------------------------------------------------
  REM INSERTING into RADIOLOGY_RECORD
  SET DEFINE OFF;
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (5,12,9,4,'CAT Scan',to_date('15-01-15','RR-MM-DD'),to_date('14-06-11','RR-MM-DD'),'Torn ligament','Nunc ullamcorper, velit in aliquet');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (6,16,6,3,'CAT Scan',to_date('15-06-10','RR-MM-DD'),to_date('14-05-05','RR-MM-DD'),'Broken arm','semper. Nam tempor diam dictum sapien.');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (7,9,1,8,'MRI',to_date('16-02-12','RR-MM-DD'),to_date('14-07-28','RR-MM-DD'),'Bruised bone','Nullam scelerisque neque');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (8,2,19,3,'X-Ray',to_date('15-06-13','RR-MM-DD'),to_date('15-04-08','RR-MM-DD'),'Sprain','pharetra nibh. Aliquam ornare, libero at');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (9,10,16,11,'MRI',to_date('16-02-08','RR-MM-DD'),to_date('15-01-25','RR-MM-DD'),'Fractured skull','Sed nulla ante, iaculis nec, eleifend');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (10,11,3,16,'X-Ray',to_date('15-11-24','RR-MM-DD'),to_date('14-06-28','RR-MM-DD'),'Torn ligament','fames ac turpis egestas. Fusce');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (11,20,13,9,'CAT Scan',to_date('15-09-30','RR-MM-DD'),to_date('15-09-28','RR-MM-DD'),'Sprain','elementum at, egestas a, scelerisque');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (12,4,14,15,'CAT Scan',to_date('14-06-20','RR-MM-DD'),to_date('15-12-23','RR-MM-DD'),'Bruised bone','risus a ultricies adipiscing, enim');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (13,16,2,13,'MRI',to_date('15-02-08','RR-MM-DD'),to_date('15-01-28','RR-MM-DD'),'Broken leg','Etiam bibendum fermentum metus.');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (14,6,11,11,'MRI',to_date('15-02-24','RR-MM-DD'),to_date('15-03-13','RR-MM-DD'),'Broken arm','gravida non, sollicitudin a,');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (15,15,12,4,'MRI',to_date('14-09-04','RR-MM-DD'),to_date('14-06-23','RR-MM-DD'),'Broken arm','Cras vehicula aliquet libero. Integer in');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (16,4,13,7,'MRI',to_date('15-09-24','RR-MM-DD'),to_date('15-12-15','RR-MM-DD'),'Sprain','lacus. Etiam bibendum');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (17,12,2,6,'X-Ray',to_date('14-04-25','RR-MM-DD'),to_date('15-12-13','RR-MM-DD'),'Fractured skull','nonummy ipsum non arcu. Vivamus');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (18,11,3,3,'X-Ray',to_date('15-10-05','RR-MM-DD'),to_date('14-09-13','RR-MM-DD'),'Broken arm','quis massa. Mauris vestibulum, neque');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (19,2,9,17,'X-Ray',to_date('14-04-17','RR-MM-DD'),to_date('15-12-14','RR-MM-DD'),'Torn ligament','nisl. Maecenas malesuada');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (20,20,16,14,'CAT Scan',to_date('14-11-28','RR-MM-DD'),to_date('15-04-18','RR-MM-DD'),'Broken arm','placerat velit. Quisque varius.');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (21,20,10,10,'X-Ray',to_date('14-07-15','RR-MM-DD'),to_date('16-03-20','RR-MM-DD'),'Fractured skull','nulla. Cras eu tellus eu augue');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (22,4,7,2,'X-Ray',to_date('14-05-15','RR-MM-DD'),to_date('14-06-18','RR-MM-DD'),'Fractured skull','at fringilla purus');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (23,3,1,19,'CAT Scan',to_date('15-06-22','RR-MM-DD'),to_date('16-01-20','RR-MM-DD'),'Fractured skull','at, velit. Pellentesque ultricies');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (24,12,9,8,'CAT Scan',to_date('14-12-12','RR-MM-DD'),to_date('15-11-01','RR-MM-DD'),'Bruised bone','eget ipsum. Suspendisse');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (25,9,19,11,'X-Ray',to_date('15-02-22','RR-MM-DD'),to_date('15-05-28','RR-MM-DD'),'Fractured skull','luctus, ipsum leo elementum sem, vitae');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (26,10,2,8,'CAT Scan',to_date('15-10-25','RR-MM-DD'),to_date('14-11-11','RR-MM-DD'),'Sprain','pede, nonummy ut,');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (27,6,12,19,'MRI',to_date('15-12-09','RR-MM-DD'),to_date('14-12-06','RR-MM-DD'),'Broken arm','habitant morbi tristique senectus et netus');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (28,20,20,12,'MRI',to_date('14-05-15','RR-MM-DD'),to_date('15-01-18','RR-MM-DD'),'Sprain','pede. Cras vulputate velit eu');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (29,8,8,4,'MRI',to_date('14-05-02','RR-MM-DD'),to_date('16-02-18','RR-MM-DD'),'Broken leg','posuere, enim nisl elementum purus, accumsan');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (30,11,14,8,'MRI',to_date('14-08-08','RR-MM-DD'),to_date('15-08-03','RR-MM-DD'),'Fractured skull','eu eros. Nam consequat dolor');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (31,9,18,6,'MRI',to_date('16-01-30','RR-MM-DD'),to_date('14-10-21','RR-MM-DD'),'Bruised bone','euismod in, dolor. Fusce feugiat. Lorem');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (32,4,13,11,'MRI',to_date('15-11-17','RR-MM-DD'),to_date('16-03-31','RR-MM-DD'),'Broken leg','eu tellus eu');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (33,2,6,3,'MRI',to_date('14-06-29','RR-MM-DD'),to_date('15-07-26','RR-MM-DD'),'Sprain','diam. Duis mi enim, condimentum eget,');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (34,4,17,5,'MRI',to_date('14-11-18','RR-MM-DD'),to_date('14-06-09','RR-MM-DD'),'Fractured skull','hendrerit id, ante. Nunc');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (35,19,5,5,'CAT Scan',to_date('14-05-16','RR-MM-DD'),to_date('15-09-29','RR-MM-DD'),'Broken leg','sit amet diam eu dolor egestas');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (36,19,8,5,'MRI',to_date('15-11-30','RR-MM-DD'),to_date('14-06-14','RR-MM-DD'),'Sprain','mus. Aenean eget magna. Suspendisse');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (37,14,3,2,'CAT Scan',to_date('16-03-27','RR-MM-DD'),to_date('14-12-30','RR-MM-DD'),'Broken leg','lacus. Nulla tincidunt, neque vitae semper');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (38,17,11,2,'CAT Scan',to_date('14-06-11','RR-MM-DD'),to_date('15-05-16','RR-MM-DD'),'Sprain','felis. Donec tempor, est');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (39,14,4,7,'MRI',to_date('15-03-26','RR-MM-DD'),to_date('15-03-01','RR-MM-DD'),'Broken leg','consequat nec, mollis vitae,');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (40,16,5,2,'CAT Scan',to_date('15-10-27','RR-MM-DD'),to_date('14-09-25','RR-MM-DD'),'Bruised bone','consectetuer rhoncus. Nullam');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (1,4,2,3,'X-Rays',null,null,'Broken arm','Scan of right arm.');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (2,7,5,6,'X-Ray',to_date('15-11-01','RR-MM-DD'),to_date('15-12-10','RR-MM-DD'),'Broken arm','Scan of right arm.');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (3,8,5,6,'X-Ray',to_date('16-01-02','RR-MM-DD'),to_date('16-01-10','RR-MM-DD'),'Broken arm','Scan of right arm.');
  Insert into RADIOLOGY_RECORD (RECORD_ID,PATIENT_ID,DOCTOR_ID,RADIOLOGIST_ID,TEST_TYPE,PRESCRIBING_DATE,TEST_DATE,DIAGNOSIS,DESCRIPTION) values (4,4,2,3,'X-Ray',to_date('15-03-07','RR-MM-DD'),to_date('16-02-02','RR-MM-DD'),'Broken arm','Scan of right arm.');
  