¼ÌÐøÉÏÒ»²¿·Ö£¬ÏÖÔÚÎÒÃǵÄʵµÄ¹¹ÔìÆ÷initializeºÜÍêÃÀÁË£¬ÉõÖÁÁ¬ÀàʽsuperÕâÑùÓï·¨ÌǶ¼²»ÓÃÁË£¬¾Í×Ô¶¯ÊµÀýÁ˸¸Àà¡£ÎÒÃÇת¶ø¿´Ò»¿´ÆäÊôÐÔÓë·½·¨µÄ¼Ì³Ð¡£Ðí¶àÀà¿â¶¼ÊÇÒ»¸öfor...inÑ»·ÔÙ¼ÓһЩÅж¨ÊµÏÖÔÐÍÊôÐÔ¿½±´£¬»ò¸ù¾ÝÕâЩÅж¨°ÑijЩÊôÐÔ¾¾³öÀ´¼Ó¹¤Ò»ÏÂÔٷŽøÈ¥¡£ÓÖÈ磬ÎÒÃÇÒª¶ÔArrayµÄÄ£°å½øÐÐÀ©Õ¹£¬×ö³ÉÒ»¸öÐÂÀàArray2£¬Ö±½Ó¼Ì³Ðºó£¬ÔÚÓÐЩä¯ÀÀÆ÷ÖÐArray2¿ÉÄÜÓÐforEach·½·¨£¬¿ÉÄÜûÓУ¬Èç¹ûûÓУ¬ÎÒÃDzÅÌí¼Ó×Ô¼ºÊµÏÖµÄforEach·½·¨¡£Òò´ËÌõ¼þ¹ýÂ˷dz£ÖØÒªµÄ¡£ÔÚmootoolsÖУ¬Éú³ÉÀà¶¼´øÓÐһЩÀà·½·¨£¨aliasÓëimplement£©£¬ÒÔ¹©¸ü½øÒ»²½µÄ¼Ó¹¤¡£
var copy = function(a,b,c){
var l = arguments.length;
if(a && b && l == 2){
for(var p in b)
a[p] = b[p];
}else if(a && b && l == 3 ){
a[b] = c;
}
return a;
};
ÉÏÃæµÄ·½·¨Ãû¸±Æäʵ£¬¾ÍÊÇÓÃÓÚµ¥´¿µÄ¸´ÖÆ¡£
var override = function(a,b,filter,scope){
var i, scope = scope || window;
for(i in b) {
if(filter.call(i,a,b))
a[i] = b[i];
}
};
override ΪÓÐÑ¡ÔñµØ¸´ÖÆ£¬Èç¹ûÎÒÃDz»Ï븲¸ ......
curryingº¯ÊýÊÇÒ»ÖÖ·µ»Øº¯ÊýµÄº¯Êý£¬ÊDZհü×îΰ´óµÄÓ¦ÓÃÖ®Ò»¡£Óйرհü¸üÏêϸµÄ¶¨Òå¿É²Î¼ûÕâÀïÓëÕâÀï¡£ÈçÏÂcurryingº¯ÊýµÄÒ»ÖÖ¶¨Òå¡£
×îÔçÆÚµÄcurryº¯ÊýÓеã¶à̬µÄÒâ棬¾ÍÊǸù¾Ýº¯Êý²ÎÊýÔÚÄÚ²¿Ñ¡Ó÷ÖÖ§£º
//http://www.openlaszlo.org/pipermail/laszlo-user/2005-March/000350.html
// ¡ï¡ïOn 8 Mar 2005, at 00:06, Steve Albin wrote:
function add(a, b) {
if (arguments.length < 1) {
return add;
} else if (arguments.length < 2) {
return function(c) { return a + c }
} else {
return a + b;
}
}
var myadd = add( 2 );
var total = myadd(3);
ÈÕ±¾µÄÒ»¸öÏÈÐÐÕß¿ÉÄÜÔÚδ¸ãÇåargumentsÒ²ÄÜÓÃArrayµÄÔÉú·½·¨×ª»»ÎªÊý×éµÄʱºò£¬Ó÷dz£¸´ÔÓµÄÕýÔòÓëeval¸ã³öÒ»¸ö¸ü½Ó½üÏÖ´úcurryingÒâζµÄº¯Êý¡£
function curry(fun) {
if (typeof fun != 'function') {
throw new Error("The argument must be a function.");
}
if (fun.arity == 0) {
throw new Error("The function must have more than o ......
ÎÊÌâ1£º ½øÈëʱÐèÒªÖ÷»úÉí·ÝÖ¤Ã÷£º ½â¾ö·½°¸£º¹ÜÀí¹¤¾ß——±¾µØ°²È«²ßÂÔ——Óû§È¨ÀûÖ¸ÅÉ——×÷ΪÅú´¦Àí×÷ÒµµÈ¼£¨×îºóÒ»Ï——Ìí¼Ó±¾»úµÄÕ˺ÅÓëÃÜÂë ......
BlobÊÇÖ¸¶þ½øÖÆ´ó¶ÔÏóÒ²¾ÍÊÇÓ¢ÎÄBinary Large ObjectµÄËùд£¬¶øClobÊÇÖ¸´ó×Ö·û¶ÔÏóÒ²¾ÍÊÇÓ¢ÎÄCharacter Large ObjectµÄËùд¡£Óɴ˿ɼûÕâÁ¾¸öÀàÐͶ¼ÊÇÓÃÀ´´æ´¢´óÁ¿Êý¾Ý¶øÉè¼ÆµÄ£¬ÆäÖÐBLOBÊÇÓÃÀ´´æ´¢´óÁ¿¶þ½øÖÆÊý¾ÝµÄ£»CLOBÓÃÀ´´æ´¢´óÁ¿Îı¾Êý¾Ý¡£
ÄÇôÓÐÈ˿϶¨ÒªÎʼÈÈ»ÒѾÓÐVARCHARºÍVARBINARYÁ½ÖÐÀàÐÍ£¬ÎªÊ²Ã´»¹ÒªÔÙʹÓÃÁíÍâµÄÁ½ÖÖÀàÐÍÄØ£¿ÆäʵÎÊÌâºÜ¼òµ¥£¬VARCHAR ºÍVARBINARYÁ½ÖÖÀàÐÍÊÇÓÐ×Ô¼ºµÄ¾ÖÏÞÐԵġ£Ê×ÏÈ˵ÕâÁ½ÖÖÀàÐ͵ij¤¶È»¹ÊÇÓÐÏ޵IJ»¿ÉÒÔ³¬¹ýÒ»¶¨µÄÏ޶ÒÔVARCHARÔÙORAÖÐΪÀý³¤¶È²»¿ÉÒÔ³¬¹ý4000£»ÄÇôÓÐÈËÓÖÒªÎÊÁË£¬LONGVARCHARÀàÐÍ×÷ΪÊý¾Ý¿âÖеÄÒ»ÖÖ´æ´¢×Ö·ûµÄÀàÐÍ¿ÉÒÔÂú×ãÒªÇ󣬴洢ºÜ³¤µÄ×Ö·û£¬ÄÇΪʲô·ÇÒª³öÏÖCLOBÀàÐÍÄØ£¿ÆäʵÈç¹ûÄãÓùýLONGVARCHARÀàÐ;Ͳ»ÄÑ·¢ÏÖ£¬¸ÃÀàÐ͵ÄÒ»¸öÖØÒªÈ±ÏݾÍÊDz»¿ÉÒÔʹÓÃLIKEÕâÑùµÄÌõ¼þ¼ìË÷¡££¨ÉÔºò½«½éÉÜÔÚCLOBÖÐÈçºÎʵÏÖÀàËÆLIKEµÄÄ£ºý²éÕÒ£©ÁíÍâ³ýÁËÉÏÊöµÄÎÊÌâÍ⣬»¹ÓÖÒ»¸öÎÊÌ⣬¾ÍÊÇÔÚÊý¾Ý¿âÖÐVARCHARºÍVARBINARYµÄ´æÈ¡Êǽ«È«²¿ÄÚÈÝ´ÓÈ«²¿¶ÁÈ¡»òдÈ룬¶ÔÓÚ100K»òÕß˵¸ü´óÊý¾ÝÀ´ËµÕâÑùµÄ¶Áд·½Ê½£¬Ô¶²»ÈçÓÃÁ÷½øÐжÁдÀ´µÃ¸üÏÖʵһЩ¡£
ÔÚJDBCÖÐÓÐÁ½¸ö½Ó¿Ú¶ÔÓ¦Êý¾Ý¿âÖеÄBLOBºÍCLOBÀàÐÍ£¬java.sql.BlobºÍjava.s ......
http://hi.baidu.com/fyears/blog/item/5ef68ac3feb9a45db219a836.html
select object_id,session_id,locked_mode from v$locked_object;
¡¡¡¡select t2.username,t2.sid,t2.serial#,t2.logon_time
¡¡¡¡from v$locked_object t1,v$session t2
¡¡¡¡where t1.session_id=t2.sid order by t2.logon_time;
alter system kill session 'sid,serial#';
¡¡¡¡ORACLEÀïËøÓÐÒÔϼ¸ÖÖģʽ:
¡¡¡¡0£ºnone
¡¡¡¡1£ºnull ¿Õ
¡¡¡¡2£ºRow-S Ðй²Ïí(RS)£º¹²Ïí±íËø
¡¡¡¡3£ºRow-X ÐÐרÓÃ(RX)£ºÓÃÓÚÐеÄÐÞ¸Ä
¡¡¡¡4£ºShare ¹²ÏíËø(S)£º×èÖ¹ÆäËûDML²Ù×÷
¡¡¡¡5£ºS/Row-X ¹²ÏíÐÐרÓÃ(SRX)£º×èÖ¹ÆäËûÊÂÎñ²Ù×÷
¡¡¡¡6£ºexclusive רÓÃ(X)£º¶ÀÁ¢·ÃÎÊʹÓÃ
¡¡¡¡Êý×ÖÔ½´óËø¼¶±ðÔ½¸ß, Ó°ÏìµÄ²Ù×÷Ô½¶à¡£
¡¡¡¡Ò»°ãµÄ²éѯÓï¾äÈçselect ... from ... ;ÊÇСÓÚ2µÄËø, ÓÐʱ»áÔÚv$locked_object³öÏÖ¡£
¡¡¡¡select ... from ... for update; ÊÇ2µÄËø¡£
¡¡¡¡µ±¶Ô»°Ê¹ÓÃfor update×Ó´®´ò¿ªÒ»¸öÓαêʱ£¬
¡¡¡¡ËùÓзµ»Ø¼¯ÖеÄÊý¾ÝÐж¼½«´¦ÓÚÐм¶(Row-X)¶ÀÕ¼Ê½Ëø¶¨£¬
¡¡¡¡ÆäËû¶ÔÏóÖ»ÄܲéѯÕâЩÊý¾ÝÐУ¬²»ÄܽøÐÐupdate¡¢delete»òselect...for update²Ù×÷¡£
¡¡¡¡insert / update / delete ... ; ÊÇ3µÄËø¡£
¡¡ ......
oracle±äÁ¿ÀàÐÍ
±êÁ¿ÀàÐÍ
varchar2(n) ÓÃÓÚ¶¨Òå¿É±ä³¤¶ÈµÄ×Ö·û´® nÓÃÓÚÖ¸¶¨×Ö·û´®µÄ×î´ó³¤¶È Æä×î´óֵΪ32767×Ö½Ú ±ØÐëÖ¸¶¨n
char(n) ÓÃÓÚ¶¨Òå¹Ì¶¨³¤¶ÈµÄ×Ö·û´® ÆäÖÐnÓÃÓÚÖ¸¶¨×Ö·û´®µÄ×î´ó³¤¶È£¬Æä×î´óֵΪ32767 Èç¹û²»Ö¸¶¨n ĬÈÏÊÇ1
number(p,s)¸ÃÊý¾ÝÀàÐÍÓÃÓÚ¶¨Òå¹Ì¶¨³¤¶ÈµÄÕûÊýºÍ¸¡µãÊý,ÆäÖÐp±íʾ¾«¶È,ÓÃÓÚÖ¸¶¨Êý×ÖµÄ×ÜλÊý£¬s±íʾ±ê¶È£¬ÓÃÓÚÖ¸¶¨Ð¡ÊýµãºóµÄÊý×ÖλÊýÈçnumber(6,2)×î´óÊÇ4λ
DATE ¸ÃÊý¾ÝÀàÐÍÓÃÓÚ¶¨ÒåÈÕÆÚºÍʱ¼äÊý¾Ý£¬ÆäÊý¾Ý³¤¶ÈΪ¹Ì¶¨³¤¶È£¨7×Ö½Ú£©¡£¸ødate±äÁ¿¸³ÖµÊ±¡£Êý¾Ý±ØÐëÒªÓëÈÕÆÚ¸ñʽºÍÈÕÆÚÓïÑÔÆ¥Åä
TIMESTAMP ¸ÃÊý¾ÝÀàÐÍÊÇ9iÐÂÔö¼ÓµÄÊý¾ÝÀàÐÍ£¬ËüÓÃÓÚ¶¨ÒåÈÕÆÚºÍʱ¼äÊý¾Ý Óëdate²»Í¬ÔÚÓÚ²»½ö»áÏÔʾÈÕÆÚ£¬¶øÇÒ»¹»áÏÔʾʱ¼äºÍÉÏÏÂÎç±ê¼Ç
LONGºÍLONG RAW LONGÊý¾ÝÀàÐÍÓùÓö¨Òå±ä³¤×Ö·û´®£¬ÀàËÆÓÚvarchar2Êý¾ÝÀàÐÍ£¬µ«Æä×Ö·û´®µÄ×î´ó³¤¶ÈΪ32760£»LONG RAWÊý¾ÝÀàÐÍÓÃÓÚ¶¨Òå¶þ½øÖÆÊý¾Ý
BOOLEAN ¸ÃÊý¾ÝÀàÐÍÓÃÓÚ¶¨Òå²¼¶û±äÁ¿£¬Æä±äÁ¿µÄֵΪtrue£¬false»ònull£¬¸ÃÊý¾ÝÀàÐÍÊÇpl/sqlÊý¾ÝÀàÐÍ£¬±íÁв»ÄܲÉÓøÃÊý¾ÝÀàÐÍ
BINARY_INTEGER ÓÃÓÚ¶¨ÒåÕûÊý ÊýÖµ·¶Î§ÔÚ-214748367ºÍ2147483647Ö®¼ä ¸ÃÊý¾ÝÀàÐÍÊÇpl/sq ......