Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ÉÌÎñÌ×¼þÈÏÖ¤µÄ×Éѯ¹ËÎ ......

OracleÆô¶¯¹ý³ÌÏê½â ½éÉܼ°ÃüÁ»¹ÓйرÕ

OracleÆô¶¯¹ý³Ì½éÉܼ°ÃüÁ»¹Óйرա£
дÔÚÇ°Ã棺Æô¶¯Êý¾Ý¿âÇ°£¬ÇëÏÈÆô¶¯¼à³ÌÐò¡£
lsnrctl start
Æô¶¯µÄÈý¸ö²½Ö裬ÒÀ´ÎΪ1.´´½¨²¢Æô¶¯ÊµÀý¡¢2.×°ÔØÊý¾Ý¿â¡¢3.´ò¿ªÊý¾Ý¿â¡£
¿ÉÒÔͨ¹ýÃüÁîstartupÀ´ÊµÏÖ¡£
startup ÃüÁî¸ñʽ
startup [ nomount | mount | open | force ] [ restrict ] [ pfile=filename ];
·½·¨1 -- st ......

ÕâƪÎÄÕ²ûÊöÁËÈçºÎ¹ÜÀíoracle ERPµÄinterface±í


ÕâƪÎÄÕ²ûÊöÁËÈçºÎ¹ÜÀíoracle ERPµÄinterface±í
ÕâƪÎÄÕ²ûÊöÁËÈçºÎ¹ÜÀíoracle ERPµÄinterface±í
http://blog.oraclecontractors.com/?p=212
There are a number of tables used by Oracle Applications that should have no rows in them when all is running well, and if any, only a few rows that are in error. ......

ORACLEÈÕÆÚʱ¼äº¯Êý´óÈ«

ORACLEÈÕÆÚʱ¼äº¯Êý´óÈ«
   TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02   13:45:25ΪÀý)
  
        Year:     
        yy two digits Á½Î»Äê       &nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ