result.sql

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

insert into city values(144,12,'咸宁',715);                                     
insert into city values(145,12,'襄樊',710);                                     
insert into city values(146,12,'孝感',712);                                     
insert into city values(147,12,'宜昌',717);                                     
insert into city values(148,13,'常德',736);                                     
insert into city values(149,13,'长沙',731);                                     
insert into city values(150,13,'郴州',735);                                     
insert into city values(151,13,'衡阳',734);                                     
insert into city values(152,13,'怀化',745);                                     
insert into city values(153,13,'吉首',743);                                     
insert into city values(154,13,'娄底',738);                                     
insert into city values(155,13,'邵阳',739);                                     
insert into city values(156,13,'湘潭',732);                                     
insert into city values(157,13,'益阳',737);                                     
insert into city values(158,13,'永州',746);                                     
insert into city values(159,13,'岳阳',730);                                     
insert into city values(160,13,'张家界',744);                                   
insert into city values(161,13,'株州',733);                                     
insert into city values(162,14,'白城',436);                                     
insert into city values(163,14,'白山',439);                                     
insert into city values(164,14,'长春',431);                                     
insert into city values(165,14,'吉林',432);                                     
insert into city values(166,14,'辽源',437);                                     
insert into city values(167,14,'梅河口',445);                                   
insert into city values(168,14,'四平',434);                                     
insert into city values(169,14,'松原',438);                                     
insert into city values(170,14,'通化',435);                                     
insert into city values(171,14,'延吉',433);                                     
insert into city values(172,14,'珲春',440);                                     
insert into city values(173,15,'常州',519);                                     
insert into city values(174,15,'淮安',517);                                     
insert into city values(175,15,'连云港',518);                                   
insert into city values(176,15,'南京',25);                                      
insert into city values(177,15,'南通',513);                                     
insert into city values(178,15,'苏州',512);                                     
insert into city values(179,15,'宿迁',527);                                     
insert into city values(180,15,'泰州',523);                                     
insert into city values(181,15,'无锡',510);                                     
insert into city values(182,15,'徐州',516);                                     
insert into city values(183,15,'盐城',515);                                     
insert into city values(184,15,'扬州',514);                                     
insert into city values(185,15,'张家港',512);                                   
insert into city values(186,15,'镇江',511);                                     
insert into city values(187,16,'抚州',794);                                     
insert into city values(188,16,'赣州',797);                                     
insert into city values(189,16,'吉安',796);                                     
insert into city values(190,16,'景德镇',798);                                   
insert into city values(191,16,'九江',792);                                     
insert into city values(192,16,'南昌',791);                                     
insert into city values(193,16,'萍乡',799);                                     
insert into city values(194,16,'上饶',793);                                     
insert into city values(195,16,'新余',790);                                     
insert into city values(196,16,'宜春',795);                                     
insert into city values(197,16,'鹰潭',701);                                     
insert into city values(198,17,'鞍山',412);                                     
insert into city values(199,17,'本溪',414);                                     
insert into city values(200,17,'朝阳',421);                                     
insert into city values(201,17,'大连',411);                                     
insert into city values(202,17,'丹东',415);                                     
insert into city values(203,17,'抚顺',413);                                     
insert into city values(204,17,'阜新',418);                                     
insert into city values(205,17,'葫芦岛',429);                                   
insert into city values(206,17,'锦州',416);                                     
insert into city values(207,17,'辽阳',419);                                     
insert into city values(208,17,'盘锦',427);                                     
insert into city values(209,17,'沈阳',24);                                      
insert into city values(210,17,'铁岭',410);                                     
insert into city values(211,17,'营口',417);                                     
insert into city values(212,18,'阿拉山左旗',483);                               
insert into city values(213,18,'巴彦卓尔盟',478);                               
insert into city values(214,18,'包头',472);                                     
insert into city values(215,18,'赤峰',476);                                     
insert into city values(216,18,'鄂尔多斯',471);                                 
insert into city values(217,18,'海拉尔',470);                                   
insert into city values(218,18,'呼和浩特',471);                                 
insert into city values(219,18,'通辽',475);                                     
insert into city values(220,18,'乌海',473);                                     
insert into city values(221,18,'乌兰查布盟',474);                               
insert into city values(222,18,'锡林浩特',479);                                 
insert into city values(223,18,'兴安盟',482);                                   
insert into city values(224,19,'固原',954);                                     
insert into city values(225,19,'石嘴山',952);                                   
insert into city values(226,19,'吴忠',953);                                     
insert into city values(227,19,'银川',951);                                     
insert into city values(228,20,'格尔木',979);                                   
insert into city values(229,20,'海北州',979);                                   
insert into city values(230,20,'海东州',972);                                   
insert into city values(231,20,'海南州',979);                                   
insert into city values(232,20,'海西州',979);                                   
insert into city values(233,20,'黄南藏族',973);                                 
insert into city values(234,20,'玛沁',975);                                     
insert into city values(235,20,'西宁',971);                                     
insert into city values(236,20,'玉树',976);                                     
insert into city values(237,21,'滨州',543);                                     
insert into city values(238,21,'德州',534);                                     
insert into city values(239,21,'东营',546);                                     
insert into city values(240,21,'菏泽',530);                                     
insert into city values(241,21,'济南',531);                                     
insert into city values(242,21,'济宁',537);                                     
insert into city values(243,21,'莱芜',634);                                     
insert into city values(244,21,'聊城',635);                                     
insert into city values(245,21,'临沂',539);                                     
insert into city values(246,21,'青岛',532);                                     
insert into city values(247,21,'日照',633);                                     
insert into city values(248,21,'泰安',538);                                     
insert into city values(249,21,'威海',631);                                     
insert into city values(250,21,'潍坊',536);                                     
insert into city values(251,21,'烟台',535);                                     
insert into city values(252,21,'枣庄',632);                                     
insert into city values(253,21,'淄博',533);                                     
insert into city values(254,22,'长治',355);                                     
insert into city values(255,22,'大同',352);                                     
insert into city values(256,22,'晋城',356);                                     
insert into city values(257,22,'晋中',354);                                     
insert into city values(258,22,'临汾',357);                                     
insert into city values(259,22,'吕梁',358);                                     
insert into city values(260,22,'朔州',349);                                     
insert into city values(261,22,'太原',351);                                     
insert into city values(262,22,'忻州',350);                                     
insert into city values(263,22,'阳泉',353);                                     
insert into city values(264,22,'运城',359);                                     
insert into city values(265,23,'安康',915);                                     
insert into city values(266,23,'宝鸡',917);                                     
insert into city values(267,23,'汉中',916);                                     
insert into city values(268,23,'商洛',914);                                     
insert into city values(269,23,'铜川',919);                                     
insert into city values(270,23,'渭南',913);                                     
insert into city values(271,23,'西安',29);                                      
insert into city values(272,23,'咸阳',910);                                     
insert into city values(273,23,'延安',911);                                     
insert into city values(274,23,'榆林',912);                                     
insert into city values(275,24,'上海',21);                                      
insert into city values(276,25,'阿坝',837);                                     
insert into city values(277,25,'巴中',827);                                     
insert into city values(278,25,'成都',28);                                      
insert into city values(279,25,'达州',818);                                     
insert into city values(280,25,'德阳',838);                                     
insert into city values(281,25,'甘孜',836);                                     
insert into city values(282,25,'广安',826);                                     
insert into city values(283,25,'广元',839);                                     
insert into city values(284,25,'乐山',833);                                     
insert into city values(285,25,'凉山',832);                                     
insert into city values(286,25,'眉山',833);                                     
insert into city values(287,25,'绵阳',816);                                     
insert into city values(288,25,'南充',817);                                     
insert into city values(289,25,'内江',832);                                     
insert into city values(290,25,'攀枝花',812);