CREATE TABLE "ACFUG"."MYOBJECT" 
   (	"ID" NUMBER NOT NULL ENABLE, 
	"FOO" VARCHAR2(100 BYTE) NOT NULL ENABLE, 
	"GOO" VARCHAR2(4000 BYTE), 
	"MYNUM" NUMBER, 
	 CONSTRAINT "MYOBJECT_PK" PRIMARY KEY ("ID") );


 CREATE TABLE "ACFUG"."STATES" 
   (	"STATE" VARCHAR2(30 BYTE) NOT NULL ENABLE, 
	"ABBREVIATION" VARCHAR2(2 BYTE) NOT NULL ENABLE, 
	 CONSTRAINT "STATES_PK" PRIMARY KEY ("STATE") );




-- INSERTING into STATES
Insert into STATES ("STATE","ABBREVIATION") values ('AMERICAN SAMOA','AS');
Insert into STATES ("STATE","ABBREVIATION") values ('ARIZONA','AZ');
Insert into STATES ("STATE","ABBREVIATION") values ('ARKANSAS','AR');
Insert into STATES ("STATE","ABBREVIATION") values ('CALIFORNIA','CA');
Insert into STATES ("STATE","ABBREVIATION") values ('COLORADO','CO');
Insert into STATES ("STATE","ABBREVIATION") values ('CONNECTICUT','CT');
Insert into STATES ("STATE","ABBREVIATION") values ('DELAWARE','DE');
Insert into STATES ("STATE","ABBREVIATION") values ('DISTRICT OF COLUMBIA','DC');
Insert into STATES ("STATE","ABBREVIATION") values ('FEDERATED STATES OF MICRONESIA','FM');
Insert into STATES ("STATE","ABBREVIATION") values ('FLORIDA','FL');
Insert into STATES ("STATE","ABBREVIATION") values ('ALABAMA','AL');
Insert into STATES ("STATE","ABBREVIATION") values ('ALASKA','AK');
Insert into STATES ("STATE","ABBREVIATION") values ('GEORGIA','GA');
Insert into STATES ("STATE","ABBREVIATION") values ('GUAM','GU');
Insert into STATES ("STATE","ABBREVIATION") values ('HAWAII','HI');
Insert into STATES ("STATE","ABBREVIATION") values ('IDAHO','ID');
Insert into STATES ("STATE","ABBREVIATION") values ('ILLINOIS','IL');
Insert into STATES ("STATE","ABBREVIATION") values ('INDIANA','IN');
Insert into STATES ("STATE","ABBREVIATION") values ('IOWA','IA');
Insert into STATES ("STATE","ABBREVIATION") values ('KANSAS','KS');
Insert into STATES ("STATE","ABBREVIATION") values ('KENTUCKY','KY');
Insert into STATES ("STATE","ABBREVIATION") values ('LOUISIANA','LA');
Insert into STATES ("STATE","ABBREVIATION") values ('MAINE','ME');
Insert into STATES ("STATE","ABBREVIATION") values ('MARSHALL ISLANDS','MH');
Insert into STATES ("STATE","ABBREVIATION") values ('MARYLAND','MD');
Insert into STATES ("STATE","ABBREVIATION") values ('MASSACHUSETTS','MA');
Insert into STATES ("STATE","ABBREVIATION") values ('MICHIGAN','MI');
Insert into STATES ("STATE","ABBREVIATION") values ('MINNESOTA','MN');
Insert into STATES ("STATE","ABBREVIATION") values ('MISSISSIPPI','MS');
Insert into STATES ("STATE","ABBREVIATION") values ('MISSOURI','MO');
Insert into STATES ("STATE","ABBREVIATION") values ('MONTANA','MT');
Insert into STATES ("STATE","ABBREVIATION") values ('NEBRASKA','NE');
Insert into STATES ("STATE","ABBREVIATION") values ('NEVADA','NV');
Insert into STATES ("STATE","ABBREVIATION") values ('NEW HAMPSHIRE','NH');
Insert into STATES ("STATE","ABBREVIATION") values ('NEW JERSEY','NJ');
Insert into STATES ("STATE","ABBREVIATION") values ('NEW MEXICO','NM');
Insert into STATES ("STATE","ABBREVIATION") values ('NEW YORK','NY');
Insert into STATES ("STATE","ABBREVIATION") values ('NORTH CAROLINA','NC');
Insert into STATES ("STATE","ABBREVIATION") values ('NORTH DAKOTA','ND');
Insert into STATES ("STATE","ABBREVIATION") values ('NORTHERN MARIANA ISLANDS','MP');
Insert into STATES ("STATE","ABBREVIATION") values ('OHIO','OH');
Insert into STATES ("STATE","ABBREVIATION") values ('OKLAHOMA','OK');
Insert into STATES ("STATE","ABBREVIATION") values ('OREGON','OR');
Insert into STATES ("STATE","ABBREVIATION") values ('PALAU','PW');
Insert into STATES ("STATE","ABBREVIATION") values ('PENNSYLVANIA','PA');
Insert into STATES ("STATE","ABBREVIATION") values ('PUERTO RICO','PR');
Insert into STATES ("STATE","ABBREVIATION") values ('RHODE ISLAND','RI');
Insert into STATES ("STATE","ABBREVIATION") values ('SOUTH CAROLINA','SC');
Insert into STATES ("STATE","ABBREVIATION") values ('SOUTH DAKOTA','SD');
Insert into STATES ("STATE","ABBREVIATION") values ('TENNESSEE','TN');


-- INSERTING into MYOBJECT
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (8257,'Nam ac nulla.','Charlotte',26);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (4272,'id sapien. Cras','Leilani',847);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (7271,'sit amet metus.','Mufutau',633);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (2258,'nunc, ullamcorper eu,','Taylor',804);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (3020,'ornare tortor at','Moana',994);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (7042,'Mauris magna. Duis','Eric',933);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (9132,'a, scelerisque sed,','Julian',233);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (450,'quis, tristique ac,','Paki',871);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (846,'ornare, lectus ante','Tarik',512);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (5597,'aliquet molestie tellus.','Glenna',287);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (3539,'sed, sapien. Nunc','Ulysses',580);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (9973,'ut ipsum ac','Harper',300);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (7363,'diam. Pellentesque habitant','Elliott',441);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (6255,'Ut tincidunt orci','Hakeem',539);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (6364,'erat volutpat. Nulla','Quon',682);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (2410,'nibh enim, gravida','Kiona',326);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (4360,'sit amet, faucibus','Scott',996);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (9301,'mauris sit amet','Eaton',284);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (2379,'adipiscing lobortis risus.','Sloane',236);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (223,'Kelly','Kelly',759);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (3077,'varius ultrices, mauris','Christopher',934);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (4215,'commodo hendrerit. Donec','Jelani',58);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (4456,'nec, mollis vitae,','Palmer',687);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (7533,'libero at auctor','Adria',190);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (7384,'et netus et','Charissa',669);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (443,'sed dui. Fusce','Whilemina',283);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (6690,'pede. Cras vulputate','Karyn',692);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (625,'mollis. Phasellus libero','Ivy',371);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (8780,'montes, nascetur ridiculus','Erica',300);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (2202,'odio. Etiam ligula','Giselle',666);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (184,'sit amet risus.','Germanessss',7722);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (3872,'Sed diam lorem,','Wyatt',126);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (2131,'sem ut cursus','Regan',258);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (6132,'lacinia. Sed congue,','Kenneth',283);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (5622,'facilisis vitae, orci.','Xyla',625);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (1077,'non, bibendum sed,','Zephania',986);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (718,'lectus justo eu','Edan',292);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (731,'eu dui. Cum','Wilma',92);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (7385,'auctor non, feugiat','Slade',126);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (6735,'Sed pharetra, felis','Deanna',887);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (9698,'pulvinar arcu et','Cailin',583);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (7913,'ridiculus mus. Donec','Solomon',354);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (7395,'aliquam iaculis, lacus','Yetta',848);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (2612,'Duis risus odio,','Sarah',333);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (2708,'eu eros. Nam','Madonna',344);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (7598,'Nunc mauris sapien,','Ingrid',499);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (8917,'justo eu arcu.','Madison',566);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (1223,'volutpat. Nulla facilisis.','Jackson',92);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (9197,'tincidunt orci quis','Minerva',711);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (2784,'Sed nulla ante,','Ariel',18);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (3779,'scelerisque sed, sapien.','Solomon',640);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (149,'Donec est. Nuncassss','Xerxessss',28661);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (8151,'quis lectus. Nullam','Maile',575);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (1789,'et netus et','Astra',71);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (3631,'rhoncus. Donec est.','Mannix',486);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (5716,'Aenean eget metus.','Latifah',492);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (6825,'dictum placerat, augue.','Claire',961);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (7918,'per inceptos hymenaeos.','Yetta',170);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (3085,'tempor erat neque','Roanna',324);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (5407,'venenatis a, magna.','Lucian',356);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (3773,'eu dolor egestas','Vaughan',557);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (3033,'elit. Curabitur sed','Maggie',667);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (7002,'ad litora torquent','Calvin',272);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (3492,'faucibus orci luctus','Quail',32);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (9809,'a, arcu. Sed','Zenaida',773);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (2313,'mauris ut mi.','Vivien',540);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (8140,'nunc nulla vulputate','Slade',355);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (5314,'scelerisque, lorem ipsum','Noble',909);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (7106,'pede. Praesent eu','Jaquelyn',14);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (6441,'Donec nibh. Quisque','Mollie',345);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (3534,'feugiat tellus lorem','Lysandra',703);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (5604,'Nulla dignissim. Maecenas','Orli',542);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (3439,'ante ipsum primis','Fallon',576);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (6973,'id risus quis','Branden',512);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (66,'nec, leo. Morbi','Sonia',538);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (4500,'Nam ligula elit,','Ivan',161);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (2168,'massa. Vestibulum accumsan','Cecilia',861);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (26,'Aliquam fringilla cursusasd','Claudiafff',356);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (6859,'ipsum ac mi','Anthony',247);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (2000,'mollis dui, in','Raya',544);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (5190,'enim. Nunc ut','Brendan',217);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (3571,'ornare. Fusce mollis.','Olympia',364);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (2116,'dictum magna. Ut','Taylor',662);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (1693,'Pellentesque ultricies dignissim','Ryan',386);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (2596,'nisl elementum purus,','David',263);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (8505,'tellus eu augue','Macaulay',537);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (2730,'Cum sociis natoque','Randall',473);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (4691,'non enim commodo','Aileen',989);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (6712,'Aenean massa. Integer','Clarke',29);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (3692,'justo nec ante.','Heather',581);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (5249,'nisl arcu iaculis','Dara',695);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (6416,'senectus et netus','Austin',902);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (605,'penatibus et magnis','Carly',911);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (7787,'a, magna. Lorem','Ivana',52);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (4577,'et ultrices posuere','Kay',927);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (7998,'ante, iaculis nec,','Troy',471);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (6766,'Nam consequat dolor','Joy',46);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (505,'Quisque libero lacus,','Maggie',576);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (1843,'ultrices. Duis volutpat','Dominic',826);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (9328,'dignissim lacus. Aliquam','Olivia',994);
Insert into MYOBJECT ("ID","FOO","GOO","MYNUM") values (null,null,null,null);



