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

Oracleʱ¼ä¾«È·µ½Ê±¡¢·Ö¡¢Ãë´¦Àí·½·¨

Ò»°ãÊý¾Ý¿âÖÐʱ¼äµÄ¸ñʽΪDATEÀàÐÍ£¬¶øÎÒÃÇ´ÓÒ³ÃæÖлñÈ¡µÄʱ¼äÍùÍùΪStringÀàÐÍ£¬Õâ¸ö¾ÍÐèÒªÀàÐ͵Äת»»¡£Ò»°ãÎÒÃÇ»áͨ¹ýµ÷Óà Java.text.SimpleDateFormat JAVAÀàÀ´¶ÔÆä½øÐÐת»»¡£Õâ¸öJAVAÀàÖÐÎÒÃǾ­³£Óõ½µÄ·½·¨ÓÐÁ½¸ö£¬Ò»¸öÊÇformat(½«Ê±¼ä¸ñʽµÄÊý¾Ýת»»³ÉStringÀàÐÍ)£¬ÁíÒ»¸ö¾ÍÊÇ parse(½«StringÀàÐÍת»»³ÉDATEÀàÐÍ)¡£ÎÒÃÇÒ»°ã¿ÉÒÔ½«parse·â×°µ½×Ô¼ºµÄ·½·¨ÖУ¬Àý:
  /**
   * ·½·¨ÃèÊö£ºÒ³ÃæÖÐ×Ö·û´®×ª»¯ÎªÈÕÆÚÀàÐÍ
   *
   * ÊäÈë²ÎÊý£º´ÓÒ³ÃæÖеõ½µÄÒÔ×Ö·û´®ÐÎʽ±íʾµÄÈÕÆÚÊý¾Ý
   * Êä³ö²ÎÊý£º×ª»»ºóµÄÈÕÆÚ
  */
 Public class TimeExh{
  public static Date transToDate(String strDatefromPage) {
    Date date = null;
    //´Ë´¦Îªyyyy-MM-dd ÔòΪ2005-1-13
    SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
   
    //½¨Á¢Ò»¸öÒ»¶¨¸ñʽµÄ SimpleDateFormat
    if(strDatefromPage==null) {
      return new Date();
    }
    if (strDatefromPage.length()>10) {
       sdf =  new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
       //´Ë´¦Ê±¼ä·½Ê½Îª2005-1-13 20:00:12
    }
    try {
      date = sdf.parse(strDatefromPage);
    } catch (Exception ex) {
      ex.printStackTrace();
    }
    return  date;
  }
 }
¡¡¡¡ÔÚOracleÊý¾Ý¿âÖÐÌṩÁËto_dateµÄ·½·¨À´¶ÔStringÀàÐ͵Äʱ¼äÀ´½øÐÐת»»¡£¶øÔÚOracleÊý¾Ý¿âÖв»Äܽ«Ê±¼äÖ±½Ó·Åµ½VOÖд«¸øÊý¾Ý¿â£¬ÕâÑùÊý¾Ý¿âÖеÄʱ¼äΪ¸ñÁÖÊÏʱ¼ä£¬²»·ûºÏÖйúÈ˵Äʱ¼äÏ°¹ß¡£ËùÒÔÔÚÕâÀïÓÐÁ½Öв»Í¬µÄ´¦Àí·½Ê½½øÐд¦Àí¡£
¡¡¡¡µÚÒ»ÖÖ£ºVOÖд洢ʱ¼äµÄÀàÐÍΪStringÀàÐÍ¡£
¡¡¡¡ÎÒÔÚÕâÀïдһ¸ö¼òµ¥µÄVOΪ£º
 public class DateVO {
   ..........//Ê¡ÂÔµô¶¨Ò岿·Ö
  public void setStart_Date(String Start_Date){
    start_Date= start_Date
  }


Ïà¹ØÎĵµ£º

oracle R12¹ËÎÊÈÏÖ¤

²©ÑåÅàѵ²¿ÊÇÄ¿Ç°¹úÄÚΨһµÄ Oracle ¹Ù·½ÊÚȨ ERP ÈÏÖ¤Åàѵ»ú¹¹
    Ä¿Ç°£¬Oracle Ó¦ÓÃϵͳÔÚÈ«Çò¿ç¹ú¹«Ë¾µÃµ½¹ã·ºÓ¦Óã¬ÖîÈçÖйúÒƶ¯¡¢ÉîÛÚ»ªÎª¡¢»ôÄáΤ¶û¡¢¿µÃ÷˹Öйú¡¢ÃÀ¹úÂÁÒµ¡¢DHL ºÍ±¦ÐÅÈí¼þµÈÖªÃû¹«Ë¾¡£Îª´Ë£¬Oracle ×Éѯ¹ËÎÊÊÇÈ«ÇòºÍÖйúÊг¡ÉÏ×î½ôȱµÄÈ˲ÅÖ®Ò»¡£Í¨¹ýOracle ÉÌÎñÌ×¼þÈÏÖ¤µÄ×Éѯ¹ËÎ ......

½ÌÄãÈçºÎÓÃOMSʵÏÖOracleÖÐÊý¾Ý±¸·Ý

ÔÚOracle 9iÖпÉÒÔ·½±ãµÄ°ÑÊý¾Ýµ¼³öΪÎļþ£¬»òÕß´ÓÎļþµ¼È롣ͨ¹ýOracleµÄÖÎÀí·þÎñÆ÷£¨Oracle Management Server£¬OMS£©¿ÉÒÔ·½±ãµÄʵÏÖ£¬Õû¸ö²Ù×÷¹ý³ÌÖÐÓкܶàµØ·½ÐèÒª½âÊÍ˵Ã÷£¬µ«ÊÇÍêÕûµÄÖ¸µ¼×ÊÁϲ»¶à¡£¸÷´óÂÛ̳ÉϺܶàËùνµÄ¸ßÊÖ£¬¶Ô¸ÃÖ÷ÌâµÄ»Ø´ðÍùÍùÊÇ£¬¸ßÊÖÊDz»ÓÃOMSµÄ£¬ÓÃeXP/impl°É¡£¼ÙÈçÄãÖ´Òâ×·ÎÊ£¬Ëû¶à°ë»á¸æËßÄ㣠......

OracleÖÐconnect by...start with...µÄʹÓÃ

Ò»¡¢Óï·¨
´óÖÂд·¨£ºselect * from some_table [where Ìõ¼þ1] connect by [Ìõ¼þ2] start with [Ìõ¼þ3];
ÆäÖÐ connect by Óë start with Óï¾ä°Ú·ÅµÄÏȺó˳Ðò²»Ó°Ïì²éѯµÄ½á¹û£¬[where Ìõ¼þ1]¿ÉÒÔ²»ÐèÒª¡£
[where Ìõ¼þ1]¡¢[Ìõ¼þ2]¡¢[Ìõ¼þ3]¸÷×Ô×÷Óõķ¶Î§¶¼²»Ïàͬ£º
[where Ìõ¼þ1]ÊÇÔÚ¸ù¾Ý“connect by [Ìõ¼þ2] ......

Oracle RACÈëÃÅ


=================================================================================
Oracle RAC ²úÆ·¸ÅÊö
Oracle Real Application Server£¬ÕæÕýÓ¦Óü¯Èº£¬¼ò³ÆOracle RAC £¬ÊÇOracleµÄ²¢Ðм¯Èº£¬Î»ÓÚ²»Í¬·þÎñÆ÷ϵͳµÄOracleʵÀýͬʱ·ÃÎÊͬһ¸öOracleÊý¾Ý¿â£¬½ÚµãÖ®¼äͨ¹ý˽ÓÐÍøÂç½øÐÐͨÐÅ£¬ËùÓеĿØÖÆÎļþ¡¢Áª»úÈÕÖ ......

OracleÊý¾Ýµ¼Èëµ¼³öimp/expÃüÁî

OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹Ô­Ó뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
 
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´Ð ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ