result.sql

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

insert into vlr values(743268,2,53,5);  
insert into vlr values(743276,2,55,5);  
insert into vlr values(743277,2,57,5);  
insert into vlr values(743278,2,44,5);  
insert into vlr values(743289,2,52,5);  
insert into vlr values(743300,2,52,5);  
insert into vlr values(743301,2,49,5);  
insert into vlr values(743306,2,45,5);  
insert into vlr values(743307,2,45,5);  
insert into vlr values(743308,2,45,5);  
insert into vlr values(743309,2,45,5);  
insert into vlr values(743370,2,109,10);
insert into vlr values(743371,2,113,10);
insert into vlr values(743372,2,101,10);
insert into vlr values(743373,2,110,10);
insert into vlr values(743375,2,107,10);
insert into vlr values(743376,2,111,10);
insert into vlr values(743377,2,106,10);
insert into vlr values(743378,2,104,10);
insert into vlr values(743379,2,105,10);
insert into vlr values(743380,2,113,10);
insert into vlr values(743381,2,117,10);
insert into vlr values(743391,2,103,10);
insert into vlr values(743393,2,118,10);
insert into vlr values(743394,2,114,10);
insert into vlr values(743395,2,117,10);
insert into vlr values(743396,2,115,10);
insert into vlr values(743791,2,192,16);
insert into vlr values(744129,2,18,2);  
insert into vlr values(744130,2,18,2);  
insert into vlr values(744220,2,45,5);  
insert into vlr values(744221,2,47,5);  
insert into vlr values(744222,2,44,5);  
insert into vlr values(744223,2,44,5);  
insert into vlr values(744224,2,44,5);  
insert into vlr values(744225,2,44,5);  
insert into vlr values(744226,2,44,5);  
insert into vlr values(744227,2,44,5);  
insert into vlr values(744228,2,56,5);  
insert into vlr values(744229,2,47,5);  
insert into vlr values(744230,2,62,5);  
insert into vlr values(744232,2,67,5);  
insert into vlr values(744233,2,45,5);  
insert into vlr values(744234,2,45,5);  
insert into vlr values(744235,2,44,5);  
insert into vlr values(744239,2,55,5);  
insert into vlr values(744240,2,60,5);  
insert into vlr values(744241,2,60,5);  
insert into vlr values(744242,2,63,5);  
insert into vlr values(744244,2,51,5);  
insert into vlr values(744245,2,65,5);  
insert into vlr values(744246,2,51,5);  
insert into vlr values(744248,2,57,5);  
insert into vlr values(744249,2,60,5);  
insert into vlr values(744250,2,60,5);  
insert into vlr values(744251,2,60,5);  
insert into vlr values(744252,2,60,5);  
insert into vlr values(744253,2,60,5);  
insert into vlr values(744254,2,60,5);  
insert into vlr values(744255,2,60,5);  
insert into vlr values(744256,2,64,5);  
insert into vlr values(744257,2,64,5);  
insert into vlr values(744262,2,67,5);  
insert into vlr values(744263,2,67,5);  
insert into vlr values(744266,2,44,5);  
insert into vlr values(760408,2,25,3);  
insert into vlr values(800100,2,18,2);  
insert into vlr values(800146,2,206,17);
insert into vlr values(800200,2,44,5);  
insert into vlr values(800210,2,275,24);
insert into vlr values(800220,2,297,26);
insert into vlr values(800230,2,347,31);
insert into vlr values(800240,2,209,17);
insert into vlr values(800250,2,176,15);
insert into vlr values(800270,2,142,12);
insert into vlr values(800280,2,278,25);
insert into vlr values(800290,2,271,23);
insert into vlr values(800310,2,93,9);  
insert into vlr values(800311,2,97,9);  
insert into vlr values(800312,2,90,9);  
insert into vlr values(800313,2,100,9); 
insert into vlr values(800314,2,92,9);  
insert into vlr values(800315,2,98,9);  
insert into vlr values(800316,2,95,9);  
insert into vlr values(800317,2,91,9);  
insert into vlr values(800318,2,94,9);  
insert into vlr values(800319,2,99,9);  
insert into vlr values(800335,2,96,9);  
insert into vlr values(800349,2,260,22);
insert into vlr values(800350,2,262,22);
insert into vlr values(800351,2,261,22);
insert into vlr values(800352,2,255,22);
insert into vlr values(800353,2,263,22);
insert into vlr values(800354,2,257,22);
insert into vlr values(800355,2,254,22);
insert into vlr values(800356,2,256,22);
insert into vlr values(800357,2,258,22);
insert into vlr values(800358,2,259,22);
insert into vlr values(800359,2,264,22);
insert into vlr values(800370,2,109,10);
insert into vlr values(800371,2,113,10);
insert into vlr values(800372,2,101,10);
insert into vlr values(800373,2,110,10);
insert into vlr values(800374,2,112,10);
insert into vlr values(800375,2,107,10);
insert into vlr values(800376,2,111,10);
insert into vlr values(800377,2,106,10);
insert into vlr values(800378,2,104,10);
insert into vlr values(800379,2,105,10);
insert into vlr values(800391,2,103,10);
insert into vlr values(800392,2,102,10);
insert into vlr values(800393,2,118,10);
insert into vlr values(800394,2,114,10);
insert into vlr values(800395,2,117,10);
insert into vlr values(800396,2,115,10);
insert into vlr values(800397,2,116,10);
insert into vlr values(800398,2,108,10);
insert into vlr values(800410,2,210,17);
insert into vlr values(800411,2,201,17);
insert into vlr values(800412,2,198,17);
insert into vlr values(800413,2,203,17);
insert into vlr values(800414,2,199,17);
insert into vlr values(800415,2,202,17);
insert into vlr values(800416,2,206,17);
insert into vlr values(800417,2,211,17);
insert into vlr values(800418,2,204,17);
insert into vlr values(800419,2,207,17);
insert into vlr values(800421,2,200,17);
insert into vlr values(800427,2,208,17);
insert into vlr values(800429,2,205,17);
insert into vlr values(800431,2,164,14);
insert into vlr values(800432,2,165,14);
insert into vlr values(800433,2,171,14);
insert into vlr values(800434,2,168,14);
insert into vlr values(800435,2,170,14);
insert into vlr values(800436,2,162,14);
insert into vlr values(800437,2,166,14);
insert into vlr values(800438,2,169,14);
insert into vlr values(800439,2,163,14);
insert into vlr values(800451,2,121,11);
insert into vlr values(800452,2,128,11);
insert into vlr values(800453,2,124,11);
insert into vlr values(800454,2,125,11);
insert into vlr values(800455,2,130,11);
insert into vlr values(800456,2,123,11);
insert into vlr values(800458,2,131,11);
insert into vlr values(800459,2,119,11);
insert into vlr values(800470,2,217,18);
insert into vlr values(800471,2,216,18);
insert into vlr values(800472,2,214,18);
insert into vlr values(800473,2,220,18);
insert into vlr values(800474,2,221,18);
insert into vlr values(800475,2,219,18);
insert into vlr values(800476,2,215,18);
insert into vlr values(800477,2,368,18);
insert into vlr values(800478,2,213,18);
insert into vlr values(800479,2,222,18);
insert into vlr values(800482,2,223,18);
insert into vlr values(800483,2,212,18);
insert into vlr values(800510,2,181,15);
insert into vlr values(800511,2,186,15);
insert into vlr values(800512,2,178,15);
insert into vlr values(800513,2,177,15);
insert into vlr values(800514,2,184,15);
insert into vlr values(800515,2,183,15);
insert into vlr values(800516,2,182,15);
insert into vlr values(800517,2,174,15);
insert into vlr values(800518,2,175,15);
insert into vlr values(800519,2,173,15);
insert into vlr values(800523,2,180,15);
insert into vlr values(800527,2,179,15);
insert into vlr values(800530,2,240,21);
insert into vlr values(800531,2,241,21);
insert into vlr values(800532,2,246,21);
insert into vlr values(800533,2,253,21);
insert into vlr values(800534,2,238,21);
insert into vlr values(800535,2,251,21);
insert into vlr values(800536,2,250,21);
insert into vlr values(800537,2,242,21);
insert into vlr values(800538,2,248,21);
insert into vlr values(800539,2,245,21);
insert into vlr values(800543,2,237,21);
insert into vlr values(800546,2,239,21);
insert into vlr values(800550,2,5,1);   
insert into vlr values(800551,2,7,1);   
insert into vlr values(800552,2,2,1);   
insert into vlr values(800553,2,15,1);  
insert into vlr values(800554,2,9,1);   
insert into vlr values(800555,2,12,1);  
insert into vlr values(800556,2,1,1);   
insert into vlr values(800557,2,13,1);  
insert into vlr values(800558,2,6,1);   
insert into vlr values(800559,2,10,1);  
insert into vlr values(800561,2,8,1);   
insert into vlr values(800562,2,14,1);  
insert into vlr values(800563,2,16,1);  
insert into vlr values(800564,2,11,1);  
insert into vlr values(800565,2,3,1);   
insert into vlr values(800566,2,4,1);   
insert into vlr values(800570,2,346,30);
insert into vlr values(800571,2,336,30);
insert into vlr values(800572,2,337,30);
insert into vlr values(800573,2,338,30);
insert into vlr values(800574,2,341,30);
insert into vlr values(800575,2,342,30);
insert into vlr values(800576,2,343,30);
insert into vlr values(800577,2,344,30);
insert into vlr values(800578,2,340,30);
insert into vlr values(800579,2,339,30);
insert into vlr values(800580,2,345,30);
insert into vlr values(800591,2,19,3);  
insert into vlr values(800592,2,26,3);  
insert into vlr values(800593,2,22,3);  
insert into vlr values(800594,2,23,3);  
insert into vlr values(800595,2,24,3);  
insert into vlr values(800596,2,27,3);  
insert into vlr values(800597,2,20,3);  
insert into vlr values(800598,2,25,3);  
insert into vlr values(800599,2,21,3);  
insert into vlr values(800631,2,249,21);
insert into vlr values(800632,2,252,21);
insert into vlr values(800633,2,247,21);
insert into vlr values(800634,2,243,21);
insert into vlr values(800635,2,244,21);
insert into vlr values(800660,2,58,5);  
insert into vlr values(800662,2,62,5);  
insert into vlr values(800663,2,53,5);  
insert into vlr values(800668,2,54,5);  
insert into vlr values(800701,2,197,16);
insert into vlr values(800710,2,145,12);
insert into vlr values(800711,2,132,12);
insert into vlr values(800712,2,146,12);
insert into vlr values(800714,2,135,12);
insert into vlr values(800715,2,144,12);
insert into vlr values(800716,2,137,12);
insert into vlr values(800717,2,147,12);
insert into vlr values(800718,2,133,12);
insert into vlr values(800719,2,139,12);
insert into vlr values(800722,2,140,12);
insert into vlr values(800724,2,136,12);
insert into vlr values(800728,2,138,12);
insert into vlr values(800730,2,159,13);
insert into vlr values(800731,2,149,13);
insert into vlr values(800732,2,156,13);
insert into vlr values(800733,2,161,13);
insert into vlr values(800734,2,151,13);
insert into vlr values(800735,2,150,13);
insert into vlr values(800736,2,148,13);
insert into vlr values(800737,2,157,13);
insert into vlr values(800738,2,154,13);
insert into vlr values(800739,2,155,13);
insert into vlr values(800743,2,153,13);
insert into vlr values(800744,2,160,13);
insert into vlr values(800745,2,152,13);
insert into vlr values(800746,2,158,13);
insert into vlr values(800750,2,52,5);  
insert into vlr values(800751,2,59,5);  
insert into vlr values(800752,2,51,5);  
insert into vlr values(800753,2,55,5);  
insert into vlr values(800754,2,57,5);  
insert into vlr values(800755,2,60,5);  
insert into vlr values(800756,2,67,5);  
insert into vlr values(800757,2,47,5);  
insert into vlr values(800758,2,65,5);  
insert into vlr values(800759,2,64,5);  
insert into vlr values(800760,2,66,5);  
insert into vlr values(800762,2,49,5);  
insert into vlr values(800763,2,56,5);  
insert into vlr values(800765,2,47,5);  
insert into vlr values(800766,2,63,5);  
insert into vlr values(800768,2,43,5);  
insert into vlr values(800769,2,45,5);  
insert into vlr values(800770,2,70,6);  
insert into vlr values(800771,2,74,6);  
insert into vlr values(800772,2,73,6);  
insert into vlr values(800773,2,71,6);  
insert into vlr values(800774,2,76,6);  
insert into vlr values(800775,2,77,6);  
insert into vlr values(800776,2,68,6);  
insert into vlr values(800777,2,75,6);  
insert into vlr values(800778,2,72,6);  
insert into vlr values(800779,2,69,6);  
insert into vlr values(800790,2,195,16);
insert into vlr values(800791,2,192,16);
insert into vlr values(800792,2,191,16);
insert into vlr values(800793,2,194,16);
insert into vlr values(800794,2,187,16);
insert into vlr values(800795,2,196,16);
insert into vlr values(800796,2,189,16);
insert into vlr values(800797,2,188,16);
insert into vlr values(800798,2,190,16);
insert into vlr values(800799,2,193,16);
insert into vlr values(800812,2,290,25);
insert into vlr values(800813,2,295,25);
insert into vlr values(800816,2,287,25);
insert into vlr values(800817,2,288,25);
insert into vlr values(800818,2,279,25);
insert into vlr values(800825,2,291,25);
insert into vlr values(800826,2,282,25);
insert into vlr values(800827,2,277,25);
insert into vlr values(800830,2,296,25);
insert into vlr values(800831,2,293,25);
insert into vlr values(800832,2,285,25);
insert into vlr values(800833,2,284,25);
insert into vlr values(800834,2,369,25);
insert into vlr values(800835,2,292,25);
insert into vlr values(800836,2,281,25);
insert into vlr values(800837,2,276,25);
insert into vlr