result.sql

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

insert into tcity values(314,28,'奎屯','0992');                                                     
insert into tcity values(326,29,'昆明','0871');                                                     
insert into tcity values(300,27,'拉萨','0891');                                                     
insert into tcity values(243,21,'莱芜','0634');                                                     
insert into tcity values(34,4,'兰州','0931');                                                       
insert into tcity values(95,9,'廊坊','0316');                                                       
insert into tcity values(284,25,'乐山','0833');                                                     
insert into tcity values(327,29,'丽江','0888');                                                     
insert into tcity values(340,30,'丽水','0578');                                                     
insert into tcity values(175,15,'连云港','0518');                                                   
insert into tcity values(285,25,'凉山','0832');                                                     
insert into tcity values(244,21,'聊城','0635');                                                     
insert into tcity values(207,17,'辽阳','0419');                                                     
insert into tcity values(166,14,'辽源','0437');                                                     
insert into tcity values(301,27,'林芝','0894');                                                     
insert into tcity values(328,29,'临沧','0883');                                                     
insert into tcity values(258,22,'临汾','0357');                                                     
insert into tcity values(35,4,'临夏','0930');                                                       
insert into tcity values(245,21,'临沂','0539');                                                     
insert into tcity values(73,6,'柳州','0772');                                                       
insert into tcity values(11,1,'六安','0564');                                                       
insert into tcity values(81,7,'六盘水','0858');                                                     
insert into tcity values(20,3,'龙岩','0597');                                                       
insert into tcity values(36,4,'陇南','0939');                                                       
insert into tcity values(154,13,'娄底','0738');                                                     
insert into tcity values(259,22,'吕梁','0358');                                                     
insert into tcity values(105,10,'洛阳','0379');                                                     
insert into tcity values(234,20,'玛沁','0975');                                                     
insert into tcity values(12,1,'马鞍山','0555');                                                     
insert into tcity values(54,5,'茂名','0668');                                                       
insert into tcity values(167,14,'梅河口','0445');                                                   
insert into tcity values(55,5,'梅州','0753');                                                       
insert into tcity values(286,25,'眉山','0833');                                                     
insert into tcity values(287,25,'绵阳','0816');                                                     
insert into tcity values(126,11,'牡丹江','0453');                                                   
insert into tcity values(302,27,'那曲','0896');                                                     
insert into tcity values(192,16,'南昌','0791');                                                     
insert into tcity values(288,25,'南充','0817');                                                     
insert into tcity values(176,15,'南京','025');                                                      
insert into tcity values(74,6,'南宁','0771');                                                       
insert into tcity values(21,3,'南平','0599');                                                       
insert into tcity values(177,15,'南通','0513');                                                     
insert into tcity values(106,10,'南阳','0377');                                                     
insert into tcity values(289,25,'内江','0832');                                                     
insert into tcity values(341,30,'宁波','0574');                                                     
insert into tcity values(22,3,'宁德','0593');                                                       
insert into tcity values(329,29,'怒江','0886');                                                     
insert into tcity values(290,25,'攀枝花','0812');                                                   
insert into tcity values(208,17,'盘锦','0427');                                                     
insert into tcity values(193,16,'萍乡','0799');                                                     
insert into tcity values(107,10,'平顶山','0375');                                                   
insert into tcity values(37,4,'平凉','0933');                                                       
insert into tcity values(23,3,'莆田','0594');                                                       
insert into tcity values(127,11,'七台河','0453');                                                   
insert into tcity values(128,11,'齐齐哈尔','0452');                                                 
insert into tcity values(82,7,'黔东南州','0855');                                                   
insert into tcity values(348,31,'黔江','023');                                                      
insert into tcity values(83,7,'黔南州','0854');                                                     
insert into tcity values(84,7,'黔西南州','0859');                                                   
insert into tcity values(138,12,'潜江','0728');                                                     
insert into tcity values(75,6,'钦州','0777');                                                       
insert into tcity values(96,9,'秦皇岛','0335');                                                     
insert into tcity values(246,21,'青岛','0532');                                                     
insert into tcity values(56,5,'清远','0763');                                                       
insert into tcity values(38,4,'庆阳','0934');                                                       
insert into tcity values(330,29,'曲靖','0874');                                                     
insert into tcity values(24,3,'泉州','0595');                                                       
insert into tcity values(303,27,'日喀则','0892');                                                   
insert into tcity values(247,21,'日照','0633');                                                     
insert into tcity values(108,10,'三门峡','0398');                                                   
insert into tcity values(25,3,'三明','0598');                                                       
insert into tcity values(88,8,'三亚','0899');                                                       
insert into tcity values(304,27,'山南','0893');                                                     
insert into tcity values(57,5,'汕头','0754');                                                       
insert into tcity values(58,5,'汕尾','0660');                                                       
insert into tcity values(268,23,'商洛','0914');                                                     
insert into tcity values(109,10,'商丘','0370');                                                     
insert into tcity values(275,24,'上海','021');                                                      
insert into tcity values(194,16,'上饶','0793');                                                     
insert into tcity values(59,5,'韶关','0751');                                                       
insert into tcity values(155,13,'邵阳','0739');                                                     
insert into tcity values(342,30,'绍兴','0575');                                                     
insert into tcity values(60,5,'深圳','0755');                                                       
insert into tcity values(209,17,'沈阳','024');                                                      
insert into tcity values(139,12,'十堰','0719');                                                     
insert into tcity values(315,28,'石河子','0993');                                                   
insert into tcity values(97,9,'石家庄','0311');                                                     
insert into tcity values(225,19,'石嘴山','0952');                                                   
insert into tcity values(129,11,'双鸭山','0469');                                                   
insert into tcity values(61,5,'顺德','0765');                                                       
insert into tcity values(260,22,'朔州','0349');                                                     
insert into tcity values(331,29,'思茅','0879');                                                     
insert into tcity values(168,14,'四平','0434');                                                     
insert into tcity values(169,14,'松原','0438');                                                     
insert into tcity values(178,15,'苏州','0512');                                                     
insert into tcity values(179,15,'宿迁','0527');                                                     
insert into tcity values(13,1,'宿州','0557');                                                       
insert into tcity values(140,12,'随州','0722');                                                     
insert into tcity values(130,11,'绥化','0455');                                                     
insert into tcity values(291,25,'遂宁','0825');                                                     
insert into tcity values(316,28,'塔城','0901');                                                     
insert into tcity values(343,30,'台州','0576');                                                     
insert into tcity values(248,21,'泰安','0538');                                                     
insert into tcity values(180,15,'泰州','0523');                                                     
insert into tcity values(261,22,'太原','0351');                                                     
insert into tcity values(98,9,'唐山','0315');                                                       
insert into tcity values(297,26,'天津','022');                                                      
insert into tcity values(141,12,'天门','0728');                                                     
insert into tcity values(39,4,'天水','0938');                                                       
insert into tcity values(210,17,'铁岭','0410');                                                     
insert into tcity values(170,14,'通化','0435');                                                     
insert into tcity values(219,18,'通辽','0475');                                                     
insert into tcity values(269,23,'铜川','0919');                                                     
insert into tcity values(14,1,'铜陵','0562');                                                       
insert into tcity values(85,7,'铜仁','0856');                                                       
insert into tcity values(317,28,'吐鲁番','0995');                                                   
insert into tcity values(349,31,'万州','023');                                                      
insert into tcity values(249,21,'威海','0631');                                                     
insert into tcity values(250,21,'潍坊','0536');                                                     
insert into tcity values(270,23,'渭南','0913');                                                     
insert into tcity values(344,30,'温州','0577');                                                     
insert into tcity values(332,29,'文山','0876');                                                     
insert into tcity values(220,18,'乌海','0473');                                                     
insert into tcity values(221,18,'乌兰察布','0474');                                                 
insert into tcity values(318,28,'乌鲁木齐','0991');                                                 
insert into tcity values(181,15,'无锡','0510');                                                     
insert into tcity values(15,1,'芜湖','0553');                                                       
insert into tcity values(76,6,'梧州','0774');                                                       
insert into tcity values(226,19,'吴忠','0953');                                                     
insert into tcity values(142,12,'武汉','027');                                                      
insert into tcity values(40,4,'武威','0935');                                                       
insert into tcity values(271,23,'西安','029');                                                      
insert into tcity values(235,20,'西宁','0971');                                                     
insert into tcity values(333,29,'西双版纳','0691');                                                 
insert into tcity values(222,18,'锡林浩特','0479');                                                 
insert into tcity values(26,3,'厦门','0592');                                                       
insert into tcity values(143,12,'仙桃','0728');                                                     
insert into tcity values(144,12,'咸宁','0715');                                                     
insert into tcity values(272,23,'咸阳','0910');                                                     
insert into tcity values(145,12,'襄樊','0710');                                                     
insert into tcity values(156,13,'湘潭','0732');                                                     
insert into tcity values(146,12,'孝感','0712');                                                     
insert into tcity values(110,10,'新乡','0373');                                                     
insert into tcity values(195,16,'新余','0790');                                                     
insert into tcity values(262,22,'忻州','0350');                                                     
insert into tcity values(111,10,'信阳','0376');