result.sql

本人在工程上收集的比较常用的oracle sql语句 有问题请发email:[e-mail]

insert into city values(463,32,'阿塞拜疆 Azerbaijan',994);                      
insert into city values(464,32,'格鲁吉亚 Georgia',995);                         
insert into city values(465,32,'国外',0);                                       
insert into city values(466,32,'墨西哥',52);                                    
insert into city values(467,32,'赤道几内亚',240);                               
insert into city values(468,32,'厄里特里亚',291);                               
insert into city values(469,32,'埃塞俄比亚',251);                               
insert into city values(470,32,'福克兰群岛',500);                               
insert into city values(471,32,'法罗群岛',298);                                 
insert into city values(472,32,'马提尼克',596);                                 
insert into city values(473,32,'密克罗尼西亚',691);                             
insert into city values(474,32,'喀麦隆',237);                                   
insert into city values(475,32,'法属圭亚那',594);                               
insert into city values(476,32,'格陵兰岛',299);                                 
insert into city values(477,32,'瓜多罗普',590);                                 
insert into city values(478,32,'危地马拉',502);                                 
insert into city values(479,32,'几内亚',224);                                   
insert into city values(480,32,'突尼斯',216);                                   
insert into city values(481,32,'肯尼亚',254);                                   
insert into city values(482,32,'阿联酋',971);                                   
insert into city values(483,32,'伊拉克',964);                                   
insert into city values(484,32,'委内瑞拉',58);                                  
insert into city values(485,32,'利比里亚',231);                                 
insert into city values(486,32,'马尔代夫',960);                                 
insert into city values(487,32,'马里亚那群岛',1670);                            
insert into city values(488,32,'马其顿',389);                                   
insert into city values(489,32,'科特迪瓦',225);                                 
insert into city values(490,32,'马拉维',265);                                   
insert into city values(491,32,'津巴布韦',263);                                 
insert into city values(492,32,'马绍尔群岛',692);                               
insert into city values(493,32,'马耳他',356);                                   
insert into city values(494,32,'毛里塔尼亚',222);                               
insert into city values(495,32,'马约特岛',269);                                 
insert into city values(496,32,'阿富汗',93);                                    
insert into city values(497,32,'阿尔巴尼亚',355);                               
insert into city values(498,32,'开曼群岛',1345);                                
insert into city values(499,32,'蒙特塞拉特岛',1664);                            
insert into city values(500,32,'阿尔及利亚',213);                               
insert into city values(501,32,'安道尔',376);                                   
insert into city values(502,32,'安哥拉',244);                                   
insert into city values(503,32,'荷属安的列斯群岛',599);                         
insert into city values(504,32,'安圭拉',1264);                                  
insert into city values(505,32,'尼加拉瓜',505);                                 
insert into city values(506,32,'安提瓜和巴布达',1268);                          
insert into city values(507,32,'尼日利亚',234);                                 
insert into city values(508,32,'阿根廷',54);                                    
insert into city values(509,32,'哥伦比亚',57);                                  
insert into city values(510,32,'诺福克岛',672);                                 
insert into city values(511,32,'亚美尼亚',374);                                 
insert into city values(512,32,'多米尼加联邦',1767);                            
insert into city values(513,32,'太平洋地区',872);                               
insert into city values(514,32,'阿鲁巴岛',297);                                 
insert into city values(515,32,'阿森松',247);                                   
insert into city values(516,32,'巴布亚新几内亚',675);                           
insert into city values(517,32,'科克群岛',682);                                 
insert into city values(518,32,'巴哈马',1242);                                  
insert into city values(519,32,'哥斯达黎加',506);                               
insert into city values(520,32,'波利尼西亚',689);                               
insert into city values(521,32,'巴巴多斯',1246);                                
insert into city values(522,32,'东萨摩亚',684);                                 
insert into city values(523,32,'新喀里多尼亚群岛',687);                         
insert into city values(524,32,'白俄罗斯',375);                                 
insert into city values(525,32,'圣马力诺',378);                                 
insert into city values(526,32,'伯利兹',501);                                   
insert into city values(527,32,'塞内加尔',221);                                 
insert into city values(528,32,'迪戈加西亚',246);                               
insert into city values(529,32,'塞拉利昂',232);                                 
insert into city values(530,32,'百慕大群岛',144);                               
insert into city values(531,32,'吉布提',253);                                   
insert into city values(532,32,'多米尼加共和国',1809);                          
insert into city values(533,32,'索马里',252);                                   
insert into city values(534,32,'玻利维亚',591);                                 
insert into city values(535,32,'厄瓜多尔',593);                                 
insert into city values(536,32,'圣卢西亚',1758);                                
insert into city values(537,32,'萨尔瓦多',503);                                 
insert into city values(538,32,'圣赫勒拿岛',290);                               
insert into city values(539,32,'博茨瓦纳',267);                                 
insert into city values(540,32,'圣文森特',1784);                                
insert into city values(541,32,'特克斯和凯科斯群岛',1649);                      
insert into city values(542,32,'苏里南',597);                                   
insert into city values(543,32,'乌干达',256);                                   
insert into city values(544,32,'叙利亚',963);                                   
insert into city values(545,32,'布基纳法索',226);                               
insert into city values(546,32,'乌拉圭',598);                                   
insert into city values(547,32,'布隆迪',257);                                   
insert into city values(548,32,'瓦努阿图',678);                                 
insert into city values(549,32,'托克鲁',690);                                   
insert into city values(550,32,'佛得角',238);                                   
insert into city values(551,32,'维尔京群岛（美）',1340);                        
insert into city values(552,32,'瓦里斯和富士那群岛',1681);                      
insert into city values(553,32,'图瓦卢',688);                                   
insert into city values(554,32,'冈比亚',220);                                   
insert into city values(555,32,'赞比亚',260);                                   
insert into city values(556,32,'格林纳达',1473);                                
insert into city values(557,32,'圣多美和普林西比',239);                         
insert into city values(558,32,'塞舌尔',248);                                   
insert into city values(559,32,'维尔京群岛（英）',1284);                        
insert into city values(560,32,'威克岛',1808);                                  
insert into city values(561,32,'斯洛伐克',421);                                 
insert into city values(562,32,'几内亚比绍',245);                               
insert into city values(563,32,'所罗门群岛',677);                               
insert into city values(564,32,'扎伊尔',243);                                   
insert into city values(565,32,'圭亚那',592);                                   
insert into city values(566,32,'桑给巴尔',259);                                 
insert into city values(567,32,'洪都拉斯',504);                                 
insert into city values(568,32,'尼日尔',227);                                   
insert into city values(569,32,'圣彼埃尔和密克隆岛',508);                       
insert into city values(570,32,'纽埃岛',683);                                   
insert into city values(571,32,'牙买加',1876);                                  
insert into city values(572,32,'斯威士兰',268);                                 
insert into city values(573,32,'巴基斯坦',92);                                  
insert into city values(574,32,'基里巴斯',686);                                 
insert into city values(575,32,'巴拿马',507);                                   
insert into city values(576,32,'坦桑尼亚',255);                                 
insert into city values(577,32,'巴拉圭',595);                                   
insert into city values(578,32,'莱索托',266);                                   
insert into city values(579,32,'波多黎各',1787);                                
insert into city values(580,32,'利比亚',218);                                   
insert into city values(581,32,'莫桑比克',258);                                 
insert into city values(582,32,'留尼旺',262);                                   
insert into city values(583,32,'纳米比亚',264);                                 
insert into city values(584,32,'卢旺达',250);                                   
insert into city values(585,32,'马达加斯加',261);                               
insert into city values(586,32,'尼泊尔',977);                                   
insert into city values(587,32,'西萨摩亚',685);                                 
insert into city values(588,32,'马里亚纳群岛',670);                             
insert into city values(589,32,'特立尼达和多巴哥',1868);                        
insert into city values(590,32,'百慕大群岛(英)',1441);                          
insert into city values(591,32,'摩纳哥',377);                                   
insert into city values(592,32,'土库曼斯坦',993);                               
insert into city values(593,32,'南斯拉夫',38);                                  
insert into city values(594,32,'帕劳（美）',680);                               
insert into city values(595,32,'关岛（美）',671);                               
insert into city values(596,32,'埃及',20);                                      
insert into city values(597,32,'巴林',973);                                     
insert into city values(598,32,'刚果',242);                                     
insert into city values(599,32,'韩国',82);                                      
insert into city values(600,32,'吉尔吉斯坦',996);                               
insert into city values(601,32,'蒙古',976);                                     
insert into city values(602,32,'秘鲁',51);                                      
insert into city values(603,32,'约旦',962);                                     
insert into city values(604,32,'智利',56);                                      
commit;                                                                         
quit;