result.sql

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

SET ECHO      ON;                                                                                   
delete from city;                                                                                   
insert into city values(276,25,'阿坝','0837');                                                      
insert into city values(305,28,'阿克苏','0997');                                                    
insert into city values(212,18,'阿拉善左旗','0483');                                                
insert into city values(306,28,'阿勒泰','0906');                                                    
insert into city values(298,27,'阿里','0897');                                                      
insert into city values(198,17,'鞍山','0412');                                                      
insert into city values(265,23,'安康','0915');                                                      
insert into city values(1,1,'安庆','0556');                                                         
insert into city values(78,7,'安顺','0853');                                                        
insert into city values(101,10,'安阳','0372');                                                      
insert into city values(213,18,'巴彦淖尔','0478');                                                  
insert into city values(277,25,'巴中','0827');                                                      
insert into city values(162,14,'白城','0436');                                                      
insert into city values(163,14,'白山','0439');                                                      
insert into city values(28,4,'白银','0943');                                                        
insert into city values(68,6,'百色','0776');                                                        
insert into city values(2,1,'蚌埠','0552');                                                         
insert into city values(214,18,'包头','0472');                                                      
insert into city values(90,9,'保定','0312');                                                        
insert into city values(320,29,'保山','0875');                                                      
insert into city values(266,23,'宝鸡','0917');                                                      
insert into city values(69,6,'北海','0779');                                                        
insert into city values(18,2,'北京','010');                                                         
insert into city values(199,17,'本溪','0414');                                                      
insert into city values(79,7,'毕节','0857');                                                        
insert into city values(237,21,'滨州','0543');                                                      
insert into city values(307,28,'博州','0909');                                                      
insert into city values(91,9,'沧州','0317');                                                        
insert into city values(299,27,'昌都','0895');                                                      
insert into city values(308,28,'昌吉','0994');                                                      
insert into city values(148,13,'常德','0736');                                                      
insert into city values(173,15,'常州','0519');                                                      
insert into city values(164,14,'长春','0431');                                                      
insert into city values(149,13,'长沙','0731');                                                      
insert into city values(254,22,'长治','0355');                                                      
insert into city values(200,17,'朝阳','0421');                                                      
insert into city values(42,5,'潮阳','0661');                                                        
insert into city values(43,5,'潮州','0768');                                                        
insert into city values(3,1,'巢湖','0565');                                                         
insert into city values(150,13,'郴州','0735');                                                      
insert into city values(278,25,'成都','028');                                                       
insert into city values(92,9,'承德','0314');                                                        
insert into city values(4,1,'池州','0566');                                                         
insert into city values(215,18,'赤峰','0476');                                                      
insert into city values(5,1,'滁州','0550');                                                         
insert into city values(321,29,'楚雄','0878');                                                      
insert into city values(44,5,'从化','020');                                                         
insert into city values(279,25,'达州','0818');                                                      
insert into city values(322,29,'大理','0872');                                                      
insert into city values(201,17,'大连','0411');                                                      
insert into city values(119,11,'大庆','0459');                                                      
insert into city values(255,22,'大同','0352');                                                      
insert into city values(120,11,'大兴安岭','0457');                                                  
insert into city values(202,17,'丹东','0415');                                                      
insert into city values(323,29,'德宏','0692');                                                      
insert into city values(280,25,'德阳','0838');                                                      
insert into city values(238,21,'德州','0534');                                                      
insert into city values(324,29,'迪庆','0887');                                                      
insert into city values(29,4,'定西','0932');                                                        
insert into city values(239,21,'东营','0546');                                                      
insert into city values(45,5,'东莞','0769');                                                        
insert into city values(216,18,'鄂尔多斯','0471');                                                  
insert into city values(132,12,'鄂州','0711');                                                      
insert into city values(133,12,'恩施','0718');                                                      
insert into city values(46,5,'番禺','020');                                                         
insert into city values(70,6,'防城港','0770');                                                      
insert into city values(47,5,'佛山','0757');                                                        
insert into city values(347,31,'涪陵','023');                                                       
insert into city values(19,3,'福州','0591');                                                        
insert into city values(203,17,'抚顺','0413');                                                      
insert into city values(187,16,'抚州','0794');                                                      
insert into city values(204,17,'阜新','0418');                                                      
insert into city values(6,1,'阜阳','0558');                                                         
insert into city values(30,4,'甘南','0941');                                                        
insert into city values(281,25,'甘孜','0836');                                                      
insert into city values(188,16,'赣州','0797');                                                      
insert into city values(228,20,'格尔木','0979');                                                    
insert into city values(224,19,'固原','0954');                                                      
insert into city values(282,25,'广安','0826');                                                      
insert into city values(283,25,'广元','0839');                                                      
insert into city values(48,5,'广州','020');                                                         
insert into city values(71,6,'桂林','0773');                                                        
insert into city values(80,7,'贵阳','0851');                                                        
insert into city values(121,11,'哈尔滨','0451');                                                    
insert into city values(309,28,'哈密','0902');                                                      
insert into city values(229,20,'海北州','0979');                                                    
insert into city values(230,20,'海东州','0972');                                                    
insert into city values(87,8,'海口','0898');                                                        
insert into city values(217,18,'呼伦贝尔','0470');                                                  
insert into city values(231,20,'海南州','0979');                                                    
insert into city values(232,20,'海西州','0979');                                                    
insert into city values(93,9,'邯郸','0310');                                                        
insert into city values(267,23,'汉中','0916');                                                      
insert into city values(336,30,'杭州','0571');                                                      
insert into city values(240,21,'菏泽','0530');                                                      
insert into city values(310,28,'和田','0903');                                                      
insert into city values(7,1,'合肥','0551');                                                         
insert into city values(72,6,'河池','0778');                                                        
insert into city values(49,5,'河源','0762');                                                        
insert into city values(102,10,'鹤壁','0392');                                                      
insert into city values(122,11,'鹤岗','0468');                                                      
insert into city values(123,11,'黑河','0456');                                                      
insert into city values(94,9,'衡水','0318');                                                        
insert into city values(151,13,'衡阳','0734');                                                      
insert into city values(325,29,'红河','0873');                                                      
insert into city values(218,18,'呼和浩特','0471');                                                  
insert into city values(205,17,'葫芦岛','0429');                                                    
insert into city values(337,30,'湖州','0572');                                                      
insert into city values(50,5,'花都','020');                                                         
insert into city values(152,13,'怀化','0745');                                                      
insert into city values(174,15,'淮安','0517');                                                      
insert into city values(8,1,'淮北','0561');                                                         
insert into city values(9,1,'淮南','0554');                                                         
insert into city values(134,12,'黄冈','0713');                                                      
insert into city values(233,20,'黄南藏族','0973');                                                  
insert into city values(10,1,'黄山','0559');                                                        
insert into city values(135,12,'黄石','0714');                                                      
insert into city values(51,5,'惠州','0752');                                                        
insert into city values(124,11,'鸡西','0453');                                                      
insert into city values(189,16,'吉安','0796');                                                      
insert into city values(165,14,'吉林','0432');                                                      
insert into city values(153,13,'吉首','0743');                                                      
insert into city values(241,21,'济南','0531');