result.sql

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

SET ECHO      OFF;                                                              
delete from city;                                                               
commit;                                                                         
insert into city values(0,0,'未知市',0);                                        
insert into city values(1,1,'安庆',556);                                        
insert into city values(2,1,'蚌埠',552);                                        
insert into city values(3,1,'巢湖',565);                                        
insert into city values(4,1,'池州',566);                                        
insert into city values(5,1,'滁州',550);                                        
insert into city values(6,1,'阜阳',558);                                        
insert into city values(7,1,'合肥',551);                                        
insert into city values(8,1,'淮北',561);                                        
insert into city values(9,1,'淮南',554);                                        
insert into city values(10,1,'黄山',559);                                       
insert into city values(11,1,'六安',564);                                       
insert into city values(12,1,'马鞍山',555);                                     
insert into city values(13,1,'宿州',557);                                       
insert into city values(14,1,'铜陵',562);                                       
insert into city values(15,1,'芜湖',553);                                       
insert into city values(16,1,'宣城',563);                                       
insert into city values(17,1,'亳州',558);                                       
insert into city values(18,2,'北京',10);                                        
insert into city values(19,3,'福州',591);                                       
insert into city values(20,3,'龙岩',597);                                       
insert into city values(21,3,'南平',599);                                       
insert into city values(22,3,'宁德',593);                                       
insert into city values(23,3,'莆田',594);                                       
insert into city values(24,3,'泉州',595);                                       
insert into city values(25,3,'三明',598);                                       
insert into city values(26,3,'厦门',592);                                       
insert into city values(27,3,'漳州',596);                                       
insert into city values(28,4,'白银',943);                                       
insert into city values(29,4,'定西',932);                                       
insert into city values(30,4,'甘南',941);                                       
insert into city values(31,4,'嘉峪关',937);                                     
insert into city values(32,4,'金昌',935);                                       
insert into city values(33,4,'酒泉',937);                                       
insert into city values(34,4,'兰州',931);                                       
insert into city values(35,4,'临夏',930);                                       
insert into city values(36,4,'陇南',939);                                       
insert into city values(37,4,'平凉',933);                                       
insert into city values(38,4,'庆阳',934);                                       
insert into city values(39,4,'天水',938);                                       
insert into city values(40,4,'武威',935);                                       
insert into city values(41,4,'张掖',936);                                       
insert into city values(42,5,'潮阳',661);                                       
insert into city values(43,5,'潮州',768);                                       
insert into city values(44,5,'从化',20);                                        
insert into city values(45,5,'东莞',769);                                       
insert into city values(46,5,'番禺',20);                                        
insert into city values(47,5,'佛山',757);                                       
insert into city values(48,5,'广州',20);                                        
insert into city values(49,5,'河源',762);                                       
insert into city values(50,5,'花都',20);                                        
insert into city values(51,5,'惠州',752);                                       
insert into city values(52,5,'江门',750);                                       
insert into city values(53,5,'揭阳',663);                                       
insert into city values(54,5,'茂名',668);                                       
insert into city values(55,5,'梅州',753);                                       
insert into city values(56,5,'清远',763);                                       
insert into city values(57,5,'汕头',754);                                       
insert into city values(58,5,'汕尾',660);                                       
insert into city values(59,5,'韶关',751);                                       
insert into city values(60,5,'深圳',755);                                       
insert into city values(61,5,'顺德',765);                                       
insert into city values(62,5,'阳江',662);                                       
insert into city values(63,5,'云浮',766);                                       
insert into city values(64,5,'湛江',759);                                       
insert into city values(65,5,'肇庆',758);                                       
insert into city values(66,5,'中山',760);                                       
insert into city values(67,5,'珠海',756);                                       
insert into city values(68,6,'百色',776);                                       
insert into city values(69,6,'北海',779);                                       
insert into city values(70,6,'防城港',770);                                     
insert into city values(71,6,'桂林',773);                                       
insert into city values(72,6,'河池',778);                                       
insert into city values(73,6,'柳州',772);                                       
insert into city values(74,6,'南宁',771);                                       
insert into city values(75,6,'钦州',777);                                       
insert into city values(76,6,'梧州',774);                                       
insert into city values(77,6,'玉林',775);                                       
insert into city values(78,7,'安顺',853);                                       
insert into city values(79,7,'毕节',857);                                       
insert into city values(80,7,'贵阳',851);                                       
insert into city values(81,7,'六盘水',858);                                     
insert into city values(82,7,'黔东南州',855);                                   
insert into city values(83,7,'黔南州',854);                                     
insert into city values(84,7,'黔西南州',859);                                   
insert into city values(85,7,'铜仁',856);                                       
insert into city values(86,7,'遵义',852);                                       
insert into city values(87,8,'海口',898);                                       
insert into city values(88,8,'三亚',899);                                       
insert into city values(89,8,'儋州',890);                                       
insert into city values(90,9,'保定',312);                                       
insert into city values(91,9,'沧州',317);                                       
insert into city values(92,9,'承德',314);                                       
insert into city values(93,9,'邯郸',310);                                       
insert into city values(94,9,'衡水',318);                                       
insert into city values(95,9,'廊坊',316);                                       
insert into city values(96,9,'秦皇岛',335);                                     
insert into city values(97,9,'石家庄',311);                                     
insert into city values(98,9,'唐山',315);                                       
insert into city values(99,9,'邢台',319);                                       
insert into city values(100,9,'张家口',313);                                    
insert into city values(101,10,'安阳',372);                                     
insert into city values(102,10,'鹤壁',392);                                     
insert into city values(103,10,'焦作',391);                                     
insert into city values(104,10,'开封',378);                                     
insert into city values(105,10,'洛阳',379);                                     
insert into city values(106,10,'南阳',377);                                     
insert into city values(107,10,'平顶山',375);                                   
insert into city values(108,10,'三门峡',398);                                   
insert into city values(109,10,'商丘',370);                                     
insert into city values(110,10,'新乡',373);                                     
insert into city values(111,10,'信阳',376);                                     
insert into city values(112,10,'许昌',374);                                     
insert into city values(113,10,'郑州',371);                                     
insert into city values(114,10,'周口',394);                                     
insert into city values(115,10,'驻马店',396);                                   
insert into city values(116,10,'潢川',397);                                     
insert into city values(117,10,'漯河',395);                                     
insert into city values(118,10,'濮阳',393);                                     
insert into city values(119,11,'大庆',459);                                     
insert into city values(120,11,'大兴安岭',457);                                 
insert into city values(121,11,'哈尔滨',451);                                   
insert into city values(122,11,'鹤岗',468);                                     
insert into city values(123,11,'黑河',456);                                     
insert into city values(124,11,'鸡西',453);                                     
insert into city values(125,11,'佳木斯',454);                                   
insert into city values(126,11,'牡丹江',453);                                   
insert into city values(127,11,'七台河',453);                                   
insert into city values(128,11,'齐齐哈尔',452);                                 
insert into city values(129,11,'双鸭山',469);                                   
insert into city values(130,11,'绥化',455);                                     
insert into city values(131,11,'伊春',458);                                     
insert into city values(132,12,'鄂州',711);                                     
insert into city values(133,12,'恩施',718);                                     
insert into city values(134,12,'黄冈',713);                                     
insert into city values(135,12,'黄石',714);                                     
insert into city values(136,12,'荆门',724);                                     
insert into city values(137,12,'荆州',716);                                     
insert into city values(138,12,'潜江',728);                                     
insert into city values(139,12,'十堰',719);                                     
insert into city values(140,12,'随州',722);                                     
insert into city values(141,12,'天门',728);                                     
insert into city values(142,12,'武汉',27);                                      
insert into city values(143,12,'仙桃',728);