result.sql

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

insert into vlr values(741584,2,341,30);
insert into vlr values(741591,2,19,3);  
insert into vlr values(741592,2,26,3);  
insert into vlr values(741593,2,22,3);  
insert into vlr values(741594,2,23,3);  
insert into vlr values(741595,2,24,3);  
insert into vlr values(741597,2,20,3);  
insert into vlr values(741599,2,21,3);  
insert into vlr values(741601,2,24,3);  
insert into vlr values(741602,2,24,3);  
insert into vlr values(741610,2,176,15);
insert into vlr values(741612,2,173,15);
insert into vlr values(741613,2,173,15);
insert into vlr values(741614,2,177,15);
insert into vlr values(741615,2,177,15);
insert into vlr values(741616,2,182,15);
insert into vlr values(741630,2,240,21);
insert into vlr values(741631,2,249,21);
insert into vlr values(741632,2,246,21);
insert into vlr values(741635,2,251,21);
insert into vlr values(741636,2,250,21);
insert into vlr values(741641,2,241,21);
insert into vlr values(741642,2,246,21);
insert into vlr values(741643,2,246,21);
insert into vlr values(741648,2,246,21);
insert into vlr values(741650,2,341,30);
insert into vlr values(741651,2,336,30);
insert into vlr values(741652,2,336,30);
insert into vlr values(741654,2,341,30);
insert into vlr values(741655,2,336,30);
insert into vlr values(741662,2,336,30);
insert into vlr values(741664,2,341,30);
insert into vlr values(741671,2,336,30);
insert into vlr values(741672,2,336,30);
insert into vlr values(741674,2,341,30);
insert into vlr values(741675,2,342,30);
insert into vlr values(741681,2,336,30);
insert into vlr values(741682,2,336,30);
insert into vlr values(741684,2,341,30);
insert into vlr values(741690,2,24,3);  
insert into vlr values(741691,2,19,3);  
insert into vlr values(741700,2,192,16);
insert into vlr values(741701,2,197,16);
insert into vlr values(741702,2,191,16);
insert into vlr values(741703,2,194,16);
insert into vlr values(741706,2,189,16);
insert into vlr values(741707,2,188,16);
insert into vlr values(741708,2,192,16);
insert into vlr values(741731,2,149,13);
insert into vlr values(741732,2,156,13);
insert into vlr values(741735,2,150,13);
insert into vlr values(741745,2,152,13);
insert into vlr values(741746,2,158,13);
insert into vlr values(741748,2,149,13);
insert into vlr values(741749,2,149,13);
insert into vlr values(741771,2,74,6);  
insert into vlr values(741772,2,73,6);  
insert into vlr values(741773,2,71,6);  
insert into vlr values(741774,2,76,6);  
insert into vlr values(741775,2,77,6);  
insert into vlr values(741780,2,74,6);  
insert into vlr values(741781,2,74,6);  
insert into vlr values(741782,2,73,6);  
insert into vlr values(741783,2,71,6);  
insert into vlr values(741784,2,76,6);  
insert into vlr values(741785,2,77,6);  
insert into vlr values(741786,2,77,6);  
insert into vlr values(741787,2,73,6);  
insert into vlr values(741788,2,73,6);  
insert into vlr values(741790,2,195,16);
insert into vlr values(741791,2,192,16);
insert into vlr values(741792,2,191,16);
insert into vlr values(741793,2,194,16);
insert into vlr values(741794,2,187,16);
insert into vlr values(741795,2,196,16);
insert into vlr values(741796,2,189,16);
insert into vlr values(741797,2,188,16);
insert into vlr values(741798,2,190,16);
insert into vlr values(741799,2,193,16);
insert into vlr values(741805,2,278,25);
insert into vlr values(741806,2,278,25);
insert into vlr values(741807,2,278,25);
insert into vlr values(741808,2,278,25);
insert into vlr values(741809,2,278,25);
insert into vlr values(741813,2,284,25);
insert into vlr values(741814,2,290,25);
insert into vlr values(741815,2,369,25);
insert into vlr values(741830,2,347,31);
insert into vlr values(741831,2,347,31);
insert into vlr values(741832,2,347,31);
insert into vlr values(741833,2,347,31);
insert into vlr values(741834,2,347,31);
insert into vlr values(741835,2,347,31);
insert into vlr values(741836,2,347,31);
insert into vlr values(741837,2,347,31);
insert into vlr values(741838,2,347,31);
insert into vlr values(741845,2,149,13);
insert into vlr values(741870,2,335,29);
insert into vlr values(741871,2,326,29);
insert into vlr values(741873,2,325,29);
insert into vlr values(741874,2,323,29);
insert into vlr values(741875,2,320,29);
insert into vlr values(741876,2,332,29);
insert into vlr values(741878,2,321,29);
insert into vlr values(741879,2,331,29);
insert into vlr values(741883,2,328,29);
insert into vlr values(741888,2,327,29);
insert into vlr values(741910,2,272,23);
insert into vlr values(741911,2,273,23);
insert into vlr values(741912,2,274,23);
insert into vlr values(741914,2,271,23);
insert into vlr values(741917,2,266,23);
insert into vlr values(741918,2,266,23);
insert into vlr values(741919,2,272,23);
insert into vlr values(741920,2,270,23);
insert into vlr values(741990,2,318,28);
insert into vlr values(741991,2,318,28);
insert into vlr values(741992,2,318,28);
insert into vlr values(741993,2,314,28);
insert into vlr values(741994,2,308,28);
insert into vlr values(741995,2,308,28);
insert into vlr values(741996,2,313,28);
insert into vlr values(741997,2,305,28);
insert into vlr values(741998,2,311,28);
insert into vlr values(741999,2,319,28);
insert into vlr values(742100,2,18,2);  
insert into vlr values(742101,2,18,2);  
insert into vlr values(742102,2,18,2);  
insert into vlr values(742103,2,18,2);  
insert into vlr values(742104,2,18,2);  
insert into vlr values(742105,2,18,2);  
insert into vlr values(742106,2,18,2);  
insert into vlr values(742107,2,18,2);  
insert into vlr values(742108,2,18,2);  
insert into vlr values(742109,2,18,2);  
insert into vlr values(742110,2,18,2);  
insert into vlr values(742111,2,18,2);  
insert into vlr values(742112,2,18,2);  
insert into vlr values(742113,2,18,2);  
insert into vlr values(742128,2,18,2);  
insert into vlr values(742129,2,18,2);  
insert into vlr values(742136,2,18,2);  
insert into vlr values(742138,2,18,2);  
insert into vlr values(742139,2,18,2);  
insert into vlr values(742225,2,45,5);  
insert into vlr values(742226,2,44,5);  
insert into vlr values(742227,2,44,5);  
insert into vlr values(742228,2,60,5);  
insert into vlr values(742229,2,60,5);  
insert into vlr values(742243,2,60,5);  
insert into vlr values(742244,2,60,5);  
insert into vlr values(742245,2,49,5);  
insert into vlr values(742246,2,44,5);  
insert into vlr values(742247,2,44,5);  
insert into vlr values(742248,2,44,5);  
insert into vlr values(742249,2,52,5);  
insert into vlr values(742250,2,52,5);  
insert into vlr values(742251,2,58,5);  
insert into vlr values(742252,2,66,5);  
insert into vlr values(742253,2,66,5);  
insert into vlr values(742254,2,67,5);  
insert into vlr values(742255,2,67,5);  
insert into vlr values(742256,2,56,5);  
insert into vlr values(742257,2,56,5);  
insert into vlr values(742258,2,59,5);  
insert into vlr values(742268,2,59,5);  
insert into vlr values(742269,2,67,5);  
insert into vlr values(742287,2,45,5);  
insert into vlr values(742288,2,45,5);  
insert into vlr values(742289,2,45,5);  
insert into vlr values(742290,2,45,5);  
insert into vlr values(742293,2,45,5);  
insert into vlr values(742305,2,43,5);  
insert into vlr values(742306,2,47,5);  
insert into vlr values(742307,2,47,5);  
insert into vlr values(742308,2,44,5);  
insert into vlr values(742309,2,44,5);  
insert into vlr values(742310,2,93,9);  
insert into vlr values(742313,2,100,9); 
insert into vlr values(742315,2,98,9);  
insert into vlr values(742316,2,95,9);  
insert into vlr values(742317,2,91,9);  
insert into vlr values(742325,2,98,9);  
insert into vlr values(742326,2,95,9);  
insert into vlr values(742334,2,98,9);  
insert into vlr values(742335,2,96,9);  
insert into vlr values(742336,2,98,9);  
insert into vlr values(742338,2,98,9);  
insert into vlr values(742371,2,113,10);
insert into vlr values(742372,2,101,10);
insert into vlr values(742373,2,102,10);
insert into vlr values(742374,2,112,10);
insert into vlr values(742375,2,107,10);
insert into vlr values(742376,2,111,10);
insert into vlr values(742377,2,106,10);
insert into vlr values(742378,2,104,10);
insert into vlr values(742379,2,105,10);
insert into vlr values(742380,2,113,10);
insert into vlr values(742381,2,113,10);
insert into vlr values(742382,2,101,10);
insert into vlr values(742383,2,104,10);
insert into vlr values(742384,2,111,10);
insert into vlr values(742385,2,114,10);
insert into vlr values(742386,2,115,10);
insert into vlr values(742387,2,109,10);
insert into vlr values(742388,2,113,10);
insert into vlr values(742389,2,106,10);
insert into vlr values(742391,2,103,10);
insert into vlr values(742393,2,118,10);
insert into vlr values(742394,2,114,10);
insert into vlr values(742395,2,117,10);
insert into vlr values(742396,2,115,10);
insert into vlr values(742397,2,118,10);
insert into vlr values(742398,2,108,10);
insert into vlr values(742399,2,112,10);
insert into vlr values(742556,2,1,1);   
insert into vlr values(742562,2,1,1);   
insert into vlr values(742651,2,336,30);
insert into vlr values(742700,2,192,16);
insert into vlr values(742703,2,192,16);
insert into vlr values(742708,2,192,16);
insert into vlr values(742709,2,192,16);
insert into vlr values(742731,2,149,13);
insert into vlr values(742735,2,150,13);
insert into vlr values(742748,2,149,13);
insert into vlr values(742749,2,149,13);
insert into vlr values(742772,2,73,6);  
insert into vlr values(742773,2,71,6);  
insert into vlr values(742775,2,77,6);  
insert into vlr values(742782,2,73,6);  
insert into vlr values(742791,2,192,16);
insert into vlr values(742792,2,191,16);
insert into vlr values(742793,2,194,16);
insert into vlr values(742794,2,187,16);
insert into vlr values(742795,2,196,16);
insert into vlr values(742797,2,188,16);
insert into vlr values(742830,2,347,31);
insert into vlr values(742831,2,347,31);
insert into vlr values(742832,2,347,31);
insert into vlr values(742835,2,347,31);
insert into vlr values(742837,2,347,31);
insert into vlr values(742960,2,7,1);   
insert into vlr values(742961,2,7,1);   
insert into vlr values(742969,2,7,1);   
insert into vlr values(742990,2,306,28);
insert into vlr values(742991,2,309,28);
insert into vlr values(742992,2,318,28);
insert into vlr values(742993,2,313,28);
insert into vlr values(742994,2,308,28);
insert into vlr values(742995,2,311,28);
insert into vlr values(742996,2,313,28);
insert into vlr values(742997,2,305,28);
insert into vlr values(742998,2,311,28);
insert into vlr values(743100,2,18,2);  
insert into vlr values(743101,2,18,2);  
insert into vlr values(743102,2,18,2);  
insert into vlr values(743103,2,18,2);  
insert into vlr values(743104,2,18,2);  
insert into vlr values(743105,2,18,2);  
insert into vlr values(743106,2,18,2);  
insert into vlr values(743107,2,18,2);  
insert into vlr values(743108,2,18,2);  
insert into vlr values(743109,2,18,2);  
insert into vlr values(743110,2,18,2);  
insert into vlr values(743111,2,18,2);  
insert into vlr values(743112,2,18,2);  
insert into vlr values(743113,2,18,2);  
insert into vlr values(743114,2,18,2);  
insert into vlr values(743115,2,18,2);  
insert into vlr values(743116,2,18,2);  
insert into vlr values(743117,2,18,2);  
insert into vlr values(743120,2,18,2);  
insert into vlr values(743121,2,18,2);  
insert into vlr values(743122,2,18,2);  
insert into vlr values(743123,2,18,2);  
insert into vlr values(743124,2,18,2);  
insert into vlr values(743125,2,18,2);  
insert into vlr values(743128,2,18,2);  
insert into vlr values(743129,2,18,2);  
insert into vlr values(743130,2,18,2);  
insert into vlr values(743131,2,18,2);  
insert into vlr values(743220,2,44,5);  
insert into vlr values(743221,2,44,5);  
insert into vlr values(743222,2,44,5);  
insert into vlr values(743223,2,44,5);  
insert into vlr values(743224,2,44,5);  
insert into vlr values(743225,2,51,5);  
insert into vlr values(743226,2,52,5);  
insert into vlr values(743227,2,53,5);  
insert into vlr values(743228,2,54,5);  
insert into vlr values(743229,2,55,5);  
insert into vlr values(743230,2,57,5);  
insert into vlr values(743231,2,57,5);  
insert into vlr values(743232,2,59,5);  
insert into vlr values(743233,2,60,5);  
insert into vlr values(743234,2,60,5);  
insert into vlr values(743235,2,60,5);  
insert into vlr values(743236,2,60,5);  
insert into vlr values(743237,2,60,5);  
insert into vlr values(743238,2,63,5);  
insert into vlr values(743239,2,64,5);  
insert into vlr values(743240,2,64,5);  
insert into vlr values(743241,2,66,5);  
insert into vlr values(743242,2,67,5);  
insert into vlr values(743247,2,44,5);  
insert into vlr values(743248,2,44,5);  
insert into vlr values(743249,2,60,5);  
insert into vlr values(743257,2,52,5);  
insert into vlr values(743260,2,44,5);  
insert into vlr values(743261,2,44,5);  
insert into vlr values(743262,2,60,5);  
insert into vlr values(743263,2,66,5);  
insert into vlr values(743264,2,60,5);