result.sql

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

SET ECHO      ON;                       
delete from vlr;                        
commit;                                 
insert into vlr values(740024,2,201,17);
insert into vlr values(740026,2,201,17);
insert into vlr values(740084,2,83,7);  
insert into vlr values(740085,2,80,7);  
insert into vlr values(740086,2,85,7);  
insert into vlr values(740087,2,86,7);  
insert into vlr values(740100,2,18,2);  
insert into vlr values(740101,2,18,2);  
insert into vlr values(740102,2,18,2);  
insert into vlr values(740103,2,18,2);  
insert into vlr values(740104,2,18,2);  
insert into vlr values(740105,2,18,2);  
insert into vlr values(740106,2,18,2);  
insert into vlr values(740107,2,18,2);  
insert into vlr values(740108,2,18,2);  
insert into vlr values(740109,2,18,2);  
insert into vlr values(740110,2,18,2);  
insert into vlr values(740111,2,18,2);  
insert into vlr values(740112,2,18,2);  
insert into vlr values(740113,2,18,2);  
insert into vlr values(740114,2,18,2);  
insert into vlr values(740115,2,18,2);  
insert into vlr values(740116,2,18,2);  
insert into vlr values(740117,2,18,2);  
insert into vlr values(740118,2,18,2);  
insert into vlr values(740119,2,18,2);  
insert into vlr values(740120,2,18,2);  
insert into vlr values(740121,2,18,2);  
insert into vlr values(740122,2,18,2);  
insert into vlr values(740123,2,18,2);  
insert into vlr values(740125,2,18,2);  
insert into vlr values(740126,2,18,2);  
insert into vlr values(740127,2,18,2);  
insert into vlr values(740128,2,18,2);  
insert into vlr values(740129,2,18,2);  
insert into vlr values(740130,2,18,2);  
insert into vlr values(740131,2,18,2);  
insert into vlr values(740133,2,18,2);  
insert into vlr values(740134,2,18,2);  
insert into vlr values(740135,2,18,2);  
insert into vlr values(740138,2,18,2);  
insert into vlr values(740139,2,18,2);  
insert into vlr values(740140,2,174,15);
insert into vlr values(740141,2,183,15);
insert into vlr values(740142,2,180,15);
insert into vlr values(740143,2,180,15);
insert into vlr values(740144,2,184,15);
insert into vlr values(740146,2,177,15);
insert into vlr values(740147,2,174,15);
insert into vlr values(740148,2,175,15);
insert into vlr values(740149,2,175,15);
insert into vlr values(740150,2,173,15);
insert into vlr values(740151,2,181,15);
insert into vlr values(740152,2,181,15);
insert into vlr values(740153,2,178,15);
insert into vlr values(740154,2,176,15);
insert into vlr values(740155,2,178,15);
insert into vlr values(740156,2,176,15);
insert into vlr values(740157,2,176,15);
insert into vlr values(740158,2,176,15);
insert into vlr values(740159,2,176,15);
insert into vlr values(740160,2,275,24);
insert into vlr values(740161,2,275,24);
insert into vlr values(740162,2,275,24);
insert into vlr values(740163,2,275,24);
insert into vlr values(740164,2,275,24);
insert into vlr values(740165,2,275,24);
insert into vlr values(740166,2,275,24);
insert into vlr values(740167,2,275,24);
insert into vlr values(740168,2,275,24);
insert into vlr values(740169,2,275,24);
insert into vlr values(740170,2,275,24);
insert into vlr values(740171,2,275,24);
insert into vlr values(740172,2,275,24);
insert into vlr values(740173,2,275,24);
insert into vlr values(740174,2,275,24);
insert into vlr values(740175,2,275,24);
insert into vlr values(740176,2,275,24);
insert into vlr values(740177,2,275,24);
insert into vlr values(740179,2,275,24);
insert into vlr values(740180,2,275,24);
insert into vlr values(740181,2,275,24);
insert into vlr values(740182,2,275,24);
insert into vlr values(740183,2,275,24);
insert into vlr values(740184,2,275,24);
insert into vlr values(740185,2,275,24);
insert into vlr values(740186,2,275,24);
insert into vlr values(740187,2,275,24);
insert into vlr values(740188,2,275,24);
insert into vlr values(740189,2,275,24);
insert into vlr values(740190,2,275,24);
insert into vlr values(740191,2,275,24);
insert into vlr values(740192,2,275,24);
insert into vlr values(740193,2,275,24);
insert into vlr values(740194,2,275,24);
insert into vlr values(740195,2,275,24);
insert into vlr values(740196,2,275,24);
insert into vlr values(740197,2,275,24);
insert into vlr values(740198,2,275,24);
insert into vlr values(740199,2,275,24);
insert into vlr values(740201,2,297,26);
insert into vlr values(740203,2,297,26);
insert into vlr values(740204,2,297,26);
insert into vlr values(740205,2,297,26);
insert into vlr values(740206,2,297,26);
insert into vlr values(740207,2,297,26);
insert into vlr values(740208,2,297,26);
insert into vlr values(740209,2,297,26);
insert into vlr values(740210,2,297,26);
insert into vlr values(740211,2,297,26);
insert into vlr values(740212,2,297,26);
insert into vlr values(740213,2,297,26);
insert into vlr values(740220,2,44,5);  
insert into vlr values(740221,2,60,5);  
insert into vlr values(740222,2,52,5);  
insert into vlr values(740224,2,44,5);  
insert into vlr values(740225,2,44,5);  
insert into vlr values(740226,2,44,5);  
insert into vlr values(740227,2,51,5);  
insert into vlr values(740228,2,57,5);  
insert into vlr values(740229,2,66,5);  
insert into vlr values(740230,2,44,5);  
insert into vlr values(740231,2,45,5);  
insert into vlr values(740232,2,51,5);  
insert into vlr values(740233,2,57,5);  
insert into vlr values(740234,2,60,5);  
insert into vlr values(740235,2,47,5);  
insert into vlr values(740236,2,52,5);  
insert into vlr values(740237,2,67,5);  
insert into vlr values(740238,2,66,5);  
insert into vlr values(740239,2,64,5);  
insert into vlr values(740240,2,44,5);  
insert into vlr values(740241,2,44,5);  
insert into vlr values(740242,2,44,5);  
insert into vlr values(740244,2,66,5);  
insert into vlr values(740245,2,45,5);  
insert into vlr values(740246,2,45,5);  
insert into vlr values(740247,2,51,5);  
insert into vlr values(740248,2,60,5);  
insert into vlr values(740249,2,60,5);  
insert into vlr values(740250,2,60,5);  
insert into vlr values(740251,2,47,5);  
insert into vlr values(740252,2,47,5);  
insert into vlr values(740254,2,67,5);  
insert into vlr values(740255,2,66,5);  
insert into vlr values(740256,2,62,5);  
insert into vlr values(740257,2,44,5);  
insert into vlr values(740258,2,44,5);  
insert into vlr values(740259,2,44,5);  
insert into vlr values(740260,2,44,5);  
insert into vlr values(740261,2,51,5);  
insert into vlr values(740262,2,51,5);  
insert into vlr values(740263,2,51,5);  
insert into vlr values(740264,2,58,5);  
insert into vlr values(740265,2,57,5);  
insert into vlr values(740266,2,57,5);  
insert into vlr values(740267,2,57,5);  
insert into vlr values(740268,2,57,5);  
insert into vlr values(740269,2,57,5);  
insert into vlr values(740270,2,43,5);  
insert into vlr values(740271,2,43,5);  
insert into vlr values(740272,2,55,5);  
insert into vlr values(740273,2,53,5);  
insert into vlr values(740274,2,53,5);  
insert into vlr values(740275,2,53,5);  
insert into vlr values(740276,2,60,5);  
insert into vlr values(740277,2,47,5);  
insert into vlr values(740278,2,47,5);  
insert into vlr values(740280,2,47,5);  
insert into vlr values(740282,2,47,5);  
insert into vlr values(740283,2,47,5);  
insert into vlr values(740284,2,52,5);  
insert into vlr values(740285,2,52,5);  
insert into vlr values(740286,2,52,5);  
insert into vlr values(740287,2,44,5);  
insert into vlr values(740288,2,67,5);  
insert into vlr values(740289,2,67,5);  
insert into vlr values(740290,2,66,5);  
insert into vlr values(740291,2,66,5);  
insert into vlr values(740292,2,64,5);  
insert into vlr values(740293,2,64,5);  
insert into vlr values(740294,2,64,5);  
insert into vlr values(740295,2,54,5);  
insert into vlr values(740296,2,54,5);  
insert into vlr values(740297,2,54,5);  
insert into vlr values(740298,2,54,5);  
insert into vlr values(740299,2,65,5);  
insert into vlr values(740300,2,59,5);  
insert into vlr values(740301,2,56,5);  
insert into vlr values(740302,2,44,5);  
insert into vlr values(740303,2,60,5);  
insert into vlr values(740305,2,60,5);  
insert into vlr values(740306,2,47,5);  
insert into vlr values(740307,2,66,5);  
insert into vlr values(740308,2,66,5);  
insert into vlr values(740309,2,52,5);  
insert into vlr values(740310,2,93,9);  
insert into vlr values(740311,2,97,9);  
insert into vlr values(740312,2,90,9);  
insert into vlr values(740313,2,100,9); 
insert into vlr values(740314,2,92,9);  
insert into vlr values(740315,2,98,9);  
insert into vlr values(740316,2,95,9);  
insert into vlr values(740317,2,91,9);  
insert into vlr values(740318,2,94,9);  
insert into vlr values(740319,2,99,9);  
insert into vlr values(740320,2,93,9);  
insert into vlr values(740321,2,97,9);  
insert into vlr values(740322,2,90,9);  
insert into vlr values(740323,2,90,9);  
insert into vlr values(740324,2,97,9);  
insert into vlr values(740325,2,98,9);  
insert into vlr values(740326,2,90,9);  
insert into vlr values(740327,2,91,9);  
insert into vlr values(740328,2,94,9);  
insert into vlr values(740329,2,99,9);  
insert into vlr values(740330,2,93,9);  
insert into vlr values(740331,2,97,9);  
insert into vlr values(740332,2,90,9);  
insert into vlr values(740333,2,97,9);  
insert into vlr values(740334,2,98,9);  
insert into vlr values(740335,2,96,9);  
insert into vlr values(740336,2,95,9);  
insert into vlr values(740337,2,91,9);  
insert into vlr values(740338,2,94,9);  
insert into vlr values(740339,2,97,9);  
insert into vlr values(740340,2,261,22);
insert into vlr values(740341,2,261,22);
insert into vlr values(740342,2,261,22);
insert into vlr values(740344,2,261,22);
insert into vlr values(740350,2,262,22);
insert into vlr values(740351,2,261,22);
insert into vlr values(740352,2,255,22);
insert into vlr values(740354,2,257,22);
insert into vlr values(740355,2,254,22);
insert into vlr values(740356,2,256,22);
insert into vlr values(740357,2,258,22);
insert into vlr values(740358,2,259,22);
insert into vlr values(740359,2,264,22);
insert into vlr values(740360,2,121,11);
insert into vlr values(740361,2,121,11);
insert into vlr values(740363,2,128,11);
insert into vlr values(740364,2,128,11);
insert into vlr values(740365,2,124,11);
insert into vlr values(740366,2,125,11);
insert into vlr values(740370,2,109,10);
insert into vlr values(740371,2,113,10);
insert into vlr values(740372,2,101,10);
insert into vlr values(740373,2,110,10);
insert into vlr values(740374,2,112,10);
insert into vlr values(740375,2,107,10);
insert into vlr values(740376,2,111,10);
insert into vlr values(740377,2,106,10);
insert into vlr values(740378,2,104,10);
insert into vlr values(740379,2,105,10);
insert into vlr values(740380,2,113,10);
insert into vlr values(740381,2,113,10);
insert into vlr values(740382,2,106,10);
insert into vlr values(740383,2,103,10);
insert into vlr values(740384,2,110,10);
insert into vlr values(740385,2,105,10);
insert into vlr values(740386,2,113,10);
insert into vlr values(740387,2,113,10);
insert into vlr values(740388,2,105,10);
insert into vlr values(740389,2,107,10);
insert into vlr values(740390,2,103,10);
insert into vlr values(740391,2,103,10);
insert into vlr values(740392,2,102,10);
insert into vlr values(740393,2,118,10);
insert into vlr values(740394,2,114,10);
insert into vlr values(740395,2,117,10);
insert into vlr values(740396,2,115,10);
insert into vlr values(740397,2,113,10);
insert into vlr values(740398,2,108,10);
insert into vlr values(740399,2,113,10);
insert into vlr values(740402,2,209,17);
insert into vlr values(740404,2,209,17);
insert into vlr values(740405,2,209,17);
insert into vlr values(740407,2,206,17);
insert into vlr values(740408,2,201,17);
insert into vlr values(740409,2,201,17);
insert into vlr values(740410,2,210,17);
insert into vlr values(740411,2,201,17);
insert into vlr values(740412,2,198,17);
insert into vlr values(740413,2,203,17);
insert into vlr values(740414,2,199,17);
insert into vlr values(740415,2,202,17);
insert into vlr values(740416,2,206,17);
insert into vlr values(740418,2,206,17);
insert into vlr values(740419,2,207,17);
insert into vlr values(740420,2,198,17);
insert into vlr values(740421,2,200,17);
insert into vlr values(740422,2,198,17);
insert into vlr values(740424,2,198,17);
insert into vlr values(740425,2,202,17);
insert into vlr values(740426,2,201,17);
insert into vlr values(740427,2,208,17);
insert into vlr values(740428,2,201,17);
insert into vlr values(740429,2,205,17);
insert into vlr values(740430,2,164,14);
insert into vlr values(740431,2,164,14);
insert into vlr values(740432,2,165,14);
insert into vlr values(740433,2,171,14);
insert into vlr values(740437,2,164,14);
insert into vlr values(740439,2,164,14);
insert into vlr values(740440,2,164,14);
insert into vlr values(740441,2,164,14);
insert into vlr values(740442,2,165,14);
insert into vlr values(740444,2,164,14);
insert into vlr values(740445,2,164,14);