result.sql

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

insert into city values(291,25,'遂宁',825);                                     
insert into city values(292,25,'雅安',835);                                     
insert into city values(293,25,'宜宾',831);                                     
insert into city values(294,25,'资阳',832);                                     
insert into city values(295,25,'自贡',813);                                     
insert into city values(296,25,'泸州',830);                                     
insert into city values(297,26,'天津',22);                                      
insert into city values(298,27,'阿里',897);                                     
insert into city values(299,27,'昌都',895);                                     
insert into city values(300,27,'拉萨',891);                                     
insert into city values(301,27,'林芝',894);                                     
insert into city values(302,27,'那曲',896);                                     
insert into city values(303,27,'日喀则',892);                                   
insert into city values(304,27,'山南',893);                                     
insert into city values(305,28,'阿克苏',997);                                   
insert into city values(306,28,'阿勒泰',906);                                   
insert into city values(307,28,'博州',909);                                     
insert into city values(308,28,'昌吉',994);                                     
insert into city values(309,28,'哈密',902);                                     
insert into city values(310,28,'和田',903);                                     
insert into city values(311,28,'喀什',998);                                     
insert into city values(312,28,'克拉玛依',990);                                 
insert into city values(313,28,'库尔勒',996);                                   
insert into city values(314,28,'奎屯',992);                                     
insert into city values(315,28,'石河子',993);                                   
insert into city values(316,28,'塔城',901);                                     
insert into city values(317,28,'吐鲁番',995);                                   
insert into city values(318,28,'乌鲁木齐',991);                                 
insert into city values(319,28,'伊犁',999);                                     
insert into city values(320,29,'保山',875);                                     
insert into city values(321,29,'楚雄',878);                                     
insert into city values(322,29,'大理',872);                                     
insert into city values(323,29,'德宏',692);                                     
insert into city values(324,29,'迪庆',887);                                     
insert into city values(325,29,'红河',873);                                     
insert into city values(326,29,'昆明',871);                                     
insert into city values(327,29,'丽江',888);                                     
insert into city values(328,29,'临沧',883);                                     
insert into city values(329,29,'怒江',886);                                     
insert into city values(330,29,'曲靖',874);                                     
insert into city values(331,29,'思茅',879);                                     
insert into city values(332,29,'文山',876);                                     
insert into city values(333,29,'西双版纳',691);                                 
insert into city values(334,29,'玉溪',877);                                     
insert into city values(335,29,'昭通',870);                                     
insert into city values(336,30,'杭州',571);                                     
insert into city values(337,30,'湖州',572);                                     
insert into city values(338,30,'嘉兴',573);                                     
insert into city values(339,30,'金华',579);                                     
insert into city values(340,30,'丽水',578);                                     
insert into city values(341,30,'宁波',574);                                     
insert into city values(342,30,'绍兴',575);                                     
insert into city values(343,30,'台州',576);                                     
insert into city values(344,30,'温州',577);                                     
insert into city values(345,30,'舟山',580);                                     
insert into city values(346,30,'衢州',570);                                     
insert into city values(347,31,'涪陵',23);                                      
insert into city values(348,31,'黔江',23);                                      
insert into city values(349,31,'万州',23);                                      
insert into city values(350,31,'重庆',23);                                      
insert into city values(351,18,'巴彦浩特',483);                                 
insert into city values(352,18,'乌兰浩特',482);                                 
insert into city values(353,18,'集宁',474);                                     
insert into city values(354,18,'临河',478);                                     
insert into city values(355,12,'江汉',728);                                     
insert into city values(356,13,'株洲',733);                                     
insert into city values(357,31,'万县',23);                                      
insert into city values(358,29,'版纳',691);                                     
insert into city values(359,7,'都匀',854);                                      
insert into city values(360,7,'凯里',855);                                      
insert into city values(361,7,'兴义',859);                                      
insert into city values(362,4,'金昌武威',935);                                  
insert into city values(363,4,'酒泉嘉峪关',937);                                
insert into city values(364,20,'海东',972);                                     
insert into city values(365,28,'克州',908);                                     
insert into city values(366,28,'博乐',909);                                     
insert into city values(367,23,'陕西',918);                                     
insert into city values(368,18,'东胜',477);                                     
insert into city values(369,25,'布拖',834);                                     
insert into city values(371,20,'黄南',973);                                     
insert into city values(372,20,'共和',974);                                     
insert into city values(373,20,'果洛',975);                                     
insert into city values(374,20,'德令哈',977);                                   
insert into city values(375,20,'海晏',970);                                     
insert into city values(376,19,'中卫',955);                                     
insert into city values(401,32,'美国 U.S.A',1);                                 
insert into city values(402,32,'俄罗斯 Russia',7);                              
insert into city values(403,32,'加拿大 Microcell',15);                          
insert into city values(404,32,'南非 South Africa',27);                         
insert into city values(405,32,'希腊 Greece',30);                               
insert into city values(406,32,'荷兰 Holland',31);                              
insert into city values(407,32,'比利时 Belgium',32);                            
insert into city values(408,32,'法国 France',33);                               
insert into city values(409,32,'西班牙 Spain',34);                              
insert into city values(410,32,'匈牙利 Hungary',36);                            
insert into city values(411,32,'意大利 Italy',39);                              
insert into city values(412,32,'罗马尼亚 Romania',40);                          
insert into city values(413,32,'瑞士 Switzerland',41);                          
insert into city values(414,32,'奥地利 Austria',43);                            
insert into city values(415,32,'英国 U.K.',44);                                 
insert into city values(416,32,'丹麦 Denmark',45);                              
insert into city values(417,32,'瑞典 Sweden',46);                               
insert into city values(418,32,'挪威 Norway',47);                               
insert into city values(419,32,'波兰 Poland',48);                               
insert into city values(420,32,'德国 Germany',49);                              
insert into city values(421,32,'马来西亚 Malaysia',60);                         
insert into city values(422,32,'澳大利亚 Australia',61);                        
insert into city values(423,32,'印度尼西亚 Indonesia',62);                      
insert into city values(424,32,'菲律宾 Philippine',63);                         
insert into city values(425,32,'新西兰 New Zealand',64);                        
insert into city values(426,32,'新加坡 Singapore',65);                          
insert into city values(427,32,'泰国 Thailand',66);                             
insert into city values(428,32,'越南 Vietnam',84);                              
insert into city values(429,32,'中国 china',86);                                
insert into city values(430,32,'土耳其 Turkey',90);                             
insert into city values(431,32,'印度 India',91);                                
insert into city values(432,32,'斯里兰卡 Sri Lanka',94);                        
insert into city values(433,32,'摩洛哥 Morocco',212);                           
insert into city values(434,32,'毛里求斯 Mauritius',230);                       
insert into city values(435,32,'直布罗陀 Gibraltar',350);                       
insert into city values(436,32,'葡萄牙 Portugal',351);                          
insert into city values(437,32,'卢森堡 Luxembourg',352);                        
insert into city values(438,32,'爱尔兰 Ireland',353);                           
insert into city values(439,32,'冰岛 Iceland',354);                             
insert into city values(440,32,'塞浦路斯 Cyprus',357);                          
insert into city values(441,32,'芬兰 Finland',358);                             
insert into city values(442,32,'保加利亚 Bulgaria',359);                        
insert into city values(443,32,'立陶宛 Lithuania',370);                         
insert into city values(444,32,'拉托维亚 Latvia',371);                          
insert into city values(445,32,'爱沙尼亚 Estonia',372);                         
insert into city values(446,32,'摩尔多瓦 Moldova',373);                         
insert into city values(447,32,'乌克兰 Ukraine',380);                           
insert into city values(448,32,'南斯拉夫 Yugoslavia',381);                      
insert into city values(449,32,'克罗地亚 Croatia',385);                         
insert into city values(450,32,'斯洛文尼亚 Slovenia',386);                      
insert into city values(451,32,'捷克 Czech',420);                               
insert into city values(452,32,'澳门 Macao',853);                               
insert into city values(453,32,'文莱 Brunet',673);                              
insert into city values(454,32,'香港 Hong Kong',852);                           
insert into city values(455,32,'柬埔寨 Cambodia',855);                          
insert into city values(456,32,'孟加拉 Bangladesh',880);                        
insert into city values(457,32,'台湾 Taiwan',886);                              
insert into city values(458,32,'黎巴嫩 Lebanon',961);                           
insert into city values(459,32,'科威特 Kuwait',965);                            
insert into city values(460,32,'沙特 Saudi Arabia',966);                        
insert into city values(461,32,'以色列 Israel',972);                            
insert into city values(462,32,'卡塔尔 Qatar',974);