result.sql

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

insert into city values(261,22,'太原','0351');                                                      
insert into city values(98,9,'唐山','0315');                                                        
insert into city values(297,26,'天津','022');                                                       
insert into city values(141,12,'天门','0728');                                                      
insert into city values(39,4,'天水','0938');                                                        
insert into city values(210,17,'铁岭','0410');                                                      
insert into city values(170,14,'通化','0435');                                                      
insert into city values(219,18,'通辽','0475');                                                      
insert into city values(269,23,'铜川','0919');                                                      
insert into city values(14,1,'铜陵','0562');                                                        
insert into city values(85,7,'铜仁','0856');                                                        
insert into city values(317,28,'吐鲁番','0995');                                                    
insert into city values(349,31,'万州','023');                                                       
insert into city values(249,21,'威海','0631');                                                      
insert into city values(250,21,'潍坊','0536');                                                      
insert into city values(270,23,'渭南','0913');                                                      
insert into city values(344,30,'温州','0577');                                                      
insert into city values(332,29,'文山','0876');                                                      
insert into city values(220,18,'乌海','0473');                                                      
insert into city values(221,18,'乌兰察布','0474');                                                  
insert into city values(318,28,'乌鲁木齐','0991');                                                  
insert into city values(181,15,'无锡','0510');                                                      
insert into city values(15,1,'芜湖','0553');                                                        
insert into city values(76,6,'梧州','0774');                                                        
insert into city values(226,19,'吴忠','0953');                                                      
insert into city values(142,12,'武汉','027');                                                       
insert into city values(40,4,'武威','0935');                                                        
insert into city values(271,23,'西安','029');                                                       
insert into city values(235,20,'西宁','0971');                                                      
insert into city values(333,29,'西双版纳','0691');                                                  
insert into city values(222,18,'锡林浩特','0479');                                                  
insert into city values(26,3,'厦门','0592');                                                        
insert into city values(143,12,'仙桃','0728');                                                      
insert into city values(144,12,'咸宁','0715');                                                      
insert into city values(272,23,'咸阳','0910');                                                      
insert into city values(145,12,'襄樊','0710');                                                      
insert into city values(156,13,'湘潭','0732');                                                      
insert into city values(146,12,'孝感','0712');                                                      
insert into city values(110,10,'新乡','0373');                                                      
insert into city values(195,16,'新余','0790');                                                      
insert into city values(262,22,'忻州','0350');                                                      
insert into city values(111,10,'信阳','0376');                                                      
insert into city values(223,18,'兴安盟','0482');                                                    
insert into city values(99,9,'邢台','0319');                                                        
insert into city values(182,15,'徐州','0516');                                                      
insert into city values(112,10,'许昌','0374');                                                      
insert into city values(16,1,'宣城','0563');                                                        
insert into city values(292,25,'雅安','0835');                                                      
insert into city values(251,21,'烟台','0535');                                                      
insert into city values(183,15,'盐城','0515');                                                      
insert into city values(273,23,'延安','0911');                                                      
insert into city values(171,14,'延吉','0433');                                                      
insert into city values(184,15,'扬州','0514');                                                      
insert into city values(62,5,'阳江','0662');                                                        
insert into city values(263,22,'阳泉','0353');                                                      
insert into city values(131,11,'伊春','0458');                                                      
insert into city values(319,28,'伊犁','0999');                                                      
insert into city values(293,25,'宜宾','0831');                                                      
insert into city values(147,12,'宜昌','0717');                                                      
insert into city values(196,16,'宜春','0795');                                                      
insert into city values(157,13,'益阳','0737');                                                      
insert into city values(227,19,'银川','0951');                                                      
insert into city values(197,16,'鹰潭','0701');                                                      
insert into city values(211,17,'营口','0417');                                                      
insert into city values(158,13,'永州','0746');                                                      
insert into city values(274,23,'榆林','0912');                                                      
insert into city values(77,6,'玉林','0775');                                                        
insert into city values(236,20,'玉树','0976');                                                      
insert into city values(334,29,'玉溪','0877');                                                      
insert into city values(159,13,'岳阳','0730');                                                      
insert into city values(63,5,'云浮','0766');                                                        
insert into city values(264,22,'运城','0359');                                                      
insert into city values(252,21,'枣庄','0632');                                                      
insert into city values(64,5,'湛江','0759');                                                        
insert into city values(27,3,'漳州','0596');                                                        
insert into city values(185,15,'张家港','0512');                                                    
insert into city values(160,13,'张家界','0744');                                                    
insert into city values(100,9,'张家口','0313');                                                     
insert into city values(41,4,'张掖','0936');                                                        
insert into city values(335,29,'昭通','0870');                                                      
insert into city values(65,5,'肇庆','0758');                                                        
insert into city values(186,15,'镇江','0511');                                                      
insert into city values(113,10,'郑州','0371');                                                      
insert into city values(66,5,'中山','0760');                                                        
insert into city values(350,31,'重庆','023');                                                       
insert into city values(345,30,'舟山','0580');                                                      
insert into city values(114,10,'周口','0394');                                                      
insert into city values(67,5,'珠海','0756');                                                        
insert into city values(161,13,'株州','0733');                                                      
insert into city values(115,10,'驻马店','0396');                                                    
insert into city values(294,25,'资阳','0832');                                                      
insert into city values(253,21,'淄博','0533');                                                      
insert into city values(295,25,'自贡','0813');                                                      
insert into city values(86,7,'遵义','0852');                                                        
insert into city values(89,8,'儋州','0890');                                                        
insert into city values(17,1,'亳州','0558');                                                        
insert into city values(346,30,'衢州','0570');                                                      
insert into city values(296,25,'泸州','0830');                                                      
insert into city values(116,10,'潢川','0397');                                                      
insert into city values(117,10,'漯河','0395');                                                      
insert into city values(118,10,'濮阳','0393');                                                      
insert into city values(172,14,'珲春','0440');                                                      
insert into city values(0,0,'未知市','000');                                                        
insert into city values(355,12,'江汉','0728');                                                      
insert into city values(356,13,'株洲','0733');                                                      
insert into city values(357,31,'万县','023');                                                       
insert into city values(358,29,'版纳','0691');                                                      
insert into city values(359,7,'都匀','0854');                                                       
insert into city values(360,7,'凯里','0855');                                                       
insert into city values(361,7,'兴义','0859');                                                       
insert into city values(362,4,'金昌武威','0935');                                                   
insert into city values(363,4,'酒泉嘉峪关','0937');                                                 
insert into city values(364,20,'海东','0972');                                                      
insert into city values(365,28,'克州','0908');                                                      
insert into city values(366,28,'博乐','0909');                                                      
insert into city values(371,20,'黄南','0973');                                                      
insert into city values(372,20,'共和','0974');                                                      
insert into city values(373,20,'果洛','0975');                                                      
insert into city values(374,20,'德令哈','0977');                                                    
insert into city values(375,20,'海晏','0970');                                                      
insert into city values(367,23,'陕西','0918');                                                      
insert into city values(369,25,'布拖','0834');                                                      
commit;                                                                                             
quit;