result.sql

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

insert into city values(242,21,'济宁','0537');                                                      
insert into city values(338,30,'嘉兴','0573');                                                      
insert into city values(31,4,'嘉峪关','0937');                                                      
insert into city values(125,11,'佳木斯','0454');                                                    
insert into city values(52,5,'江门','0750');                                                        
insert into city values(103,10,'焦作','0391');                                                      
insert into city values(53,5,'揭阳','0663');                                                        
insert into city values(32,4,'金昌','0935');                                                        
insert into city values(339,30,'金华','0579');                                                      
insert into city values(206,17,'锦州','0416');                                                      
insert into city values(256,22,'晋城','0356');                                                      
insert into city values(257,22,'晋中','0354');                                                      
insert into city values(136,12,'荆门','0724');                                                      
insert into city values(137,12,'荆州','0716');                                                      
insert into city values(190,16,'景德镇','0798');                                                    
insert into city values(191,16,'九江','0792');                                                      
insert into city values(33,4,'酒泉','0937');                                                        
insert into city values(311,28,'喀什','0998');                                                      
insert into city values(104,10,'开封','0378');                                                      
insert into city values(312,28,'克拉玛依','0990');                                                  
insert into city values(313,28,'库尔勒','0996');                                                    
insert into city values(314,28,'奎屯','0992');                                                      
insert into city values(326,29,'昆明','0871');                                                      
insert into city values(300,27,'拉萨','0891');                                                      
insert into city values(243,21,'莱芜','0634');                                                      
insert into city values(34,4,'兰州','0931');                                                        
insert into city values(95,9,'廊坊','0316');                                                        
insert into city values(284,25,'乐山','0833');                                                      
insert into city values(327,29,'丽江','0888');                                                      
insert into city values(340,30,'丽水','0578');                                                      
insert into city values(175,15,'连云港','0518');                                                    
insert into city values(285,25,'凉山','0832');                                                      
insert into city values(244,21,'聊城','0635');                                                      
insert into city values(207,17,'辽阳','0419');                                                      
insert into city values(166,14,'辽源','0437');                                                      
insert into city values(301,27,'林芝','0894');                                                      
insert into city values(328,29,'临沧','0883');                                                      
insert into city values(258,22,'临汾','0357');                                                      
insert into city values(35,4,'临夏','0930');                                                        
insert into city values(245,21,'临沂','0539');                                                      
insert into city values(73,6,'柳州','0772');                                                        
insert into city values(11,1,'六安','0564');                                                        
insert into city values(81,7,'六盘水','0858');                                                      
insert into city values(20,3,'龙岩','0597');                                                        
insert into city values(36,4,'陇南','0939');                                                        
insert into city values(154,13,'娄底','0738');                                                      
insert into city values(259,22,'吕梁','0358');                                                      
insert into city values(105,10,'洛阳','0379');                                                      
insert into city values(234,20,'玛沁','0975');                                                      
insert into city values(12,1,'马鞍山','0555');                                                      
insert into city values(54,5,'茂名','0668');                                                        
insert into city values(167,14,'梅河口','0445');                                                    
insert into city values(55,5,'梅州','0753');                                                        
insert into city values(286,25,'眉山','0833');                                                      
insert into city values(287,25,'绵阳','0816');                                                      
insert into city values(126,11,'牡丹江','0453');                                                    
insert into city values(302,27,'那曲','0896');                                                      
insert into city values(192,16,'南昌','0791');                                                      
insert into city values(288,25,'南充','0817');                                                      
insert into city values(176,15,'南京','025');                                                       
insert into city values(74,6,'南宁','0771');                                                        
insert into city values(21,3,'南平','0599');                                                        
insert into city values(177,15,'南通','0513');                                                      
insert into city values(106,10,'南阳','0377');                                                      
insert into city values(289,25,'内江','0832');                                                      
insert into city values(341,30,'宁波','0574');                                                      
insert into city values(22,3,'宁德','0593');                                                        
insert into city values(329,29,'怒江','0886');                                                      
insert into city values(290,25,'攀枝花','0812');                                                    
insert into city values(208,17,'盘锦','0427');                                                      
insert into city values(193,16,'萍乡','0799');                                                      
insert into city values(107,10,'平顶山','0375');                                                    
insert into city values(37,4,'平凉','0933');                                                        
insert into city values(23,3,'莆田','0594');                                                        
insert into city values(127,11,'七台河','0453');                                                    
insert into city values(128,11,'齐齐哈尔','0452');                                                  
insert into city values(82,7,'黔东南州','0855');                                                    
insert into city values(348,31,'黔江','023');                                                       
insert into city values(83,7,'黔南州','0854');                                                      
insert into city values(84,7,'黔西南州','0859');                                                    
insert into city values(138,12,'潜江','0728');                                                      
insert into city values(75,6,'钦州','0777');                                                        
insert into city values(96,9,'秦皇岛','0335');                                                      
insert into city values(246,21,'青岛','0532');                                                      
insert into city values(56,5,'清远','0763');                                                        
insert into city values(38,4,'庆阳','0934');                                                        
insert into city values(330,29,'曲靖','0874');                                                      
insert into city values(24,3,'泉州','0595');                                                        
insert into city values(303,27,'日喀则','0892');                                                    
insert into city values(247,21,'日照','0633');                                                      
insert into city values(108,10,'三门峡','0398');                                                    
insert into city values(25,3,'三明','0598');                                                        
insert into city values(88,8,'三亚','0899');                                                        
insert into city values(304,27,'山南','0893');                                                      
insert into city values(57,5,'汕头','0754');                                                        
insert into city values(58,5,'汕尾','0660');                                                        
insert into city values(268,23,'商洛','0914');                                                      
insert into city values(109,10,'商丘','0370');                                                      
insert into city values(275,24,'上海','021');                                                       
insert into city values(194,16,'上饶','0793');                                                      
insert into city values(59,5,'韶关','0751');                                                        
insert into city values(155,13,'邵阳','0739');                                                      
insert into city values(342,30,'绍兴','0575');                                                      
insert into city values(60,5,'深圳','0755');                                                        
insert into city values(209,17,'沈阳','024');                                                       
insert into city values(139,12,'十堰','0719');                                                      
insert into city values(315,28,'石河子','0993');                                                    
insert into city values(97,9,'石家庄','0311');                                                      
insert into city values(225,19,'石嘴山','0952');                                                    
insert into city values(129,11,'双鸭山','0469');                                                    
insert into city values(61,5,'顺德','0765');                                                        
insert into city values(260,22,'朔州','0349');                                                      
insert into city values(331,29,'思茅','0879');                                                      
insert into city values(168,14,'四平','0434');                                                      
insert into city values(169,14,'松原','0438');                                                      
insert into city values(178,15,'苏州','0512');                                                      
insert into city values(179,15,'宿迁','0527');                                                      
insert into city values(13,1,'宿州','0557');                                                        
insert into city values(140,12,'随州','0722');                                                      
insert into city values(130,11,'绥化','0455');                                                      
insert into city values(291,25,'遂宁','0825');                                                      
insert into city values(316,28,'塔城','0901');                                                      
insert into city values(343,30,'台州','0576');                                                      
insert into city values(248,21,'泰安','0538');                                                      
insert into city values(180,15,'泰州','0523');