result.sql

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

insert into vlr values(740832,2,347,31);
insert into vlr values(740833,2,347,31);
insert into vlr values(740834,2,347,31);
insert into vlr values(740836,2,347,31);
insert into vlr values(740837,2,347,31);
insert into vlr values(740838,2,347,31);
insert into vlr values(740840,2,159,13);
insert into vlr values(740841,2,148,13);
insert into vlr values(740844,2,151,13);
insert into vlr values(740845,2,149,13);
insert into vlr values(740846,2,149,13);
insert into vlr values(740847,2,149,13);
insert into vlr values(740848,2,149,13);
insert into vlr values(740849,2,149,13);
insert into vlr values(740851,2,80,7);  
insert into vlr values(740852,2,86,7);  
insert into vlr values(740853,2,78,7);  
insert into vlr values(740854,2,83,7);  
insert into vlr values(740855,2,82,7);  
insert into vlr values(740856,2,85,7);  
insert into vlr values(740857,2,79,7);  
insert into vlr values(740858,2,81,7);  
insert into vlr values(740860,2,147,12);
insert into vlr values(740861,2,146,12);
insert into vlr values(740862,2,147,12);
insert into vlr values(740863,2,147,12);
insert into vlr values(740864,2,146,12);
insert into vlr values(740865,2,136,12);
insert into vlr values(740866,2,135,12);
insert into vlr values(740867,2,145,12);
insert into vlr values(740868,2,140,12);
insert into vlr values(740870,2,322,29);
insert into vlr values(740871,2,326,29);
insert into vlr values(740872,2,322,29);
insert into vlr values(740873,2,325,29);
insert into vlr values(740874,2,330,29);
insert into vlr values(740875,2,329,29);
insert into vlr values(740876,2,326,29);
insert into vlr values(740877,2,334,29);
insert into vlr values(740878,2,326,29);
insert into vlr values(740879,2,325,29);
insert into vlr values(740880,2,326,29);
insert into vlr values(740881,2,333,29);
insert into vlr values(740882,2,326,29);
insert into vlr values(740884,2,326,29);
insert into vlr values(740885,2,326,29);
insert into vlr values(740886,2,326,29);
insert into vlr values(740887,2,326,29);
insert into vlr values(740888,2,324,29);
insert into vlr values(740889,2,326,29);
insert into vlr values(740891,2,300,27);
insert into vlr values(740895,2,299,27);
insert into vlr values(740900,2,281,25);
insert into vlr values(740901,2,287,25);
insert into vlr values(740902,2,285,25);
insert into vlr values(740903,2,284,25);
insert into vlr values(740904,2,276,25);
insert into vlr values(740905,2,285,25);
insert into vlr values(740906,2,282,25);
insert into vlr values(740907,2,288,25);
insert into vlr values(740908,2,296,25);
insert into vlr values(740909,2,293,25);
insert into vlr values(740910,2,272,23);
insert into vlr values(740911,2,273,23);
insert into vlr values(740912,2,274,23);
insert into vlr values(740913,2,270,23);
insert into vlr values(740914,2,270,23);
insert into vlr values(740916,2,267,23);
insert into vlr values(740917,2,266,23);
insert into vlr values(740918,2,267,23);
insert into vlr values(740919,2,272,23);
insert into vlr values(740920,2,271,23);
insert into vlr values(740921,2,271,23);
insert into vlr values(740922,2,271,23);
insert into vlr values(740923,2,271,23);
insert into vlr values(740924,2,269,23);
insert into vlr values(740925,2,271,23);
insert into vlr values(740926,2,271,23);
insert into vlr values(740927,2,271,23);
insert into vlr values(740929,2,271,23);
insert into vlr values(740931,2,34,4);  
insert into vlr values(740934,2,38,4);  
insert into vlr values(740935,2,29,4);  
insert into vlr values(740939,2,34,4);  
insert into vlr values(740947,2,32,4);  
insert into vlr values(740950,2,227,19);
insert into vlr values(740960,2,7,1);   
insert into vlr values(740962,2,2,1);   
insert into vlr values(740963,2,15,1);  
insert into vlr values(740969,2,7,1);   
insert into vlr values(740971,2,235,20);
insert into vlr values(740972,2,235,20);
insert into vlr values(740980,2,198,17);
insert into vlr values(740988,2,209,17);
insert into vlr values(740989,2,205,17);
insert into vlr values(740990,2,312,28);
insert into vlr values(740991,2,318,28);
insert into vlr values(740992,2,318,28);
insert into vlr values(740993,2,315,28);
insert into vlr values(740995,2,317,28);
insert into vlr values(740996,2,318,28);
insert into vlr values(740997,2,318,28);
insert into vlr values(740998,2,318,28);
insert into vlr values(740999,2,318,28);
insert into vlr values(741100,2,18,2);  
insert into vlr values(741101,2,18,2);  
insert into vlr values(741102,2,18,2);  
insert into vlr values(741103,2,18,2);  
insert into vlr values(741104,2,18,2);  
insert into vlr values(741105,2,18,2);  
insert into vlr values(741106,2,18,2);  
insert into vlr values(741107,2,18,2);  
insert into vlr values(741108,2,18,2);  
insert into vlr values(741109,2,18,2);  
insert into vlr values(741110,2,18,2);  
insert into vlr values(741111,2,18,2);  
insert into vlr values(741112,2,18,2);  
insert into vlr values(741113,2,18,2);  
insert into vlr values(741114,2,18,2);  
insert into vlr values(741115,2,18,2);  
insert into vlr values(741116,2,18,2);  
insert into vlr values(741117,2,18,2);  
insert into vlr values(741118,2,18,2);  
insert into vlr values(741119,2,18,2);  
insert into vlr values(741120,2,18,2);  
insert into vlr values(741121,2,18,2);  
insert into vlr values(741122,2,18,2);  
insert into vlr values(741123,2,18,2);  
insert into vlr values(741124,2,18,2);  
insert into vlr values(741125,2,18,2);  
insert into vlr values(741126,2,18,2);  
insert into vlr values(741127,2,18,2);  
insert into vlr values(741128,2,18,2);  
insert into vlr values(741129,2,18,2);  
insert into vlr values(741130,2,18,2);  
insert into vlr values(741131,2,18,2);  
insert into vlr values(741132,2,18,2);  
insert into vlr values(741133,2,18,2);  
insert into vlr values(741134,2,18,2);  
insert into vlr values(741135,2,18,2);  
insert into vlr values(741136,2,18,2);  
insert into vlr values(741137,2,18,2);  
insert into vlr values(741138,2,18,2);  
insert into vlr values(741139,2,18,2);  
insert into vlr values(741164,2,275,24);
insert into vlr values(741165,2,275,24);
insert into vlr values(741166,2,275,24);
insert into vlr values(741167,2,275,24);
insert into vlr values(741168,2,275,24);
insert into vlr values(741175,2,275,24);
insert into vlr values(741176,2,275,24);
insert into vlr values(741177,2,275,24);
insert into vlr values(741178,2,275,24);
insert into vlr values(741179,2,275,24);
insert into vlr values(741180,2,275,24);
insert into vlr values(741185,2,275,24);
insert into vlr values(741186,2,275,24);
insert into vlr values(741220,2,44,5);  
insert into vlr values(741221,2,44,5);  
insert into vlr values(741224,2,44,5);  
insert into vlr values(741225,2,45,5);  
insert into vlr values(741226,2,45,5);  
insert into vlr values(741230,2,44,5);  
insert into vlr values(741231,2,45,5);  
insert into vlr values(741232,2,45,5);  
insert into vlr values(741233,2,45,5);  
insert into vlr values(741234,2,45,5);  
insert into vlr values(741235,2,45,5);  
insert into vlr values(741236,2,45,5);  
insert into vlr values(741237,2,45,5);  
insert into vlr values(741238,2,45,5);  
insert into vlr values(741239,2,44,5);  
insert into vlr values(741240,2,44,5);  
insert into vlr values(741241,2,45,5);  
insert into vlr values(741242,2,47,5);  
insert into vlr values(741243,2,57,5);  
insert into vlr values(741244,2,60,5);  
insert into vlr values(741245,2,44,5);  
insert into vlr values(741246,2,44,5);  
insert into vlr values(741247,2,44,5);  
insert into vlr values(741248,2,44,5);  
insert into vlr values(741249,2,44,5);  
insert into vlr values(741250,2,44,5);  
insert into vlr values(741251,2,45,5);  
insert into vlr values(741252,2,45,5);  
insert into vlr values(741253,2,45,5);  
insert into vlr values(741254,2,45,5);  
insert into vlr values(741255,2,51,5);  
insert into vlr values(741256,2,58,5);  
insert into vlr values(741257,2,44,5);  
insert into vlr values(741258,2,53,5);  
insert into vlr values(741259,2,60,5);  
insert into vlr values(741260,2,60,5);  
insert into vlr values(741261,2,60,5);  
insert into vlr values(741262,2,60,5);  
insert into vlr values(741263,2,60,5);  
insert into vlr values(741264,2,47,5);  
insert into vlr values(741265,2,47,5);  
insert into vlr values(741266,2,47,5);  
insert into vlr values(741267,2,52,5);  
insert into vlr values(741268,2,67,5);  
insert into vlr values(741269,2,64,5);  
insert into vlr values(741270,2,54,5);  
insert into vlr values(741271,2,65,5);  
insert into vlr values(741272,2,44,5);  
insert into vlr values(741273,2,47,5);  
insert into vlr values(741274,2,47,5);  
insert into vlr values(741275,2,66,5);  
insert into vlr values(741276,2,67,5);  
insert into vlr values(741277,2,52,5);  
insert into vlr values(741278,2,45,5);  
insert into vlr values(741279,2,51,5);  
insert into vlr values(741280,2,60,5);  
insert into vlr values(741281,2,57,5);  
insert into vlr values(741282,2,44,5);  
insert into vlr values(741285,2,60,5);  
insert into vlr values(741292,2,63,5);  
insert into vlr values(741296,2,45,5);  
insert into vlr values(741298,2,60,5);  
insert into vlr values(741309,2,60,5);  
insert into vlr values(741310,2,93,9);  
insert into vlr values(741311,2,97,9);  
insert into vlr values(741313,2,100,9); 
insert into vlr values(741314,2,92,9);  
insert into vlr values(741316,2,95,9);  
insert into vlr values(741317,2,91,9);  
insert into vlr values(741319,2,99,9);  
insert into vlr values(741320,2,99,9);  
insert into vlr values(741321,2,97,9);  
insert into vlr values(741323,2,100,9); 
insert into vlr values(741324,2,92,9);  
insert into vlr values(741325,2,96,9);  
insert into vlr values(741328,2,94,9);  
insert into vlr values(741332,2,92,9);  
insert into vlr values(741333,2,97,9);  
insert into vlr values(741335,2,97,9);  
insert into vlr values(741336,2,97,9);  
insert into vlr values(741337,2,97,9);  
insert into vlr values(741338,2,97,9);  
insert into vlr values(741339,2,97,9);  
insert into vlr values(741351,2,261,22);
insert into vlr values(741353,2,261,22);
insert into vlr values(741354,2,261,22);
insert into vlr values(741371,2,113,10);
insert into vlr values(741372,2,101,10);
insert into vlr values(741373,2,110,10);
insert into vlr values(741374,2,113,10);
insert into vlr values(741375,2,107,10);
insert into vlr values(741376,2,113,10);
insert into vlr values(741377,2,113,10);
insert into vlr values(741378,2,113,10);
insert into vlr values(741379,2,105,10);
insert into vlr values(741380,2,109,10);
insert into vlr values(741382,2,106,10);
insert into vlr values(741383,2,113,10);
insert into vlr values(741384,2,113,10);
insert into vlr values(741385,2,113,10);
insert into vlr values(741388,2,113,10);
insert into vlr values(741389,2,113,10);
insert into vlr values(741390,2,113,10);
insert into vlr values(741399,2,113,10);
insert into vlr values(741404,2,209,17);
insert into vlr values(741470,2,212,18);
insert into vlr values(741471,2,216,18);
insert into vlr values(741474,2,221,18);
insert into vlr values(741476,2,215,18);
insert into vlr values(741479,2,223,18);
insert into vlr values(741510,2,179,15);
insert into vlr values(741511,2,179,15);
insert into vlr values(741515,2,181,15);
insert into vlr values(741516,2,184,15);
insert into vlr values(741519,2,176,15);
insert into vlr values(741520,2,176,15);
insert into vlr values(741521,2,181,15);
insert into vlr values(741522,2,173,15);
insert into vlr values(741523,2,186,15);
insert into vlr values(741524,2,177,15);
insert into vlr values(741525,2,180,15);
insert into vlr values(741526,2,182,15);
insert into vlr values(741527,2,174,15);
insert into vlr values(741528,2,175,15);
insert into vlr values(741529,2,179,15);
insert into vlr values(741533,2,253,21);
insert into vlr values(741535,2,251,21);
insert into vlr values(741536,2,250,21);
insert into vlr values(741537,2,242,21);
insert into vlr values(741539,2,245,21);
insert into vlr values(741540,2,241,21);
insert into vlr values(741542,2,246,21);
insert into vlr values(741543,2,246,21);
insert into vlr values(741545,2,251,21);
insert into vlr values(741546,2,239,21);
insert into vlr values(741549,2,245,21);
insert into vlr values(741550,2,5,1);   
insert into vlr values(741551,2,7,1);   
insert into vlr values(741553,2,15,1);  
insert into vlr values(741555,2,12,1);  
insert into vlr values(741556,2,1,1);   
insert into vlr values(741559,2,10,1);  
insert into vlr values(741561,2,8,1);   
insert into vlr values(741562,2,14,1);  
insert into vlr values(741563,2,16,1);  
insert into vlr values(741564,2,11,1);  
insert into vlr values(741565,2,3,1);   
insert into vlr values(741571,2,336,30);
insert into vlr values(741572,2,337,30);
insert into vlr values(741573,2,338,30);
insert into vlr values(741574,2,341,30);
insert into vlr values(741575,2,342,30);
insert into vlr values(741578,2,340,30);
insert into vlr values(741580,2,345,30);
insert into vlr values(741581,2,336,30);
insert into vlr values(741583,2,338,30);