Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ :

[´ÓjQuery¿´JavaScript]

jQueryƬ¶Î£º
var
// Will speed up references to window, and allows munging its name.
window = this,
// Will speed up references to undefined, and allows munging its name.
undefined,
// Map over jQuery in case of overwrite
_jQuery = window.jQuery,
// Map over the $ in case of overwrite
_$ = window.$,
jQuery = window.jQuery = window.$ = function( selector, context ) {
// The jQuery object is actually just the init constructor 'enhanced'
return new jQuery.fn.init( selector, context );
},
// A simple way to check for HTML strings or ID strings
// (both of which we optimize for)
quickExpr = /^[^<]*(<(.|\s)+>)[^>]*$|^#([\w-]+)$/,
// Is it a simple selector
isSimple = /^.[^:#\[\.,]*$/;
 ¡¡¡¡ÔÚÕâÒ»½Ú£¬ÎÒÃǽ«ÌÖÂÛͬһ¶ÎjQueryƬ¶ÎµÄÁíÒ»¸ö֪ʶµã£ºÄÚÖÃÊý¾ÝÀàÐͺÍÄÚÖöÔÏó¡£ÎªÁËÈÃÎÒÃǸüºÃµØÀí½â´úÂ룬ÎÒÃDZØÐë¶ÔÕâÒ»²¿·ÖÄÚÈÝÉîÈëÁ˽⡣ûÓÐÀι̵Ļù´¡£¬ÊDz»¿ÉÄܹ¹ÖþÆð¼áʵµÄ±¤Àݵġ£
ÄÚÖÃÊý¾ÝÀàÐÍ
¡¡¡¡ÄÚÖÃÊý¾ÝÀàÐÍ£¬Ò²³Æ×÷¹ÌÓÐÊý¾ÝÀàÐÍ£¬Ò²¾ÍÊÇJSµÄ»ù±¾µÄÊý ......

Javascript²Ù×÷ÏÂÀ­¿òµÄ³£Ó÷½·¨

 function AddDropDownList(id,fatherCtl)
{
    if(!document.getElementById(id))
    {
        var ddl = document.createElement('select');
        ddl.setAttribute("id",id);   
        if(fatherCtl&&document.getElementById(fatherCtl))
            document.getElementById(fatherCtl).appendChild(ddl);
        else
            document.body.appendChild(ddl);
     }
}
//ɾ³ýÖ¸¶¨µÄÏÂÀ­¿ò
function RemoveDropDownList(id)
{
      var ctl = document.getElementById(id);
      if(ctl)
     &nbs ......

×ß½üOracleÊý¾Ý×Öµä

×÷Õß: ÈýÊ®¶øÁ¢Ê±¼ä£º2009Äê11ÔÂ08ÈÕ 8:59:25Çë×ðÖØÔ­´´×÷Æ·¡£×ªÔØÇë±£³ÖÎÄÕÂÍêÕûÐÔ,²¢ÒÔ³¬Á´½ÓÐÎʽעÃ÷ԭʼ×÷Õß¡°inthirties£¨ÈýÊ®¶øÁ¢£©¡±ºÍ³ö´¦¡±http://blog.csdn.net/inthirties/archive/2009/11/08/4785106.aspx¡±,ÉîÈëÌÖÂÛ¿ÉÒÔÁªÏµinthirties@gmail.com¡£ Êý¾Ý×ֵ䣬µÚÒ»´ÎÌýµ½Õâ¸ö´ÊµÄʱºò£¬»¹ÊǸոÕ̤½øITÐÐÒµ£¬¼ÆËã»úµÄ֪ʶÊÇ×Ô¼ºÒµÓàѧµÄ£¬ËùÒÔ¶ÔÕâÑùµÄרÓÐÃû³Æ²¢²»Á˽⣬²»³ÜÏÂÎʵÄÎÊÒ»¸öÀÏÄñ£¬¸æÖªÊÇÎÒÃÇд³ÌÐòʱ£¬±ÈÈç״̬£¬µØ·½Âë£¬ÇøÂëµÈһЩ»ù´¡ÐÅÏ¢£¬Ò²½Ð×öcode table¡£ Ŷ¡£ Ô­À´ÊÇÕâô»ØÊ¡£ÓÐÁËÕâ¸ö¾­Àú£¬ÔÙÒ»´ÎÔÚ̸¼°Êý¾Ý¿âʱÌýµ½Êý¾Ý¿âÀïÒ²ÓÐÊý¾Ý×ÖµäµÄʱºò£¬¾ÍûÓÐÄÇô¶àµÄİÉúÁË£¬ÐÄÀïÖªµÀ£¬¶ÔÓÚÊý¾Ý¿âÈí¼þÀ´Ëµ£¬Ëû±¾ÉíÒ²ÊǺÍÎÒÃÇдµÄ³ÌÐòÒ»Ñù£¬Ò²ÊÇÒ»Ó¦Óã¬ÄÇôÀïÃæµÄÊý¾Ý×Öµä¾ÍÊÇ Êý¾Ý¿âÓ¦ÓÃÐèÒªµÄһЩ»ù´¡ÐÅϢ߷¡£ 

µÄÈ·£¬Êý¾Ý¿âÊÇÊý¾ÝµÄ¼¯ºÏ£¬Êý¾Ý¿âά»¤ºÍ¹ÜÀíÕâÓû§µÄÊý¾Ý£¬ÄÇôÕâЩÓû§Êý¾Ý±í¶¼´æÔÚÄÄÀÓû§µÄÐÅÏ¢ÊÇÔõÑùµÄ£¬´æ´¢ÕâЩÓû§µÄÊý¾ÝµÄ·¾¶ÔÚÄÄÀÕâЩÐÅÏ¢²»ÊôÓÚÓû§µÄÐÅÏ¢£¬È´ÊÇÊý¾Ý¿âά»¤ºÍ¹ÜÀíÓû§Êý¾ÝµÄºËÐÄ£¬ÕâЩÐÅÏ¢¾ÍÊÇÊý¾Ý¿âµÄÊý¾Ý×ÖµäÀ´Î¬»¤µÄ£¬Êý¾Ý¿âµÄÊý¾Ý×Öµä¾Í»ã¼¯ÁËÕâЩÊý¾Ý¿âÔËÐÐËùÐèÒªµÄ»ù´¡ÐÅϢ߷¡ ......

OracleÖеÄÈÕÆÚºÍ×Ö·û´®»¥Ïàת»»

 OracleÖеÄÈÕÆÚºÍ×Ö·û´®»¥Ïàת»»
TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02   13:45:25ΪÀý)
  
        Year:     
        yy two digits Á½Î»Äê                ÏÔʾֵ:07
        yyy three digits ÈýλÄê                ÏÔʾֵ:007
        yyyy four digits ËÄλÄê                ÏÔʾֵ:2007
           
        Month:     
        mm    number     Á½Î»Ô         &nb ......

ORACLEÖеĴ¥·¢Æ÷ºÍÓαêÊÇÔÚÄÚ´æÖÐÂð£¿

×÷Õß: ÈýÊ®¶øÁ¢Ê±¼ä£º2009Äê11ÔÂ08ÈÕ 12:15:21Çë×ðÖØÔ­´´×÷Æ·¡£×ªÔØÇë±£³ÖÎÄÕÂÍêÕûÐÔ,²¢ÒÔ³¬Á´½ÓÐÎʽעÃ÷ԭʼ×÷Õß¡°inthirties£¨ÈýÊ®¶øÁ¢£©¡±ºÍ³ö´¦¡±http://blog.csdn.net/inthirties/archive/2009/11/08/4786769.aspx¡±,ÉîÈëÌÖÂÛ¿ÉÒÔÁªÏµinthirties@gmail.com¡£ÔÚcsdnÉÏ¿´µ½Ò»¸öÍøÓÑÎʵÄÒ»¸öÎÊÌâ http://topic.csdn.net/u/20091102/20/35713B33-EACB-4A74-8735-251B9AAD156A.html ORACLEÖд¥·¢Æ÷ºÍÓαêÖ´ÐÐÊÇÔÚÄÚ´æÖÐÂ𣬠 ÊDz»ÊÇͦºÄ×ÊÔ´£¬Ó¦¾¡Á¿ÉÙÓã¿ ºÇºÇºÇ£¬ÕâÑùµÄÎÊÌâһϾͰÑÈËÎÊãÂÁË£¬Ò»Ê±Ò²²»ÖªµÀ´ÓÄÄÀ↑ʼ»Ø´ð£¬ÎÊÌâµ¹²»ÊǺܸ´ÔÓ£¬Ö»²»¹ý±ÊÕßµÄÎÊÌâ°Ñ²»Í¬µÄ¸ÅÄîÔÓºÍÔÚÒ»Æð£¬ËùÒÔһʱҲ²»ÖªµÀ´ÓÄÄÀ↑ʼ»Ø´ðÁË¡£ ÎÒÃÇÀ´¿´¿´²¿·Ö´ð°¸ ʵÀýÊÇÔÚÄÚ´æÖÐÔËÐеģ¬Á½ÕßÒ²ÊÇÔÚÄÚ´æÖÐÖ´ÐР
×¢ÒâЧÂʾͺã¬Èç¹ûÐèÒª£¬»¹ÊÇÒªÓô¥·¢Æ÷ºÍÓαêµÄ 
Óαê´ò¿ª²¢Ê¹ÓÃÍêºó¼ÇµÃclose ´¥·¢Æ÷ºÍÓαêÊÇÁ½¸ö¸ÅÄî¡£ 

´¥·¢Æ÷ÊÇÊý¾Ý¿âÀïµÄÒ»Àà¶ÔÏ󣬺ÍfunctionÒÔ¼°procedureÒ»Ñù£¬ÊÇÒ»¸öPLSQL´úÂë¶Ë£¬±àÒëÒÔºó´æÔÚʵÀýÖУ¬¶øÓαêÊÇÔËÐйý³ÌÖеÄÒ»¸ö½á¹û¼¯µÄÖ¸Õ룬trigger¿ÉÒÔ¿´×öÊÇÄÚ´æÖеľ²Ì¬µØÖ·£¬¶øcursorÊÇÄÚ´æÖеĶ¯Ì¬²¿·Ö£¬ ÕâÁ½¸öÔÚÕâ·½ ......

110¸öoracle³£Óú¯Êý×ܽá(3)

 41.SYSDATE
    ÓÃÀ´µÃµ½ÏµÍ³µÄµ±Ç°ÈÕÆÚ
    SQL> select to_char(sysdate,dd-mm-yyyy day) from dual;
    TO_CHAR(SYSDATE,
  -----------------
    09-05-2004ÐÇÆÚÈÕ
    trunc(date,fmt)°´ÕÕ¸ø³öµÄÒªÇó½«ÈÕÆÚ½Ø¶Ï,Èç¹ûfmt=mi±íʾ±£Áô·Ö,½Ø¶ÏÃëSQL> select to_char(trunc(sysdate,hh),yyyy.mm.dd hh24:mi:ss) hh, 2 to_char(trunc(sysdate,mi),yyyy.mm.dd hh24:mi:ss) hhmm from dual;
    HH HHMM
  ------------------- -------------------
    2004.05.09 11:00:00 2004.05.09 11:17:00
    42.CHARTOROWID
    ½«×Ö·ûÊý¾ÝÀàÐÍת»»ÎªROWIDÀàÐÍ
    SQL> select rowid,rowidtochar(rowid),ename from scott.emp;
    ROWID ROWIDTOCHAR(ROWID) ENAME
  ------------------ ------------------ ----------
    AAAAfKAACAAAAEqAAA AAAAfKAACAAAAEqAAA SMITH
    AAAAfKAACAAAAEqAAB AAAAfKAACAAAAEqAAB ALLEN ......
×ܼǼÊý:40319; ×ÜÒ³Êý:6720; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [5613] [5614] [5615] [5616] 5617 [5618] [5619] [5620] [5621] [5622]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ