result.sql

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

SET ECHO      ON;                                                                                   
create table tcity(id number(3),PROVINCE_ID number(3),name varchar2(20),code varchar2(4));          
insert into tcity values(276,25,'阿坝','0837');                                                     
insert into tcity values(305,28,'阿克苏','0997');                                                   
insert into tcity values(212,18,'阿拉善左旗','0483');                                               
insert into tcity values(306,28,'阿勒泰','0906');                                                   
insert into tcity values(298,27,'阿里','0897');                                                     
insert into tcity values(198,17,'鞍山','0412');                                                     
insert into tcity values(265,23,'安康','0915');                                                     
insert into tcity values(1,1,'安庆','0556');                                                        
insert into tcity values(78,7,'安顺','0853');                                                       
insert into tcity values(101,10,'安阳','0372');                                                     
insert into tcity values(213,18,'巴彦淖尔','0478');                                                 
insert into tcity values(277,25,'巴中','0827');                                                     
insert into tcity values(162,14,'白城','0436');                                                     
insert into tcity values(163,14,'白山','0439');                                                     
insert into tcity values(28,4,'白银','0943');                                                       
insert into tcity values(68,6,'百色','0776');                                                       
insert into tcity values(2,1,'蚌埠','0552');                                                        
insert into tcity values(214,18,'包头','0472');                                                     
insert into tcity values(90,9,'保定','0312');                                                       
insert into tcity values(320,29,'保山','0875');                                                     
insert into tcity values(266,23,'宝鸡','0917');                                                     
insert into tcity values(69,6,'北海','0779');                                                       
insert into tcity values(18,2,'北京','010');                                                        
insert into tcity values(199,17,'本溪','0414');                                                     
insert into tcity values(79,7,'毕节','0857');                                                       
insert into tcity values(237,21,'滨州','0543');                                                     
insert into tcity values(307,28,'博州','0909');                                                     
insert into tcity values(91,9,'沧州','0317');                                                       
insert into tcity values(299,27,'昌都','0895');                                                     
insert into tcity values(308,28,'昌吉','0994');                                                     
insert into tcity values(148,13,'常德','0736');                                                     
insert into tcity values(173,15,'常州','0519');                                                     
insert into tcity values(164,14,'长春','0431');                                                     
insert into tcity values(149,13,'长沙','0731');                                                     
insert into tcity values(254,22,'长治','0355');                                                     
insert into tcity values(200,17,'朝阳','0421');                                                     
insert into tcity values(42,5,'潮阳','0661');                                                       
insert into tcity values(43,5,'潮州','0768');                                                       
insert into tcity values(3,1,'巢湖','0565');                                                        
insert into tcity values(150,13,'郴州','0735');                                                     
insert into tcity values(278,25,'成都','028');                                                      
insert into tcity values(92,9,'承德','0314');                                                       
insert into tcity values(4,1,'池州','0566');                                                        
insert into tcity values(215,18,'赤峰','0476');                                                     
insert into tcity values(5,1,'滁州','0550');                                                        
insert into tcity values(321,29,'楚雄','0878');                                                     
insert into tcity values(44,5,'从化','020');                                                        
insert into tcity values(279,25,'达州','0818');                                                     
insert into tcity values(322,29,'大理','0872');                                                     
insert into tcity values(201,17,'大连','0411');                                                     
insert into tcity values(119,11,'大庆','0459');                                                     
insert into tcity values(255,22,'大同','0352');                                                     
insert into tcity values(120,11,'大兴安岭','0457');                                                 
insert into tcity values(202,17,'丹东','0415');                                                     
insert into tcity values(323,29,'德宏','0692');                                                     
insert into tcity values(280,25,'德阳','0838');                                                     
insert into tcity values(238,21,'德州','0534');                                                     
insert into tcity values(324,29,'迪庆','0887');                                                     
insert into tcity values(29,4,'定西','0932');                                                       
insert into tcity values(239,21,'东营','0546');                                                     
insert into tcity values(45,5,'东莞','0769');                                                       
insert into tcity values(216,18,'鄂尔多斯','0471');                                                 
insert into tcity values(132,12,'鄂州','0711');                                                     
insert into tcity values(133,12,'恩施','0718');                                                     
insert into tcity values(46,5,'番禺','020');                                                        
insert into tcity values(70,6,'防城港','0770');                                                     
insert into tcity values(47,5,'佛山','0757');                                                       
insert into tcity values(347,31,'涪陵','023');                                                      
insert into tcity values(19,3,'福州','0591');                                                       
insert into tcity values(203,17,'抚顺','0413');                                                     
insert into tcity values(187,16,'抚州','0794');                                                     
insert into tcity values(204,17,'阜新','0418');                                                     
insert into tcity values(6,1,'阜阳','0558');                                                        
insert into tcity values(30,4,'甘南','0941');                                                       
insert into tcity values(281,25,'甘孜','0836');                                                     
insert into tcity values(188,16,'赣州','0797');                                                     
insert into tcity values(228,20,'格尔木','0979');                                                   
insert into tcity values(224,19,'固原','0954');                                                     
insert into tcity values(282,25,'广安','0826');                                                     
insert into tcity values(283,25,'广元','0839');                                                     
insert into tcity values(48,5,'广州','020');                                                        
insert into tcity values(71,6,'桂林','0773');                                                       
insert into tcity values(80,7,'贵阳','0851');                                                       
insert into tcity values(121,11,'哈尔滨','0451');                                                   
insert into tcity values(309,28,'哈密','0902');                                                     
insert into tcity values(229,20,'海北州','0979');                                                   
insert into tcity values(230,20,'海东州','0972');                                                   
insert into tcity values(87,8,'海口','0898');                                                       
insert into tcity values(217,18,'呼伦贝尔','0470');                                                 
insert into tcity values(231,20,'海南州','0979');                                                   
insert into tcity values(232,20,'海西州','0979');                                                   
insert into tcity values(93,9,'邯郸','0310');                                                       
insert into tcity values(267,23,'汉中','0916');                                                     
insert into tcity values(336,30,'杭州','0571');                                                     
insert into tcity values(240,21,'菏泽','0530');                                                     
insert into tcity values(310,28,'和田','0903');                                                     
insert into tcity values(7,1,'合肥','0551');                                                        
insert into tcity values(72,6,'河池','0778');                                                       
insert into tcity values(49,5,'河源','0762');                                                       
insert into tcity values(102,10,'鹤壁','0392');                                                     
insert into tcity values(122,11,'鹤岗','0468');                                                     
insert into tcity values(123,11,'黑河','0456');                                                     
insert into tcity values(94,9,'衡水','0318');                                                       
insert into tcity values(151,13,'衡阳','0734');                                                     
insert into tcity values(325,29,'红河','0873');                                                     
insert into tcity values(218,18,'呼和浩特','0471');                                                 
insert into tcity values(205,17,'葫芦岛','0429');                                                   
insert into tcity values(337,30,'湖州','0572');                                                     
insert into tcity values(50,5,'花都','020');                                                        
insert into tcity values(152,13,'怀化','0745');                                                     
insert into tcity values(174,15,'淮安','0517');                                                     
insert into tcity values(8,1,'淮北','0561');                                                        
insert into tcity values(9,1,'淮南','0554');                                                        
insert into tcity values(134,12,'黄冈','0713');                                                     
insert into tcity values(233,20,'黄南藏族','0973');                                                 
insert into tcity values(10,1,'黄山','0559');                                                       
insert into tcity values(135,12,'黄石','0714');                                                     
insert into tcity values(51,5,'惠州','0752');                                                       
insert into tcity values(124,11,'鸡西','0453');                                                     
insert into tcity values(189,16,'吉安','0796');                                                     
insert into tcity values(165,14,'吉林','0432');                                                     
insert into tcity values(153,13,'吉首','0743');                                                     
insert into tcity values(241,21,'济南','0531');                                                     
insert into tcity values(242,21,'济宁','0537');                                                     
insert into tcity values(338,30,'嘉兴','0573');                                                     
insert into tcity values(31,4,'嘉峪关','0937');                                                     
insert into tcity values(125,11,'佳木斯','0454');                                                   
insert into tcity values(52,5,'江门','0750');                                                       
insert into tcity values(103,10,'焦作','0391');                                                     
insert into tcity values(53,5,'揭阳','0663');                                                       
insert into tcity values(32,4,'金昌','0935');                                                       
insert into tcity values(339,30,'金华','0579');                                                     
insert into tcity values(206,17,'锦州','0416');                                                     
insert into tcity values(256,22,'晋城','0356');                                                     
insert into tcity values(257,22,'晋中','0354');                                                     
insert into tcity values(136,12,'荆门','0724');                                                     
insert into tcity values(137,12,'荆州','0716');                                                     
insert into tcity values(190,16,'景德镇','0798');                                                   
insert into tcity values(191,16,'九江','0792');                                                     
insert into tcity values(33,4,'酒泉','0937');                                                       
insert into tcity values(311,28,'喀什','0998');                                                     
insert into tcity values(104,10,'开封','0378');                                                     
insert into tcity values(312,28,'克拉玛依','0990');                                                 
insert into tcity values(313,28,'库尔勒','0996');