result.sql

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

insert into tcity values(223,18,'兴安盟','0482');                                                   
insert into tcity values(99,9,'邢台','0319');                                                       
insert into tcity values(182,15,'徐州','0516');                                                     
insert into tcity values(112,10,'许昌','0374');                                                     
insert into tcity values(16,1,'宣城','0563');                                                       
insert into tcity values(292,25,'雅安','0835');                                                     
insert into tcity values(251,21,'烟台','0535');                                                     
insert into tcity values(183,15,'盐城','0515');                                                     
insert into tcity values(273,23,'延安','0911');                                                     
insert into tcity values(171,14,'延吉','0433');                                                     
insert into tcity values(184,15,'扬州','0514');                                                     
insert into tcity values(62,5,'阳江','0662');                                                       
insert into tcity values(263,22,'阳泉','0353');                                                     
insert into tcity values(131,11,'伊春','0458');                                                     
insert into tcity values(319,28,'伊犁','0999');                                                     
insert into tcity values(293,25,'宜宾','0831');                                                     
insert into tcity values(147,12,'宜昌','0717');                                                     
insert into tcity values(196,16,'宜春','0795');                                                     
insert into tcity values(157,13,'益阳','0737');                                                     
insert into tcity values(227,19,'银川','0951');                                                     
insert into tcity values(197,16,'鹰潭','0701');                                                     
insert into tcity values(211,17,'营口','0417');                                                     
insert into tcity values(158,13,'永州','0746');                                                     
insert into tcity values(274,23,'榆林','0912');                                                     
insert into tcity values(77,6,'玉林','0775');                                                       
insert into tcity values(236,20,'玉树','0976');                                                     
insert into tcity values(334,29,'玉溪','0877');                                                     
insert into tcity values(159,13,'岳阳','0730');                                                     
insert into tcity values(63,5,'云浮','0766');                                                       
insert into tcity values(264,22,'运城','0359');                                                     
insert into tcity values(252,21,'枣庄','0632');                                                     
insert into tcity values(64,5,'湛江','0759');                                                       
insert into tcity values(27,3,'漳州','0596');                                                       
insert into tcity values(185,15,'张家港','0512');                                                   
insert into tcity values(160,13,'张家界','0744');                                                   
insert into tcity values(100,9,'张家口','0313');                                                    
insert into tcity values(41,4,'张掖','0936');                                                       
insert into tcity values(335,29,'昭通','0870');                                                     
insert into tcity values(65,5,'肇庆','0758');                                                       
insert into tcity values(186,15,'镇江','0511');                                                     
insert into tcity values(113,10,'郑州','0371');                                                     
insert into tcity values(66,5,'中山','0760');                                                       
insert into tcity values(350,31,'重庆','023');                                                      
insert into tcity values(345,30,'舟山','0580');                                                     
insert into tcity values(114,10,'周口','0394');                                                     
insert into tcity values(67,5,'珠海','0756');                                                       
insert into tcity values(161,13,'株州','0733');                                                     
insert into tcity values(115,10,'驻马店','0396');                                                   
insert into tcity values(294,25,'资阳','0832');                                                     
insert into tcity values(253,21,'淄博','0533');                                                     
insert into tcity values(295,25,'自贡','0813');                                                     
insert into tcity values(86,7,'遵义','0852');                                                       
insert into tcity values(89,8,'儋州','0890');                                                       
insert into tcity values(17,1,'亳州','0558');                                                       
insert into tcity values(346,30,'衢州','0570');                                                     
insert into tcity values(296,25,'泸州','0830');                                                     
insert into tcity values(116,10,'潢川','0397');                                                     
insert into tcity values(117,10,'漯河','0395');                                                     
insert into tcity values(118,10,'濮阳','0393');                                                     
insert into tcity values(172,14,'珲春','0440');                                                     
insert into tcity values(0,0,'未知市','000');                                                       
insert into tcity values(351,32,'美国 U.S.A','1');                                                  
insert into tcity values(352,32,'俄罗斯 Russia','7');                                               
insert into tcity values(353,32,'加拿大 Microcell','15');                                           
insert into tcity values(354,32,'南非 South Africa','27');                                          
insert into tcity values(355,32,'希腊 Greece','30');                                                
insert into tcity values(356,32,'荷兰 Holland','31');                                               
insert into tcity values(357,32,'比利时 Belgium','32');                                             
insert into tcity values(358,32,'法国 France','33');                                                
insert into tcity values(359,32,'西班牙 Spain','34');                                               
insert into tcity values(360,32,'匈牙利 Hungary','36');                                             
insert into tcity values(361,32,'意大利 Italy','39');                                               
insert into tcity values(362,32,'罗马尼亚 Romania','40');                                           
insert into tcity values(363,32,'瑞士 Switzerland','41');                                           
insert into tcity values(364,32,'奥地利 Austria','43');                                             
insert into tcity values(365,32,'英国 U.K.','44');                                                  
insert into tcity values(366,32,'丹麦 Denmark','45');                                               
insert into tcity values(367,32,'瑞典 Sweden','46');                                                
insert into tcity values(368,32,'挪威 Norway','47');                                                
insert into tcity values(369,32,'波兰 Poland','48');                                                
insert into tcity values(370,32,'德国 Germany','49');                                               
insert into tcity values(371,32,'马来西亚 Malaysia','60');                                          
insert into tcity values(372,32,'澳大利亚 Australia','61');                                         
insert into tcity values(373,32,'印度尼西亚 Indonesia','62');                                       
insert into tcity values(374,32,'菲律宾 Philippine','63');                                          
insert into tcity values(375,32,'新西兰 New Zealand','64');                                         
insert into tcity values(376,32,'新加坡 Singapore','65');                                           
insert into tcity values(377,32,'泰国 Thailand','66');                                              
insert into tcity values(378,32,'越南 Vietnam','84');                                               
insert into tcity values(379,32,'中国 china','86');                                                 
insert into tcity values(380,32,'土耳其 Turkey','90');                                              
insert into tcity values(381,32,'印度 India','91');                                                 
insert into tcity values(382,32,'斯里兰卡 Sri Lanka','94');                                         
insert into tcity values(383,32,'摩洛哥 Morocco','212');                                            
insert into tcity values(384,32,'毛里求斯 Mauritius','230');                                        
insert into tcity values(385,32,'直布罗陀 Gibraltar','350');                                        
insert into tcity values(386,32,'葡萄牙 Portugal','351');                                           
insert into tcity values(387,32,'卢森堡 Luxembourg','352');                                         
insert into tcity values(388,32,'爱尔兰 Ireland','353');                                            
insert into tcity values(389,32,'冰岛 Iceland','354');                                              
insert into tcity values(390,32,'塞浦路斯 Cyprus','357');                                           
insert into tcity values(391,32,'芬兰 Finland','358');                                              
insert into tcity values(392,32,'保加利亚 Bulgaria','359');                                         
insert into tcity values(393,32,'立陶宛 Lithuania','370');                                          
insert into tcity values(394,32,'拉托维亚 Latvia','371');                                           
insert into tcity values(395,32,'爱沙尼亚 Estonia','372');                                          
insert into tcity values(396,32,'摩尔多瓦 Moldova','373');                                          
insert into tcity values(397,32,'乌克兰 Ukraine','380');                                            
insert into tcity values(398,32,'南斯拉夫 Yugoslavia','381');                                       
insert into tcity values(399,32,'克罗地亚 Croatia','385');                                          
insert into tcity values(400,32,'斯洛文尼亚 Slovenia','386');                                       
insert into tcity values(401,32,'捷克 Czech','420');                                                
insert into tcity values(402,32,'澳门 Macao','853');                                                
insert into tcity values(403,32,'文莱 Brunet','673');                                               
insert into tcity values(404,32,'香港 Hong Kong','852');                                            
insert into tcity values(405,32,'柬埔寨 Cambodia','855');                                           
insert into tcity values(406,32,'孟加拉 Bangladesh','880');                                         
insert into tcity values(407,32,'台湾 Taiwan','886');                                               
insert into tcity values(408,32,'黎巴嫩 Lebanon','961');                                            
insert into tcity values(409,32,'科威特 Kuwait','965');                                             
insert into tcity values(410,32,'沙特 Saudi Arabia','966');                                         
insert into tcity values(411,32,'以色列 Israel','972');                                             
insert into tcity values(412,32,'卡塔尔 Qatar','974');                                              
insert into tcity values(413,32,'阿塞拜疆 Azerbaijan','994');                                       
insert into tcity values(414,32,'格鲁吉亚 Georgia','995');                                          
insert into tcity values(504,12,'江汉','0728');                                                     
insert into tcity values(505,13,'株洲','0733');                                                     
insert into tcity values(506,31,'万县','023');                                                      
insert into tcity values(507,29,'版纳','0691');                                                     
insert into tcity values(508,7,'都匀','0854');                                                      
insert into tcity values(509,7,'凯里','0855');                                                      
insert into tcity values(510,7,'兴义','0859');                                                      
insert into tcity values(511,4,'金昌武威','0935');                                                  
insert into tcity values(512,4,'酒泉嘉峪关','0937');                                                
insert into tcity values(513,20,'海东','0972');                                                     
insert into tcity values(514,28,'克州','0908');                                                     
insert into tcity values(515,28,'博乐','0909');                                                     
insert into tcity values(500,20,'黄南','0973');                                                     
insert into tcity values(501,20,'共和','0974');                                                     
insert into tcity values(502,20,'果洛','0975');                                                     
insert into tcity values(503,20,'德令哈','0977');                                                   
insert into tcity values(504,20,'海晏','0970');                                                     
commit;                                                                                             
quit;