childstat table

childstat table.sql

CREATE TABLE CHILDSTAT" 
   (	"FIRSTNAME" VARCHAR2(50 BYTE), 
	"GENDER" VARCHAR2(1 BYTE), 
	"BIRTHDATE" DATE, 
	"HEIGHT" NUMBER(*,0), 
	"WEIGHT" NUMBER(*,0)
   ) ;

Insert into CHILDSTAT (FIRSTNAME,GENDER,BIRTHDATE,HEIGHT,WEIGHT) values ('lauren','f',to_date('10-JUN-00','DD-MON-RR'),54,876);
Insert into CHILDSTAT (FIRSTNAME,GENDER,BIRTHDATE,HEIGHT,WEIGHT) values ('rosemary','f',to_date('08-MAY-00','DD-MON-RR'),35,123);
Insert into CHILDSTAT (FIRSTNAME,GENDER,BIRTHDATE,HEIGHT,WEIGHT) values ('Albert','m',to_date('02-AUG-00','DD-MON-RR'),15,923);
Insert into CHILDSTAT (FIRSTNAME,GENDER,BIRTHDATE,HEIGHT,WEIGHT) values ('buddy','m',to_date('02-OCT-00','DD-MON-RR'),15,150);
Insert into CHILDSTAT (FIRSTNAME,GENDER,BIRTHDATE,HEIGHT,WEIGHT) values ('furkar','m',to_date('05-JAN-00','DD-MON-RR'),76,198);
Insert into CHILDSTAT (FIRSTNAME,GENDER,BIRTHDATE,HEIGHT,WEIGHT) values ('simon','m',to_date('03-JAN-00','DD-MON-RR'),87,256);
Insert into CHILDSTAT (FIRSTNAME,GENDER,BIRTHDATE,HEIGHT,WEIGHT) values ('tommy','m',to_date('11-DEC-00','DD-MON-RR'),78,167);

commit;