Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

weblogicÏÂÔÚOracleÖд洢clobÀàÐÍÒ»Àý

String sql = "select t.FILE_INFO from T_FILE_DB_DETAIL t where t.id= "
      + fileDBUpDownDetail.getId() + " for update";
    rs = stmt.executeQuery(sql);
    if (rs.next()) {
     // ÔÚweblogicϲ¿Êðʱ£¬ÐèÒª¸ü¸ÄΪBea WebLogic BLOB¸ñʽ
//     weblogic.jdbc.vendor.oracle.OracleThinBlob blob = (weblogic.jdbc.vendor.oracle.OracleThinBlob) rs
//       .getBlob(1);
     BLOB blob = (BLOB) rs.getBlob(1);
     if (blob != null) {
      out = blob.getBinaryOutputStream();
      byte[] buf = new byte[8192];// 8K »º´æ
      int len;
      while ((len = fileInputStream.read(buf)) > 0) {
       if (out != null) {
        out.write(buf, 0, len);
        out.flush();
       }
      }
     }
    }


Ïà¹ØÎĵµ£º

ORACLE ÁÙʱ±í¿Õ¼äʹÓÃÂʹý¸ßµÄÔ­Òò¼°½â¾ö·½°¸

ORACLE ÁÙʱ±í¿Õ¼äʹÓÃÂʹý¸ßµÄÔ­Òò¼°½â¾ö·½°¸(2009-11-14 19:59:02)
±êÇ©£ºoracle ÁÙʱ±í¿Õ¼ä ʹÓÃÂÊ100 ½â¾ö·½°¸ it
·ÖÀࣺ¼¼Êõ²©ÂÛ
ÔÚÊý¾Ý¿âµÄÈÕ³£Ñ§Ï°ÖУ¬·¢ÏÖ¹«Ë¾Éú²úÊý¾Ý¿âµÄĬÈÏÁÙʱ±í¿Õ¼ätempʹÓÃÇé¿ö´ïµ½ÁË30G£¬Ê¹ÓÃÂÊ´ïµ½ÁË100%£» ´ýµ÷ÕûΪ32Gºó£¬Ê¹ÓÃÂÊ»¹ÊÇΪ100%£¬µ¼Ö´ÅÅ̿ռäʹÓýôÕÅ¡£¸ù¾ÝÁÙʱ±í¿Õ¼äµÄÖ÷ ......

oracle job½â¾öÎÊÌâ»ã×Ü

Ò»¡£jobµÄÔËÐÐÆµÂÊÉèÖÃ
1.ÿÌì¹Ì¶¨Ê±¼äÔËÐУ¬±ÈÈçÔçÉÏ8:10·ÖÖÓ£ºTrunc(Sysdate+1) + (8*60+10)/24*60
2.ToadÖÐÌṩµÄ£º
ÿÌ죺trunc(sysdate+1)
ÿÖÜ£ºtrunc(sysdate+7)
ÿÔ£ºtrunc(sysdate+30)
ÿ¸öÐÇÆÚÈÕ£ºnext_day(trunc(sysdate),'SUNDAY')
ÿÌì6µã£ºtrunc(sysdate+1)+6/24
°ë¸öСʱ£ºsysdate+30/1440
3.ÿ¸ö ......

OracleͬÒå´Ê£¬¸øÄã´øÀ´µÄ¼¸¸ö¾ªÏ²

OracleÊý¾Ý¿âÖÐÌṩÁËͬÒå´Ê¹ÜÀíµÄ¹¦ÄÜ¡£Í¬Òå´ÊÊÇÊý¾Ý¿â·½°¸¶ÔÏóµÄÒ»¸ö±ðÃû£¬¾­³£ÓÃÓÚ¼ò»¯¶ÔÏó·ÃÎʺÍÌá¸ß¶ÔÏó·ÃÎʵݲȫÐÔ¡£ÔÚʹÓÃͬÒå´Êʱ£¬OracleÊý¾Ý¿â½«Ëü·­Òë³É¶ÔÓ¦·½°¸¶ÔÏóµÄÃû×Ö¡£ÓëÊÓͼÀàËÆ£¬Í¬Òå´Ê²¢²»Õ¼ÓÃʵ¼Ê´æ´¢¿Õ¼ä£¬Ö»ÓÐÔÚÊý¾Ý×ÖµäÖб£´æÁËͬÒå´ÊµÄ¶¨Òå¡£ÔÚOracleÊý¾Ý¿âÖеĴ󲿷ÖÊý¾Ý¿â¶ÔÏó£¬Èç±í¡¢ÊÓͼ¡¢Í ......

´´½¨oracleÊý¾Ý¿âÁ¬½Ó(database link)µÄÁ½ÖÖ·½·¨


oracle Êý¾Ý¿âÁ¬½Ó¾ÍÏñÄãÔÚ³ÌÐòÖн¨Á¢Ò»¸öµ½Êý¾Ý¿âµÄÁ¬½ÓÒ»Ñù¡£
Èç¹ûÊý¾Ý¿â²»ÔÚ±¾µØÖ÷»ú,±ØÐëÔÚ$ORACLE_HOME/network/admin/tnsnames.oraÖÐÅäÖÃÏàÓ¦µÄtns£¬È»ºó³ÌÐò²ÅÄÜͨ¹ýÅäÖúõÄtns·ÃÎÊÊý¾Ý¿â£¬µ«ÊÇjavaͨ¹ýthin·½Ê½·ÃÎÊoracleÀýÍ⣬¿ÉÒÔ²ÉÓÃÔÚ±¾µØÅäÖúõÄtns±ðÃû£¬Ò²¿ÉÒÔ²ÉÓÃtnsÈ«½âÎöÃû£¬²ÉÓñðÃûµÈºÅºóµÄÈ« ......

oracle olapº¯Êý£¨Ðø£©

/*connect byº¯Êý*/
CREATE TABLE TBL_TEST
(
  ID    NUMBER,
  NAME  VARCHAR2(100 BYTE),
  PID   NUMBER                          ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ