izatwin/CS448
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
Files
main
CS448/Ramez Elmasri, Shamkant Navathe - Fundamentals of Database Systems, Seventh Edition [7th Ed] (Instructor's Edu Resource 1 of 2, Complete Solution Manual with Lab Solutions)-Pearson (2015)/Lab/ch8/86-Auction/consolidated-data.sql
T

1528 lines
63 KiB
SQL
Raw Permalink Blame History

--troy
insert into item values
(1150,'Super Smash Brothers','Video Games:Games:Wii','Like New Condition' || 'Manual Included',
to_date('31-MAR-2008 1130','DD-MON-YYYY HH24MI'),'a100',29.99,1.00,to_date('04-APR-2008 1130','DD-MON-YYYY HH24MI'),null);
insert into item values
(1151,'Battalion Wars','Video Games:Games:Wii','Slightly Used' || 'Manual Included',to_date('31-MAR-2008 1130','DD-MON-YYYY HH24MI'),'a100',19.99,1.00,to_date('04-APR-2008 1130','DD-MON-YYYY HH24MI'),null);
insert into item values
(1152,'Super Mario Galaxy','Video Games:Games:Wii','Brand New; Still in Original Package',to_date('6-MAY-2008 0150','DD-MON-YYYY HH24MI'),'m100',31.99,1.25,to_date('09-MAY-2008 0150','DD-MON-YYYY HH24MI'),null);
insert into item values
(1153,'Boogle','Video Games:Games:Wii','Fair Condition' || 'Manual Not Included',to_date('01-JUN-2008 1130','DD-MON-YYYY HH24MI'),'m100',14.99,1.00,to_date('04-JUN-2008 1130','DD-MON-YYYY HH24MI'),null);
insert into item values
(1154,'Endless Ocean','Video Games:Games:Wii','Brand New' || 'Manual Included',to_date('31-MAR-2008 1130','DD-MON-YYYY HH24MI'),'p100',19.99,3.00,to_date('09-APR-2008 1530','DD-MON-YYYY HH24MI'),null);
insert into item values
(1155,'Metroid Prime3: Corruption','Video Games:Games:Wii','Acceptable',to_date('08-JULY-2008 1420','DD-MON-YYYY HH24MI'),'p100',23.98,2.50,to_date('08-AUG-2008 1620','DD-MON-YYYY HH24MI'),null);
insert into item values
(1156,'Mario Party 8','Video Games:Games:Wii','A Must Have',to_date('30-APR-2008 1130','DD-MON-YYYY HH24MI'),'q100',19.90,4.00,to_date('28-MAY-2008 1130','DD-MON-YYYY HH24MI'),null);
insert into item values
(1157,'Super Paper Mario','Video Games:Games:Wii','Never Opened',to_date('31-MAR-2008 1130','DD-MON-YYYY HH24MI'),'q100',14.99,1.00,to_date('04-APR-2008 1130','DD-MON-YYYY HH24MI'),null);
insert into item values
(1158,'Mario Strikers Charged','Video Games:Games:Wii','Like New Condition' || 'Sorry No Manual',to_date('24-MAR-2008 1030','DD-MON-YYYY HH24MI'),'s100',29.99,1.00,to_date('13-APR-2008 1030','DD-MON-YYYY HH24MI'),null);
insert into item values
(1159,'Sega Superstars Tennis','Video Games:Games:Wii','Hardly Ever Used',to_date('17-APR-2008 1330','DD-MON-YYYY HH24MI'),'s100',23.99,1.00,to_date('27-APR-2008 1330','DD-MON-YYYY HH24MI'),null);
insert into item values
(1160,'Playstion One','Video Games:Systems:Playstation','Used ' ||
'Best Seller; Retail Box',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'a100',20.00,3.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
--Brandon
insert into item values
(1161,'Playstion One','Video Games:Systems:Playstation','Used ' ||
'Power Seller; Ships quick',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'a100',39.99,3.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
--
insert into item values
(1162,'Playstation Two','Video Games:Systems:Playstation' ,'Used ' ||
'Black; Ships quick',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'p100',10.00,1.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
--
insert into item values
(1163,'Playstation Two','Video Games:Systems:Playstation','Brand New ' ||
'Silver; Free shipping',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
's100',39.99,3.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1164,'Playstation Three (20GB) ','Video Games:Systems:Playstation','Used' ||
'Power Seller; Ships quick',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
's100',20.00,2.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1165,' Playstation Three (40GB)','Video Games:Systems:Playstation','Brand New' ||
'Great Buy; Ships quick',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'q100',40.00,2.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1166,'Playstion Three (60GB)','Video Games:Systems:Playstation','Brand New' ||
'Power Seller; Ships quick',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'q100',30.00,2.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1167,'Playstaion Three (80GB)','Video Games:Systems:Playstation','Used' ||
'Good Conditions; Power Seller',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'm100',10.00,1.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1168, 'Playstaion Three (80GB)','Video Games:Systems:Playstation',
'Brand New' || ' In Box; Ships quick',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'm100',20.00,2.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1169, 'Playstaion Three (80GB)','Video Games:Systems:Playstation',
'Brand New' || 'In Box; Ships quick',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'p100',40.00,3.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
-- Andres
insert into item values
(1170,'Nintendo DS System','Video Games:Systems:Nintendo DS','Excellent Condition ' ||
'Best Seller; Retail',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'a100',20.00,3.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1171,'Nintendo DS System Pink','Video Games:Systems:Nintendo DS','Brand New ' ||
'Power Seller; Ships quick',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'a100',39.99,3.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1172,'Nintendo DS System Electric Blue','Video Games:Systems:Nintendo DS','used ' ||
'Power Seller; Ships quick',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'p100',10.00,1.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1173,'Nintendo DS System Handheld','Video Games:Systems:Nintendo DS','Brand New ' ||
'Best Seller; Free shipping',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
's100',39.99,3.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1174,'Nintendo DS System with 6 games','Video Games:Systems:Nintendo DS','used' ||
'Power Seller; Ships quick',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
's100',20.00,2.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1175,'Nintendo DS Lite System with 2 games','Video Games:Systems:Nintendo DS','Brand New' ||
'Black; Ships quick',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'q100',40.00,2.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1176,'Nintendo DS Lite System red','Video Games:Systems:Nintendo DS','Brand New' ||
'Power Seller; Ships quick',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'q100',30.00,2.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1177,'Nintendo DS System with no Power cord','Video Games:Systems:Nintendo DS','used' ||
'Good conditions; Power Seller',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'm100',10.00,1.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1178,'Nintendo DS 2 pack','Video Games:Systems:Nintendo DS','Brand New' ||
' 2 Black items; Ships quick',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'm100',20.00,2.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1179,'Nintendo DS Lite With Grip Magnifier','Video Games:Systems:Nintendo DS','Brand New' ||
'Blue; Ships quick',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'p100',40.00,3.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
--Csc6710
--insert item data
--Group: Ming Fang, Yiyun Wu, Rasmi Nayak
insert into item values
(1060,'Lenovo T61','Computers:PCs:Laptops','Best Seller ',
to_date('11-APR-2008 0000','DD-MON-YYYY HH24MI'),
'a100',1098.00,50.00,
to_date('30-APR-2008 0000','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1061,'Lenovo X61','Computers:PCs:Laptops','Excellent Condition ',
to_date('1-APR-2008 0000','DD-MON-YYYY HH24MI'),
'm100',1349.00,20.00,
to_date('20-APR-2008 0000','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1062,'Lenovo R61','Computers:PCs:Laptops','Excellent Condition ',
to_date('20-MAR-2008 1200','DD-MON-YYYY HH24MI'),
'm100',799.00,10.00,
to_date('20-APR-2008 1200','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1063,'Dell Inspiron 1721','Computers:PCs:Laptops','Brand New ',
to_date('2-MAY-2008 1200','DD-MON-YYYY HH24MI'),
'p100',850.00,5.00,
to_date('5-MAY-2008 1200','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1064,'Dell XPS 400','Computers:PCs:Laptops','Used ',
to_date('12-APR-2008 0500','DD-MON-YYYY HH24MI'),
'q100',850.00,5.00,
to_date('5-MAY-2008 0700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1065,'Sony VAIO AR630','Computers:PCs:Laptops','Exellent Condition ',
to_date('2-APR-2008 0900','DD-MON-YYYY HH24MI'),
's100',999.00,10.00,
to_date('12-APR-2008 1200','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1066,'Compaq Presario T2330 ','Computers:PCs:Laptops','Brand New ',
to_date('10-APR-2008 1400','DD-MON-YYYY HH24MI'),
'a100',569.00,10.00,
to_date('20-APR-2008 1300','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1067,'HP Pavilion dv9700','Computers:PCs:Laptops','Brand New ',
to_date('15-APR-2008 1400','DD-MON-YYYY HH24MI'),
'm100',979.00,20.00,
to_date('20-MAY-2008 0000','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1068,'Toshiba Satellite A215','Computers:PCs:Laptops','Used ',
to_date('1-APR-2008 0000','DD-MON-YYYY HH24MI'),
'p100',499.00,5.00,
to_date('10-APR-2008 0000','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1069,'MacBook','Computers:PCs:Laptops','Brand New ',
to_date('23-APR-2008 1200','DD-MON-YYYY HH24MI'),
'q100',1099.00,50.00,
to_date('30-APR-2008 1200','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1070,'Western Digital 250G Internal 5400prm','Computers:Storage:Hard Drives','Excellent Condition ',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'a100',98.00,2.00,
to_date('30-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1071,'Western Digital 500G External SATA 7200rpm','Computers:Storage:Hard Drives','Brand New ',
to_date('11-MAY-2008 1400','DD-MON-YYYY HH24MI'),
'm100',108.00,2.00,
to_date('20-MAY-2008 1400','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1072,'Seagate 250G InternalSATA 5400rpm','Computers:Storage:Hard Drives','Best Seller ',
to_date('1-MAY-2008 1600','DD-MON-YYYY HH24MI'),
'q100',89.0,5.00,
to_date('15-MAY-2008 1730','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1073,'Seagate 120G External7200rpm','Computers:Storage:Hard Drives','Used ',
to_date('5-MAY-2008 1000','DD-MON-YYYY HH24MI'),
's100',43.0,1.00,
to_date('11-MAY-2008 1230','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1074,'Toshiba 320G External7200rpm','Computers:Storage:Hard Drives','Brand New ',
to_date('23-APR-2008 1000','DD-MON-YYYY HH24MI'),
'a100',134.0,5.00,
to_date('30-APR-2008 1230','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1075,'Western Digital 1500G External SATA 7200prm','Computers:Storage:Hard Drives','Excellent Condition ',
to_date('4-MAR-2008 1200','DD-MON-YYYY HH24MI'),
'm100',256.00,10.00,
to_date('4-APR-2008 1200','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1076,'Seagate 200G Internal SATA 7200prm','Computers:Storage:Hard Drives','Excellent Condition ',
to_date('4-APR-2008 0800','DD-MON-YYYY HH24MI'),
's100',100.00,3.00,
to_date('17-APR-2008 0800','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1077,'Toshiba 60G External 5400prm','Computers:Storage:Hard Drives','Used ',
to_date('20-APR-2008 0830','DD-MON-YYYY HH24MI'),
'p100',20.00,1.00,
to_date('30-APR-2008 0830','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1078,'Sumsung 120 External 7200prm','Computers:Storage:Hard Drives','Brand New ',
to_date('1-MAY-2008 1630','DD-MON-YYYY HH24MI'),
'q100',79.00,1.00,
to_date('30-MAY-2008 0830','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1079,'Western Digital 100G Internal SATA 7200prm','Computers:Storage:Hard Drives','Brand New ',
to_date('5-MAY-2008 0000','DD-MON-YYYY HH24MI'),
'a100',90.00,1.00,
to_date('25-MAY-2008 0000','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1080,'Kingston 8 GB','Computers:Storage:Flash Drives','New ' ||
'Best Seller; Hi-speed Data traveller',
to_date('22-APR-2008 1700','DD-MON-YYYY HH24MI'),
'a100',10.00,2.00,
to_date('29-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1081,'Corsair 8 GB ','Computers:Storage:Flash Drives','Excellent condition ' ||
'Best Seller; Flash Voyager',
to_date('21-APR-2008 1800','DD-MON-YYYY HH24MI'),
'p100',30.00,2.00,
to_date('28-APR-2008 1800','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1082,'SanDusk 2GB','Computers:Storage:Flash Drives','Used but very good condition' ||
'Best Seller; Data cruzer',
to_date('20-APR-2008 1500','DD-MON-YYYY HH24MI'),
'p100',20.00,2.00,
to_date('27-APR-2008 1500','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1083,'EDGE 16 GB','Computers:Storage:Flash Drives','Excellent condition' ||
'Best Seller; Disk to go',
to_date('21-APR-2008 1400','DD-MON-YYYY HH24MI'),
'a100',10.00,2.00,
to_date('28-APR-2008 1400','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1084,'Transcend 4 GB','Computers:Storage:Flash Drives','New ' ||
'Best Seller; Jet Flash',
to_date('19-APR-2008 1700','DD-MON-YYYY HH24MI'),
'a100',20.00,2.00,
to_date('26-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1085,'Lexar Media 4 GB','Computers:Storage:Flash Drives','Excellent condition ' ||
'Best Seller; jump Drive FireFly',
to_date('21-APR-2008 1800','DD-MON-YYYY HH24MI'),
'm100',39.99,2.00,
to_date('28-APR-2008 1800','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1086,'Verabatim 4 GB','Computers:Storage:Flash Drives','Used but good condition ' ||
'Best Seller; Store n Go',
to_date('23-APR-2008 1900','DD-MON-YYYY HH24MI'),
's100',49.99,2.00,
to_date('30-APR-2008 1900','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1087,'Kingston 2 GB','Computers:Storage:Flash Drives','New ' ||
'Best Seller; Jet speed Data traveller',
to_date('22-APR-2008 2300','DD-MON-YYYY HH24MI'),
'q100',19.99,2.00,
to_date('29-APR-2008 2300','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1088,'Crucial 2 GB','Computers:Storage:Flash Drives','Excellent condition ' ||
'Best Seller; Gizmo Flash Drive',
to_date('23-APR-2008 2100','DD-MON-YYYY HH24MI'),
's100',29.99,2.00,
to_date('30-APR-2008 2100','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1089,'SanDisk 4 GB','Computers:Storage:Flash Drives','New ' ||
'Best Seller; cruzer Titanium',
to_date('21-APR-2008 2200','DD-MON-YYYY HH24MI'),
's100',14.99,2.00,
to_date('28-APR-2008 2200','DD-MON-YYYY HH24MI'),
null);
--Group Project
--CSC 4710
--Phase 1---Part 1
--Group Member---Nazia Islam, Violeta Deneva, Senait Kidane
insert into item values
(1120,'Best of Smooth Jazz','Music:Jazz','Audio CD by various artists. CD is Brand new and sealed. There are 11 tracks in the CD',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'a100',10.99,3.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1121,'Smooth Jazz at Midnight','Music:Jazz','This CD, released on Shanachie is a compliation of some of the best know "smooth jazz" artists',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'a100',10.99,2.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1122,'Legend of Jazz','Music:Jazz','Five CDs all in their own jewel cases',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'm100',13.95,1.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1123,'Jazz for Kids: Sing, Clap, Wiggle and Shake','Music:Jazz','Items is Brand New Factory-Sealed and are from licensed Distributors here in the USA',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'm100',10.99,2.99,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1124,'Pure Jazz','Music:Jazz','LOOKS LIKE NEW - PLAYS GREAT !
Disc is FLAWLESS / EXCELLENT shape overall',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'p100',9.97,3.01,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1125,'Time Out','Music:Jazz','All the CD are original and come in cases with their original artwork',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'p100',7.97,2.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1126,'Nickys Jazz for Kids','Music:Jazz','Items is brand new and sealed straight from the factory',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'q100',18.98,3.99,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1127,'The Relaxing Jazz Piano','Music:Jazz','CD by various artists. It is a Brand new CD',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'q100',11.98,3.19,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1128,'Def Jazz','Music:Jazz','All CDs are BRAND NEW, Factory Sealed. We do not sell Bootleg or Used items',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
's100',18.98,2.34,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1129,'The Very Best Of Smooth Jazz Guitar','Music:Jazz','This product is brand new, sealed, and staright fron the U.S. manufacturer or dusbutor',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
's100',17.98,3.50,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1130,'Spirit of Africa','Music:World','Brand new sealed world music cd Spirit Of Africa' ||
'The bes of contemporary african rhythms',
to_date('21-APR-2008 1200','DD-MON-YYYY HH24MI'),
'a100',0.01,0.50,
to_date('28-APR-2008 1200','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1131,'Thunderflute Bryan Akipa','Music:World','A combination of singing, drumming, and Native American flute from Dakota flutist Bryan Akipa' ||
'Thunderflute is a beautiful meditative recording perfect for a serene and relaxing listening experience.' ,
to_date('21-APR-2008 1000','DD-MON-YYYY HH24MI'),
'm100',11.99,1.00,
to_date('28-APR-2008 1000','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1132,'Who Let The Dogs Out - Baha Men','Music:World','WHO LET THE DOGS OUT, the single from Baha Men, features four versions of the title songs.',
to_date('21-APR-2008 2300','DD-MON-YYYY HH24MI'),
'a100',2.00,0.25,
to_date('28-APR-2008 2300','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1133,'SOUL Of URBAN VODOU - Bonnie Devlin','Music:World','A journey to the heart of the urban Vodou experience with Afro-Caribbean percussionist Bonnie Devlin ' ||
'"Soul of Urban Vodou" is a milestone in the realm of Afro-Haitian percussion',
to_date('21-APR-2008 1300','DD-MON-YYYY HH24MI'),
'm100',9.95,0.50,
to_date('28-APR-2008 1300','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1134, 'SELENA - Unforgettable: The Studio Album','Music:World','Additional personnel: Nando "Guero" Dominguez (vocals). UNFORGETTABLE provides a definitive collection of her greatest hits.',
to_date('21-APR-2008 2000','DD-MON-YYYY HH24MI'),
'p100',10.99,1.00,
to_date('28-APR-2008 2000','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1135,'Best Of Andrea Bocelli: Vivere','Music:World','Issued in 2007, this Andrea Bocelli collection presents many of the Italian classical/pop-crossover artists most memorable vocal performances. ',
to_date('21-APR-2008 0900','DD-MON-YYYY HH24MI'),
'p100',9.99,1.00,
to_date('28-APR-2008 0900','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1136,'GIPSY KINGS - VERY BEST OF','Music:World','TRACKS:'|| '1.Bambaleo' || '2.Volare' || '3.Baila Me' || '4.Solo Por Ti' || '5.Vamos A Bailar' ||
'6.A Mi Manera' || '7.Tu Quieres Volver' || '8.Bem Bem Maria' || '9.Soy' || '10.Moorea' || '11.Sin Ella' || '12.Djobi, Djoba' || '13.Hit Mix 99' || '14.La Quiero' ||
'15.Oh Eh Oh Eh' || '16.Pida Me La' || '17.Petite Noya' || '18.Como Ayer' || '19.Como Siento Yo' || '20.Hotel California [Spanish Mix]',
to_date('21-APR-2008 0600','DD-MON-YYYY HH24MI'),
'q100',8.95,0.50,
to_date('28-APR-2008 0600','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1137,'Edith Piaf The Souvenirs Album','Music:World','Brand new sealed CD on the Laserlight label.',
to_date('21-APR-2008 1600','DD-MON-YYYY HH24MI'),
'q100',9.99,0.50,
to_date('28-APR-2008 1600','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1138,'Enrique Iglesias - Quizas','Music:World', 'Track listing' || '1. Tres Palabras' || '2. Para Que La Vida' || '3. La Chica De Ayer' || '4. Mentiroso' || '5. Quizas' ||
'6. Pienso En Ti' || '7. Marta' || '8. Riendas' || '9. Mamacita' || '10. Mentiroso - (mariachi version)' || '11. No Apagues La Luz',
to_date('21-APR-2008 2100','DD-MON-YYYY HH24MI'),
'q100',9.99,1.00,
to_date('28-APR-2008 2100','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1139,'Jennifer Lopez - Como Ama una Mujer 2007','Music:World','Song List:' || '1. Qu?Hiciste' || '2. Me Haces Falta' || '3. Como Ama Una Mujer' || '4. Te Voy A Querer' || '5. Por Que Te Marchas' ||
'6. Por Arriesgarnos' || '7. Tu' || '8. Amarte Es Todo' || '9. Apresurate' || '10. Sola' || '11. Adios ',
to_date('21-APR-2008 2200','DD-MON-YYYY HH24MI'),
'a100',1.99,1.00,
to_date('28-APR-2008 2200','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1140,' Xbox 360 Pro Value Bundle','Video Games:Systems:XBox 360','This is a Brand New, never-used, Never-Opened Xbox 360 console',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'a100',314.99,15.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1141,'XBOX 360 PREMIUM GOLD PACK VIDEO GAME SYSTEM','Video Games:Systems:XBox 360','The Xbox 360 Gold come Bundle up with:Xbox 360 Premium Pack Accesories',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'a100',435.00,7.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1142,'Xbox 360 Elite Game System','Video Games:Systems:XBox 360','This is an XBOX 360 with 120 GB Hard Drive with all cables and a remote control for DVD',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'm100',400.00,11.50,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1143,'Microsoft Xbox 360 Pro System','Video Games:Systems:XBox 360','This is a brand new in box, Xbox 360 go Pro. This system comes with 2 games.',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'm100',284.99,5.99,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1144,'Xbox 360 Core Game System','Video Games:Systems:XBox 360','Here we have one of the best high-definition gaming systems in the world.' || 'This auction is for an Xbox 360 Core game system with NO accessories.',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'p100',114.28,4.99,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1145,'Microsoft Xbox 360 Elite System','Video Games:Systems:XBox 360','Features:'|| 'Audio Output: Surround Sound' || 'Expansion Slots Total: 2 ( 2 ) x memory' || 'Max. Resolution: 1920 x 1080' || 'Processor: 1 x IBM PowerPC 3 cores 3.2 GHz',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'p100',320.00,5.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1146,'Microsoft Xbox 360 Premium Edition System','Video Games:Systems:XBox 360','Microsoft xBox360 Premium System Includes 20GB HDD, Wireless Controller, Standard/High Def. AV cable, Headset, and Power Supply. Ready for Gaming!',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'q100',99.00,2.50,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1147,'Microsoft Xbox 360 Go Pro 20gb','Video Games:Systems:XBox 360','Brand new and sealed',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'q100',309.99,1.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1148,'Microsoft Xbox 360 Arcade','Video Games:Systems:XBox 360','Play together today with Xbox 360 Arcade, including the Xbox 360 console, wireless controller, and memory unit',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
's100',29.99,5.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1149,'Microsoft Xbox 360 Console Lot w/ 20 GB Hard Drive HDD','Video Games:Systems:XBox 360','Features:' ||
'Audio Output:Surround Sound' || 'Expansion Slots Total:2 ( 2 ) x memory' ||
'Max. Resolution:1920 x 1080' || 'Processor:1 x IBM PowerPC 3 cores 3.2 GHz' ||
'Video Output:ATI Xbox 360 - 256-bit - 2D/3D graphics acceleration' ||
'Up for auction is a excellent mint used xbox 360 game console with a 20 gig hard drive.',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
's100',249.99,2.50,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
--CSc4710 Database Systems
--Spring 2008
--Group Project - Phase 1, Part 1
--Andrew Velez, Umar Arshad, Nick Larsen, Philip Rogers
insert into item values
(1000,'Creations of Microbiology','Books:Biology','Minor Wear and Tear',
to_date('21-JAN-2008 1430','DD-MON-YYYY HH24MI'),'p100',5.00,1.00,
to_date('31-JAN-2008 1430','DD-MON-YYYY HH24MI'),null);
insert into item values
(1001,'Crustaceans','Books:Biology','Excellent Condition',
to_date('21-FEB-2008 1100','DD-MON-YYYY HH24MI'),'q100',2.00,0.50,
to_date('27-FEB-2008 1100','DD-MON-YYYY HH24MI'),null);
insert into item values
(1002,'Undersea Livestock','Books:Biology','Excellent Condition',
to_date('21-JAN-2008 1430','DD-MON-YYYY HH24MI'),'s100',10.00,1.00,
to_date('27-FEB-2008 1200','DD-MON-YYYY HH24MI'),null);
insert into item values
(1003,'The Imbred Llama Problem','Books:Biology','Minor Wear and Tear',
to_date('21-MAR-2008 0800','DD-MON-YYYY HH24MI'),'m100',1.00,1.00,
to_date('31-MAR-2008 0800','DD-MON-YYYY HH24MI'),null);
insert into item values
(1004,'Eggs and their Formation','Books:Biology','Great Condition',
to_date('01-MAR-2008 0900','DD-MON-YYYY HH24MI'),'p100',5.00,10.00,
to_date('15-MAR-2008 0930','DD-MON-YYYY HH24MI'),null);
insert into item values
(1005,'Mammals, Mammals and more Mammals','Books:Biology',
'Minor Highlighting',
to_date('15-NOV-2007 1430','DD-MON-YYYY HH24MI'),'p100',5.00,2.00,
to_date('21-NOV-2007 1430','DD-MON-YYYY HH24MI'),'m100');
insert into item values
(1006,'Basic Life Forms','Books:Biology','Minor Wear and Tear',
to_date('29-FEB-2008 1800','DD-MON-YYYY HH24MI'),'m100',2.00,1.00,
to_date('05-MAR-2008 0800','DD-MON-YYYY HH24MI'),null);
insert into item values
(1007,'Interstellar Bacteria','Books:Biology','some earmarking',
to_date('05-MAR-2008 1430','DD-MON-YYYY HH24MI'),'s100',7.50,1.00,
to_date('21-MAR-2008 1430','DD-MON-YYYY HH24MI'),null);
insert into item values
(1008,'150 Species of Worms','Books:Biology','Like New',
to_date('21-JAN-2008 1500','DD-MON-YYYY HH24MI'),'p100',3.00,0.50,
to_date('01-FEB-2008 1500','DD-MON-YYYY HH24MI'),null);
insert into item values
(1009,'Insects under 5mm','Books:Biology','Like New',
to_date('30-MAR-2008 1700','DD-MON-YYYY HH24MI'),'m100',5.00,1.00,
to_date('06-APR-2008 1700','DD-MON-YYYY HH24MI'),null);
insert into item values
( 1010,
'Oracle 10g Programming: A Primer (Paperback)',
'Books:Computers',
'The Resource for Oracle DB programming. Excellent Condition!!!',
to_date('3-Apr-2008 1300','DD-MON-YYYY HH24MI'),
'a100',
35.00,
1.00,
to_date('10-Apr-2008 1300','DD-MON-YYYY HH24MI'),
null);
insert into item values
( 1011,
'C Programming: A Modern Approach (Paperback)',
'Books:Computers',
'A great introduction to C Programming. Good condition,',
to_date('5-Apr-2008 1100','DD-MON-YYYY HH24MI'),
'q100',
45.00,
1.00,
to_date('12-Apr-2008 1100','DD-MON-YYYY HH24MI'),
null);
insert into item values
( 1012,
'Art of Computer Programming, The, Volumes 1-3 Boxed Set',
'Books:Computers',
'Indisputabily the best book for computer algorithms. Mint Condition!!!',
to_date('5-Apr-2008 1800','DD-MON-YYYY HH24MI'),
's100',
75.00,
1.00,
to_date('12-Apr-2008 1800','DD-MON-YYYY HH24MI'),
null);
insert into item values
( 1013,
'Introduction to MATLAB and Simulink, Third Edition',
'Books:Computers',
'Good condition, small tear in the back cover, Excellent reference!',
to_date('15-Apr-2008 1900','DD-MON-YYYY HH24MI'),
'm100',
20.00,
0.50,
to_date('22-Apr-2008 1900','DD-MON-YYYY HH24MI'),
null);
insert into item values
( 1014,
'UNIX: The Complete Reference, Second Edition',
'Books:Computers',
'Fair condition, some highlighting. good Unix resource!',
to_date('14-Apr-2008 2100','DD-MON-YYYY HH24MI'),
'p100',
23.00,
0.50,
to_date('21-Apr-2008 2100','DD-MON-YYYY HH24MI'),
null);
insert into item values
( 1015,
'Pro WPF: Windows Presentation Foundation in .NET 3.0',
'Books:Computers',
'Like New!!! Great source for Windows GUI programming.',
to_date('13-Apr-2008 2000','DD-MON-YYYY HH24MI'),
'a100',
15.00,
0.50,
to_date('20-Apr-2008 2000','DD-MON-YYYY HH24MI'),
null);
insert into item values
( 1016,
'Pro LINQ: Language Integrated Query in C# 2008 (Paperback)',
'Books:Computers',
'The best book about LINQ so far!! small rip on the cover, otherwise in great shape',
to_date('10-Apr-2008 2000','DD-MON-YYYY HH24MI'),
'q100',
25.00,
1.00,
to_date('27-Apr-2008 2000','DD-MON-YYYY HH24MI'),
null);
insert into item values
( 1017,
'Ajax: The Definitive Guide (Paperback)',
'Books:Computers',
'Excellent reference for AJAX. Tons of examples. Cover is bent',
to_date('9-Apr-2008 2000','DD-MON-YYYY HH24MI'),
'm100',
27.00,
0.50,
to_date('26-Apr-2008 2000','DD-MON-YYYY HH24MI'),
null);
insert into item values
( 1018,
'Oracle Database 10g: The Complete Reference',
'Books:Computers',
'Slight wear from constant use! Excellent desk reference. Also see Sunderramans Oracle Book.',
to_date('3-Apr-2008 2000','DD-MON-YYYY HH24MI'),
'a100',
26.00,
0.50,
to_date('10-Apr-2008 2000','DD-MON-YYYY HH24MI'),
null);
insert into item values
( 1019,
'Visualizing Data',
'Books:Computers',
'Great book written by Ben Fry, back cover is ripped.',
to_date('5-Apr-2008 1800','DD-MON-YYYY HH24MI'),
'm100',
10.00,
0.50,
to_date('12-Apr-2008 1800','DD-MON-YYYY HH24MI'),
null);
INSERT INTO item VALUES
(1020, 'Micro Economics Theory', 'Books:Economics',
'Signed by Eugene Fama!!',
to_date('23-MAR-2008 1231', 'DD-MON-YYYY HH24MI'),
'p100', 39.00, 1.00,
to_date('28-MAR-2008 1231', 'DD-MON-YYYY HH24MI'),
null);
INSERT INTO item VALUES
(1021, 'Game Theory', 'Books:Economics',
'Comes with book on tape.',
to_date('29-MAR-2008 0943', 'DD-MON-YYYY HH24MI'),
'q100', 80.00, 2.50,
to_date('05-APR-2008 0943', 'DD-MON-YYYY HH24MI'),
null);
INSERT INTO item VALUES
(1022, 'Capitalism Explained', 'Books:Economics',
'Missing chapters 4-8, not sure what happened to them',
to_date('24-MAR-2008 1445', 'DD-MON-YYYY HH24MI'),
's100', 18.00, 0.50,
to_date('27-MAR-2008 1445', 'DD-MON-YYYY HH24MI'),
null);
INSERT INTO item VALUES
(1023, 'Economics and Credit', 'Books:Economics',
'Still in wrapper, comes with media CD',
to_date('27-MAR-2008 1120', 'DD-MON-YYYY HH24MI'),
'a100', 55.00, 4.00,
to_date('03-APR-2008 1120', 'DD-MON-YYYY HH24MI'),
null);
INSERT INTO item VALUES
(1024, 'Resource Allocation 101', 'Books:Economics',
'3rd edition, good condition',
to_date('01-APR-2008 123', 'DD-MON-YYYY HH24MI'),
'm100', 45.00, 2.00,
to_date('07-APR-2008 123', 'DD-MON-YYYY HH24MI'),
null);
INSERT INTO item VALUES
(1025, 'Value and Capital', 'Books:Economics',
'ON SALE CHEAP, NEED BEER MONEY',
to_date('23-MAR-2008 1645', 'DD-MON-YYYY HH24MI'),
'p100', 22.00, 1.00,
to_date('28-MAR-2008 1645', 'DD-MON-YYYY HH24MI'),
null);
INSERT INTO item VALUES
(1026, 'Macro Economics Introduction', 'Books:Economics',
'Get this now, sold out from book store last semester!!',
to_date('26-MAR-2008 1829', 'DD-MON-YYYY HH24MI'),
'q100', 105.00, 3.00,
to_date('02-APR-2008 1829', 'DD-MON-YYYY HH24MI'),
null);
INSERT INTO item VALUES
(1027, 'The Wealth of Nations', 'Books:Economics',
'First Edition, Excellent Condition',
to_date('28-MAR-2008 2108', 'DD-MON-YYYY HH24MI'),
's100', 600.00, 20.00,
to_date('10-APR-2008 2108', 'DD-MON-YYYY HH24MI'),
null);
INSERT INTO item VALUES
(1028, 'Our Currency Our Country', 'Books:Economics',
'This book is only held together by duct tape.',
to_date('27-MAR-2008 1055', 'DD-MON-YYYY HH24MI'),
'm100', 25.00, 1.00,
to_date('03-APR-2008 1055', 'DD-MON-YYYY HH24MI'),
null);
INSERT INTO item VALUES
(1029, 'The FairTax Book', 'Books:Economics',
'Bestseller on income tax reform',
to_date('28-MAR-2008 2311', 'DD-MON-YYYY HH24MI'),
'q100', 70.00, 2.50,
to_date('04-APR-2008 2311', 'DD-MON-YYYY HH24MI'),
null);
insert into item values
(1030,'The Life of Pi','Books:Fiction','Cover is bent, one corner has a small tear.',
to_date('1-APR-2008 1100','DD-MON-YYYY HH24MI'),
'm100',3.00,0.50,
to_date('10-APR-2008 1100','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1031,'Crime and Punishment','Books:Fiction','Perfect condition hardcover, like new.',
to_date('4-APR-2008 1200','DD-MON-YYYY HH24MI'),
'p100',5.00,0.50,
to_date('14-APR-2008 1200','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1032,'Catch-22','Books:Fiction','Excellent book about the economics of the food industry and successful war tactics. Like new.',
to_date('3-MAY-2008 1200','DD-MON-YYYY HH24MI'),
'p100',3.00,1.00,
to_date('13-MAY-2008 1200','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1033,'Nineteen Eighty-Four','Books:Fiction','Good condition, great book.',
to_date('2-APR-2008 0800','DD-MON-YYYY HH24MI'),
's100',3.00,1.00,
to_date('16-APR-2018 0900','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1034,'Anna Karenina','Books:Fiction','A classic, in great condition. Hardcover.',
to_date('6-APR-2008 1400','DD-MON-YYYY HH24MI'),
'm100',7.00,1.00,
to_date('16-APR-2008 1400','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1035,'The Brothers Karamazov','Books:Fiction','Softcover in perfect condition.',
to_date('4-JUN-2008 0500','DD-MON-YYYY HH24MI'),
'a100',3.00,0.50,
to_date('14-JUN-2008 0500','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1036,'For Whom the Bell Tolls','Books:Fiction','Softcover. Dog chewed parts off the cover but book is in otherwise good condition.',
to_date('5-APR-2008 1500','DD-MON-YYYY HH24MI'),
'p100',0.50,0.10,
to_date('15-APR-2008 1500','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1037,'The Stranger','Books:Fiction','Excellent book by Albert Camus, translated by Matthew Ward. Great condition.',
to_date('24-APR-2008 2000','DD-MON-YYYY HH24MI'),
'p100',4.00,1.25,
to_date('28-APR-2008 2000','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1038,'David Copperfield','Books:Fiction','Paperback, cover still has sharp corners. Great book too!',
to_date('10-JUN-2008 0430','DD-MON-YYYY HH24MI'),
's100',3.00,1.00,
to_date('18-JUN-2008 1230','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1039,'The Complete Sherlock Holmes','Books:Fiction','Hardcover, classic. Like new.',
to_date('12-JUN-2008 0400','DD-MON-YYYY HH24MI'),
'a100',9.00,1.00,
to_date('13-JUN-2008 1200','DD-MON-YYYY HH24MI'),
null);
--Pavan
--DVDs:Action
--
--
insert into item values
(1090,'No Country for Old Men','DVDs:Action',
'Best Seller collectors edition' ||
'Winner 4 Oscar awards including best movie',
to_date('20-APR-2008 1400','DD-MON-YYYY HH24MI'),
'a100',18.00,3.00,
to_date('27-APR-2008 1500','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1091,'Rambo','DVDs:Action',
'Sylvester Stallone strikes again as John Rambo'||
'to venture into war-torn Burma,'||
'and rescue a group of Christian aid workers' ||
'who were kidnapped by the ruthless local infantry unit.',
to_date('23-APR-2008 1300','DD-MON-YYYY HH24MI'),
'm100',15.00,2.00,
to_date('28-APR-2008 1600','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1092,'Bourne Ultimatum','DVDs:Action','In the third and final installment'||
' Bourne dodges new, superior assassins as he searches for his unknown past'||
' while a government agent tries to track him down.'||'Dont miss the climax',
to_date('29-MAR-2008 1500','DD-MON-YYYY HH24MI'),
'p100',20.00,0.50,
to_date('5-APR-2008 1600','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1093,'I am Legend','DVDs:Action','Widescreen edition'||
'Often surprising in its focus on loneliness and loss,'||
'this thoughtful, eerie, and restrained sci-fi horror film'||
'provides a parade of startling visuals,'||
'but never allows special effects to overcome the human element.',
to_date('8-MAR-2008 0900','DD-MON-YYYY HH24MI'),
'q100',15.95,1.00,
to_date('16-MAR-2008 1500','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1094,'Jumper','DVDs:Action','PG-13'||
'A genetic anomaly allows a young man to teleport himself anywhere.'||
'He discovers this gift has existed for centuries and finds himself in a war'||
'that has been raging for thousands of years between Jumpers'||
'and those who have sworn to kill them.'||
'excellently paced action thriller',
to_date('27-APR-2008 1000','DD-MON-YYYY HH24MI'),
's100',10.00,6.00,
to_date('01-MAY-2008 1200','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1095,'National Treasure','DVDs:Action','Treasure hunter Benjamin Franklin Gates'||
'looks to discover the truth behind the assassination of Abraham Lincoln,'||
'by uncovering the mystery within the 18 pages missing'||
'from assassin John Wilkes Booths diary.',
to_date('27-APR-2008 1000','DD-MON-YYYY HH24MI'),
'a100',10.00,6.00,
to_date('01-MAY-2008 1200','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1096,'Transformers','DVDs:Action',
'A war re-erupts on Earth between two robotic clans,'||
'the heroic Autobots and the evil Decepticons,'||
'leaving the fate of mankind hanging in the balance.'||
'Action sequences with excellent graphics'||
'another master piece from Speil Berg',
to_date('21-APR-2008 1900','DD-MON-YYYY HH24MI'),
'm100',10.00,6.00,
to_date('01-MAY-2009 0000','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1097,'Race','DVDs:Action','Suspense Thriller'||
'Story has unexpected twists till the end',
to_date('01-APR-2008 2000','DD-MON-YYYY HH24MI'),
'p100',12.00,3.00,
to_date('09-APR-2008 2200','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1098,'Indiana Jones 4','DVDs:Action',
'Most anticipated suspense thriller from director Steven Spielberg',
to_date('02-JUN-2008 0800','DD-MON-YYYY HH24MI'),
'q100',20.00,1.00,
to_date('22-JUN-2008 1000','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1099,'Transporter 2','DVDs:Action',
'Mercenary Frank Martin, who specializes moving goods of all kinds,'||
'surfaces again this time in Miami,'||
'Florida when he is implicated in the kidnapping of'||
'the young son of a powerful USA official.',
to_date('12-MAR-2008 1130','DD-MON-YYYY HH24MI'),
's100',15.00,2.00,
to_date('26-MAR-2008 ','DD-MON-YYYY HH24MI'),
null);
--Anusha
--DVDs:Comedy
insert into item values
(1100,'Enchanted','DVDs:Comedy','PG:'||
'Classic Disney animation meets contemporary urban chaos '||
'when a frightened princess,'||
'is banished from her magical animated homeland to modern day New York City'||
'in a romantic comedy',
to_date('20-AUG-2008 1400','DD-MON-YYYY HH24MI'),
's100',18.00,3.00,
to_date('27-AUG-2008 1500','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1101,'Bee Movie','DVDs:Comedy','PG:'||
'Bee Movie is a comedy that will change everything '||
'you think you know about bees. ',
to_date('24-AUG-2008 1300','DD-MON-YYYY HH24MI'),
'q100',15.00,2.00,
to_date('28-AUG-2008 1600','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1102,'Cars','DVDs:Comedy','G:'||'A pedal-to-the-metal race car '||
'determined to prove his worth on the tracks discovers that '||
'life is not always about crossing the finish line first',
to_date('29-SEP-2008 1500','DD-MON-YYYY HH24MI'),
'a100',11.99,1.00,
to_date('5-OCT-2008 1600','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1103,'The Longest Yard','DVDs:Comedy','PG:||One of the best-remembered sports movies '||
'of the 1970s gets a humorous makeover in this comedy.',
to_date('8-OCT-2008 0900','DD-MON-YYYY HH24MI'),
'm100',20.00,1.00,
to_date('16-OCT-2008 1500','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1104,'Mad Money','DVDs:Comedy','Deep inside the most secure bank in America,'||
'three desperate women from different worlds cook up the most unlikely heist of the century:'||
'Smuggle out millions of dollars in worn-out currency '||
'headed for a Federal Reserve shredder every day.',
to_date('27-APR-2008 1000','DD-MON-YYYY HH24MI'),
's100',10.00,6.00,
to_date('01-MAY-2008 1200','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1105,'Legally Blonde','DVDs:Comedy','When a blonde sorority queen is dumped by her boyfriend,'||
'she decides to follow him to law school to get him back and, once there,'||
'learns she has more legal savvy than she ever imagined.',
to_date('27-APR-2008 1000','DD-MON-YYYY HH24MI'),
'p100',10.00,6.00,
to_date('01-MAY-2008 1200','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1106,'Game Plan','DVDs:Comedy','PG'||' Gridiron Gang star Dwayne Johnson '||
'picks up the pigskin once again for this sports-themed family comedy '||
'concerning a football superstar who abandons the gridiron to'||
' answer the call of fatherhood.',
to_date('21-DEC-2008 1900','DD-MON-YYYY HH24MI'),
'q100',10.00,6.00,
to_date('01-JAN-2009 2330','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1107,'Alvin and the Chipmunks','DVDs:Comedy','Alvin, Simon, and Theodore are back '||
'in computer-animation following the further adventures '||
'of the worlds most adorable singing trio.',
to_date('01-DEC-2008 2000','DD-MON-YYYY HH24MI'),
'a100',12.00,3.00,
to_date('25-DEC-2008 2200','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1108,'Juno','DVDs:Comedy',' PG-13:'||'Faced with an unplanned pregnancy,'||
'an offbeat young woman makes an unusual decision regarding her unborn child.',
to_date('02-NOV-2008 0800','DD-MON-YYYY HH24MI'),
's100',20.00,1.00,
to_date('22-NOV-2008 1000','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1109,'27 Dresses','DVDs:Comedy','PG-13:'||'After serving as a bridesmaid 27 times,'||
'a young woman wrestles with the idea of standing by her sisters side'||
'as her sibling marries the man she is secretly in love with.',
to_date('12-MAY-2008 1130','DD-MON-YYYY HH24MI'),
'p100',25.00,2.00,
to_date('12-JUN-2008 ','DD-MON-YYYY HH24MI'),
null);
--Sandeep
--Music:Blues
insert into item values
(1110,'Classic female blues','Music:Blues','Good folk songs',
to_date('20-AUG-2008 1400','DD-MON-YYYY HH24MI'),
'a100',18.00,3.00,
to_date('27-AUG-2008 1500','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1111,'Country blues','Music:Blues','Acoustic guitar driven forms of blues',
to_date('24-AUG-2008 1300','DD-MON-YYYY HH24MI'),
'm100',15.00,2.00,
to_date('28-AUG-2008 1600','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1112,'Delta blues','Music:Blues','Earliest style of blue music',
to_date('29-SEP-2008 1500','DD-MON-YYYY HH24MI'),
'p100',16.00,5.00,
to_date('5-OCT-2008 1600','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1113,'Jazz blues','Music:Blues','Combines jazz and blues',
to_date('8-OCT-2008 0900','DD-MON-YYYY HH24MI'),
'q100',20.00,1.00,
to_date('16-OCT-2008 1500','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1114,'Jump blues','Music:Blues','Influenced by big band sound',
to_date('27-APR-2008 1000','DD-MON-YYYY HH24MI'),
's100',10.00,6.00,
to_date('01-MAY-2008 1200','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1115,'Piano blues','Music:Blues','Piano is used',
to_date('27-APR-2008 1000','DD-MON-YYYY HH24MI'),
'a100',10.00,6.00,
to_date('01-MAY-2008 1200','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1116,'Boogie-woogie','Music:Blues','Extended from piano',
to_date('21-DEC-2008 1900','DD-MON-YYYY HH24MI'),
'm100',10.00,6.00,
to_date('01-JAN-2009 2300','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1117,'British blues','Music:Blues','Originated in 1950s',
to_date('01-DEC-2008 2000','DD-MON-YYYY HH24MI'),
'p100',12.00,3.00,
to_date('25-DEC-2008 2200','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1118,'Canadian blues','Music:Blues','Performed in Canada',
to_date('02-NOV-2008 0800','DD-MON-YYYY HH24MI'),
'q100',20.00,1.00,
to_date('22-NOV-2008 1000','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1119,'Chicago blues','Music:Blues','Developed in Chicago',
to_date('12-MAY-2008 1130','DD-MON-YYYY HH24MI'),
's100',25.00,2.00,
to_date('12-JUN-2008 1000 ','DD-MON-YYYY HH24MI'),
null);
---Phase I Data
--Minh
insert into item values
(1210,'Professor Layton and the Curious Village','Video Games:Games:Nintendo DS','Brand New ' ||
'Best Seller; Top Ten DS Games',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'a100',25.00,2.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1211,'The Legend of Zelda: Phantom Hourglass','Video Games:Games:Nintendo DS','Excellent Condition ' ||
'Best Seller; Top Ten DS Games',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'a100',20.00,2.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1212,'Final Fantasy XII: Revenant Wings','Video Games:Games:Nintendo DS','Brand New ' ||
'Best Seller; Top Ten DS Games',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'm100',25.00,2.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1213,'Bleach: The Blade of Fate','Video Games:Games:Nintendo DS','Excellent Condition ' ||
'Best Seller; Top Ten DS Games',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'm100',20.00,2.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1214,'Advance Wars: Days of Ruin','Video Games:Games:Nintendo DS','Brand New ' ||
'Best Seller; Top Ten DS Games',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'p100',25.00,2.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1215,'Contra 4','Video Games:Games:Nintendo DS','Excellent Condition ' ||
'Best Seller; Top Ten DS Games',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'p100',25.00,2.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1216,'Mario Party DS','Video Games:Games:Nintendo DS','Brand New ' ||
'Best Seller; Top Ten DS Games',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'q100',25.00,2.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1217,'Tony Hawk Proving Ground','Video Games:Games:Nintendo DS','Excellent Condition ' ||
'Best Seller; Top Ten DS Games',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'q100',20.00,2.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1218,'Chibi-Robo: Park Patrol','Video Games:Games:Nintendo DS','Brand New ' ||
'Best Seller; Top Ten DS Games',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
's100',25.00,2.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1219,'Sonic Rush Adventure','Video Games:Games:Nintendo DS','Excellent Condition ' ||
'Best Seller; Top Ten DS Games',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
's100',20.00,2.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
--Vivik
insert into item values
(1050,'ABS Ultimate M5-64','Computers:PCs:Desktops','Top Power System ' ||
'2.2-GHz Athlon 64 3400+ CPU, two 80GB hard drives configured as RAID 0, 19-inch CRT monitor, 256MB ATI Radeon 9800 XT graphics card, 4X DVD+/-RW and 16X DVD-ROM drives.',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'a100',1500.00,25.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1051,'Compaq Presario 8000Z','Computers:PCs:Desktops','Top Power System ' ||
'2.2-GHz Athlon 64 3400+ CPU, two 80GB hard drives configured as RAID 0, 17-inch LCD monitor, 256MB ATI Radeon 9600 Pro graphics card, 8X DVD+RW and 48X CD-RW drives.',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'a100',1500.00,25.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1052,'Sys Technology Performance 3400+/64','Computers:PCs:Desktops','Top Power System ' ||
'2.2-GHz Athlon 64 3400+ CPU, two 120GB hard drives configured as RAID 0, 17-inch LCD monitor, 128MB PNY Verto GeForce FX 5700 Ultra graphics card, 8X DVD+/-RW drive.',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'm100',1500.00,25.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1053,'MPC Millennia 920i Creative Studio','Computers:PCs:Desktops','Top Power System ' ||
'3.2-GHz Pentium 4 CPU, two 160GB hard drives configured as RAID 0, 19-inch LCD monitor, 256MB NVidia GeForce FX 5950 graphics card, 8X DVD+/-RW and 52X CD-RW drives.',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'm100',1500.00,25.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1054,'Polywell Poly 900NF3-FX53','Computers:PCs:Desktops','Top Power System ' ||
'2.4-GHz Athlon 64 FX-53 CPU, two 74.3GB hard drives configured as RAID 0, 19-inch CRT monitor, 256MB NVidia GeForce FX 5950 Ultra graphics card, 8X DVD+/-RW drive and 52X CD-RW/16X DVD-ROM combo drive.',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'p100',1500.00,25.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1055,'Dell Dimension 4600','Computers:PCs:Desktops','Top Value System ' ||
'2.8-GHz Pentium 4 CPU, 120GB hard drive, 17-inch LCD monitor, 128MB NVidia GeForce FX 5200 graphics card, 16X DVD-ROM and 48X CD-RW drives.',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'p100',750.00,25.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1056,'EMachines T3085','Computers:PCs:Desktops','Top Value System ' ||
'2.167-GHz Athlon XP 3000+ CPU, 160GB hard drive, 17-inch LCD monitor, integrated NVidia GeForce4 MX graphics, 8X DVD+/-RW and 52X CD-ROM drives.',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'q100',750.00,25.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1057,'Dell Dimension 2400','Computers:PCs:Desktops','Top Value System ' ||
'2.67-GHz Pentium 4 CPU, 80GB hard drive, 19-inch CRT monitor, integrated Intel 845GL graphics, 16X DVD-ROM and 48X CD-RW drives.',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'q100',750.00,25.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1058,'Gateway 510XL','Computers:PCs:Desktops','Top Value System ' ||
'3-GHz Pentium 4 CPU, 160GB hard drive, 15-inch LCD monitor, 128MB NVidia GeForce FX 5200G graphics card, 8X DVD+/-RW and 16X DVD-ROM drives.',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
's100',750.00,25.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1059,'Sony VAIO PCV-RS530G','Computers:PCs:Desktops','Top Value System ' ||
'3.2-GHz Pentium 4 CPU, 160GB hard drive, 15-inch LCD monitor, 128MB ATI Radeon 9200 graphics card, 8X DVD+/-RW and 16X DVD-ROM drives.',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
's100',750.00,25.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
--Cheng
insert into item values
(1040,'APPLE MACBOOK AIR 1.6 GHZ 13.3 INCH SCREEN','Computers:Apple:Laptops','Excellent Condition, HOTTEST LAPTOP INTEL CORE DUO 80GB HARD DRIVE.',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'a100',800.00,25.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1041,'Apple MacBook MB062LL/A Laptop 2 2.2GHz','Computers:Apple:Laptops','This item is working. This item is in the original box.This item appears to begin like new condition, the item may be slightly used, but appears to be in as new condition.',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'a100',500.00,20.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1042,'APPLE MACBOOK Laptop CORE 2 DUO 2.0GHz','Computers:Apple:Laptops','This unit has a bad battery, heavy wear on the top cover and a shine to the mousepad.',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'm100',700.00,35.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1043,'Apple iBook G4 1GHz','Computers:Apple:Laptops','This iBook model features a 1.42gHz G4 Processor, 512Mb of RAM (upgradable),60gb Hard Drive, 14 in. Screen and a SuperDrive.',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'm100',300.00,15.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1044,'Apple MacBook black 2.16GHz Intel Core 2 Duo','Computers:Apple:Laptops','Excellent Condition, 2.16GHz Intel Core 2 Duo/1GB/160GB',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'p100',800.00,25.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1045,'Apple MacBook Pro 15" 2.33GHz Core 2 Duo ','Computers:Apple:Laptops','2-in-1 Windows XP Pro + Leopard | Apps | Leather Case ',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'p100',850.00,20.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1046, 'Apple MacBook Pro 2.2GHz Intel Core 2 Duo 15"','Computers:Apple:Laptops','Excellent Near New Condition.',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'q100',900.00,10.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1047,'Mac iBook G3 Laptop','Computers:Apple:Laptops','The unit powers on and boots to the OS. The screen however is completely white except for a some colored lines near the center.',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'q100',400.00,5.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1048,'Apple MacBook Pro 2.4GHZ 17"','Computers:Apple:Laptops','APPLE CARE, MS OFFICE FOR MAC, LEOPARD 10. iWORK, LoJACK',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
's100',1000.00,85.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1049,'Apple PowerBook G4 15 in. 1.67Ghz','Computers:Apple:Laptops','This has 1.0 GB ram, 80 GB hardrive, DVDRW drive, WiFi, Bluetooth. It is in great condition and the battery holds a great charge.',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
's100',500.00,35.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null); insert into item values (1200,'Metal Gear','Video Games:Games:Playstation','New ' || 'Classic; Good Trama',to_date('19-APR-2008 1200','DD-MON-YYYY HH24MI'),'m100',15.00,1.50,to_date('30-APR-2008 1200','DD-MON-YYYY HH24MI'),null);
--
insert into item values (1201,'Gran Turismo','Video Games:Games:Playstation','Good Condition ' || 'Best Seller; Awesome Graphics',to_date('20-APR-2008 1200','DD-MON-YYYY HH24MI'),'p100',25.00,3.50,to_date('1-MAY-2008 1300','DD-MON-YYYY HH24MI'),null);
--
insert into item values (1202,'Tomb Raider','Video Games:Games:Playstation','Used ' || 'Classic; Adventures',to_date('21-APR-2008 1400','DD-MON-YYYY HH24MI'),'q100',20.00,4.00,to_date('2-MAY-2008 1500','DD-MON-YYYY HH24MI'),null);
--
insert into item values (1203,'Gran Turismo 2','Video Games:Games:Playstation','New ' || 'Fighting',to_date('22-APR-2008 1200','DD-MON-YYYY HH24MI'),'s100',10.00,2.00,to_date('3-MAY-2008 1600','DD-MON-YYYY HH24MI'),null);
--
insert into item values (1204,'Need for Speed','Video Games:Games:Playstation','Good Condition ' || 'Good Sells; Car Racing and Persuits',to_date('24-APR-2008 1400','DD-MON-YYYY HH24MI'),'a100',10.00,5.00,to_date('4-MAY-2008 1800','DD-MON-YYYY HH24MI'),null);
--
insert into item values (1205,'Crash Bandicoot 2','Video Games:Games:Playstation','New ' || 'Best Seller; Fun and Good Graphics',to_date('25-APR-2008 1800','DD-MON-YYYY HH24MI'),'p100',15.00,2.00,to_date('5-MAY-2008 1900','DD-MON-YYYY HH24MI'),null);
--
insert into item values (1206,'Resident Evil','Video Games:Games:Playstation','Used ' || 'Classic; Terror',to_date('24-APR-2008 1300','DD-MON-YYYY HH24MI'),'q100',24.00,2.00,to_date('4-MAY-2008 1800','DD-MON-YYYY HH24MI'),null);
--
insert into item values (1207,'Silent Hill','Video Games:Games:Playstation','Good Condition ' || 'Good Sells; Terror and Puzzles',to_date('23-APR-2008 1800','DD-MON-YYYY HH24MI'),'s100',30.00,10.00,to_date('3-MAY-2008 1100','DD-MON-YYYY HH24MI'),null);
--
insert into item values (1208,'Nascar','Video Games:Games:Playstation','New ' || 'Best Seller; Car Racing',to_date('24-APR-2008 1400','DD-MON-YYYY HH24MI'),'a100',12.00,5.00,to_date('4-MAY-2008 1800','DD-MON-YYYY HH24MI'),null);
--
insert into item values (1209,'Plastic Men','Video Games:Games:Playstation','Used ' || 'Good Sells; War',to_date('23-APR-2008 1500','DD-MON-YYYY HH24MI'),'p100',30.00,2.00,to_date('2-MAY-2008 1600','DD-MON-YYYY HH24MI'),null);
--
insert into item values
(1220,'iMac 20-inch','Computers:Apple:Desktops','Good Condition ' ||
'Best Seller; Super Graphics',
to_date('21-APR-2008 1700','DD-MON-YYYY HH24MI'),
'a100',600.00,20.00,
to_date('28-APR-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1221,'iMac 20-inch','Computers:Apple:Desktops','Excellent Condition ' ||
'Best Seller',
to_date('21-MAY-2008 1400','DD-MON-YYYY HH24MI'),
'q100',650.00,10.00,
to_date('28-MAY-2008 1400','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1222,'iMac 24-inch','Computers:Apple:Desktops','Fair Condition ' ||
'Super Graphics',
to_date('01-APR-2008 2300','DD-MON-YYYY HH24MI'),
'm100',720.00,50.00,
to_date('08-APR-2008 2300','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1223,'iMac','Computers:Apple:Desktops','Excellent Condition ' ||
'Best Seller; Super Graphics',
to_date('21-JUN-2008 1700','DD-MON-YYYY HH24MI'),
's100',202.00,100.00,
to_date('28-JUN-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1224,'iMac 24-inch','Computers:Apple:Desktops','Good Condition ' ||
'Best Seller',
to_date('10-APR-2008 1500','DD-MON-YYYY HH24MI'),
'a100',1000.00,2.00,
to_date('17-APR-2008 1500','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1225,'MacPro','Computers:Apple:Desktops','Excellent Condition ' ||
'Best Seller; Super Graphics',
to_date('21-APR-2008 2000','DD-MON-YYYY HH24MI'),
'p100',1300.00,50.00,
to_date('28-APR-2008 2000','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1226,'MacPro','Computers:Apple:Desktops','Good Condition ' ||
'Super Graphics',
to_date('21-AUG-2008 2356','DD-MON-YYYY HH24MI'),
's100',1020.00,12.00,
to_date('28-AUG-2008 2356','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1227,'iMac 20-inch','Computers:Apple:Desktops','Excellent Condition ' ||
'Best Seller; Super Graphics',
to_date('15-SEP-2008 1700','DD-MON-YYYY HH24MI'),
'q100',800.00,60.00,
to_date('22-SEP-2008 1700','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1228,'iMac 24-inch','Computers:Apple:Desktops','Excellent Condition ' ||
'Best Seller; Super Graphics',
to_date('21-SEP-2008 2100','DD-MON-YYYY HH24MI'),
'm100',1200.00,20.00,
to_date('28-SEP-2008 2100','DD-MON-YYYY HH24MI'),
null);
insert into item values
(1229,'iMac','Computers:Apple:Desktops','Excellent Condition ' ||
'Best Seller; Super Graphics',
to_date('21-APR-2008 1223','DD-MON-YYYY HH24MI'),
'p100',420.00,60.00,
to_date('28-APR-2008 1223','DD-MON-YYYY HH24MI'),
null);
Reference in New Issue View Git Blame Copy Permalink