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

oracleµ÷ÓÃjava

create or replace and compile java source named md5util as
import java.security.MessageDigest;
public class MD5Util
{
  public static String encrypt(String s)
  {
       char hexDigits[] = {'0', '1', '2', '3', '4', '5', '6', '7', '8', '9', 'a', 'b', 'c', 'd','e', 'f'};
       
        try {
                byte[] strTemp = s.getBytes();
                MessageDigest mdTemp = MessageDigest.getInstance("MD5");
                mdTemp.update(strTemp);
                byte[] md = mdTemp.digest();
               
                int j = md.length;
                char str[] = new char[j * 2];
                int k = 0;
                for (int i = 0; i < j; i++) {
                    byte byte0 = md[i];
                 str[k++] = hexDigits[byte0 >>> 4 & 0xf];
                 str[k++] = hexDigits[byte0 & 0xf];
               


Ïà¹ØÎĵµ£º

oracle×Ô¶¯±¸·ÝµÄÒ»¸öÅú´¦Àí


if %time:~,2% leq 9  (set hh=0%time:~1,1%) else  (set hh=%time:~,2%)
exp wzolerp/wzolerp@wzol file=E:\Êý¾Ý¿â±¸·Ý\wzolerp%date:~0,10%ÈÕ%hh%ʱ%time:~3,2%·Ö.dmp log=E:\Êý¾Ý¿â±¸·Ý\wzolerp%date:~0,10%ÈÕ%hh%ʱ%time:~3,2%·Ö.log
exp wzolwms/wzolwms@wzol file=E:\Êý¾Ý¿â±¸·Ý\wzolwms%date:~0,10%ÈÕ ......

Oracle¶àÐмǼºÏ²¢/Á¬½Ó/¾ÛºÏ×Ö·û´®µÄ¼¸ÖÖ·½·¨

ʲôÊǺϲ¢¶àÐÐ×Ö·û´®£¨Á¬½Ó×Ö·û´®£©ÄØ£¬ÀýÈ磺
SQL> desc test;
Name     Type          Nullable Default Comments
------- ------------ -------- ------- --------
COUNTRY VARCHAR2(20) Y       &nb ......

oracle Ö÷¼ü \Ë÷Òý


ÔÚoracleÖУ¬ÎÒÃÇ´´½¨Ò»¸öÖ÷¼ü£¬Ôòͬʱ×Ô¶¯´´½¨ÁËÒ»¸öͬÃûµÄΨһË÷Òý£»É¾³ýÖ÷¼ü£¬ÔòÖ÷¼üÔ¼ÊøºÍ¶ÔÓ¦µÄΨһË÷Òý¶¼É¾³ýÁË¡£ÕâÊÇÎÒÃǾ­³£¼ûµ½µÄÏÖÏó¡£
 
·¢³öÒ»¸ö´´½¨Ö÷¼üµÄsql£¬oracleÆäʵִÐÐÁËÁ½²½£º´´½¨Ö÷¼üÔ¼Êø¡¢´´½¨/¹ØÁª ΨһË÷Òý¡£²½ÖèÊÇÕâÑùµÄ£º
´´½¨Ö÷¼üÔ¼ÊøÊ±£¬¼ì²é¸ÃÖ÷¼ü×Ö¶ÎÉÏÊÇ·ñÒѾ­´æÔÚΨһË÷Òý¡£Èô² ......

Oracle¹éµµ¹ÜÀí

     Oracle°ÑÌîÂúµÄÁª»úÈÕÖ¾Îļþ¸´ÖƵ½Ò»¸ö»òÕß¶à¸ö·¾¶£¬Õâ¸ö¹ý³Ì½Ð¹éµµ£¬ÕâÑùÉú³ÉµÄÎļþ½Ð¹éµµÈÕÖ¾Îļþ£¬´æ·ÅÈÕÖ¾ÎļþµÄ·¾¶½Ð¹éµµÂ·¾¶£¨¹éµµÄ¿Â¼£©¡£Ò»¸öÊý¾Ý¿â¿ÉÒÔÓжà¸ö¹éµµ½ø³Ì£¬Óɳõʼ»¯²ÎÊýLOG_ARCHIVE_MAX_PROCESSES)¿ØÖÆ¡£¹éµµÊDZ¸·ÝºÍ»Ö¸´µÄ»ùʯ¡£ÔÚOracleÖУ¬¼¸ºõËùÓеı¸·ÝºÍ»Ö¸´¶¼ÊÇÒѹ ......

ÔÚOracleÖм¯³Éjava³ÌÐòµÄ¾­Ñé̸֮£¡

Õâ¶Îʱ¼äΪ¹«Ë¾ÄÚ²¿µÄÊý¾Ý´¦Àí¿ª·¢ÁËÒ»¸ö¹¤¾ß£¬Ç£Éæµ½ÔÚOracleÖм¯³ÉjavaÓ¦Óã¬×ܽáÁËһЩ¾­Ñ飬ÒÔ¹©´ó¼Ò²Î¿¼ÁË£¡
³ÌÐò·ÖÁ½²¿·Ö£¬Ç°¶Ë½çÃæÓÉVB/VC¿ª·¢£¬Ö÷ҪʵÏÖÊý¾Ý´¦ÀíÅäÖü°³£¹æ¼Ç¼ÔËË㣬Õⲿ·ÖûÓÐʲôºÃ˵µÄÁË¡£
ºǫ́ÒÔOracleΪÊý¾Ý»ù´¡´¦ÀíÍÐ¹ÜÆ½Ì¨£¬ÔÚÊý¾Ý´¦Àí¹ý³ÌÖУ¬ÐèÒª¶ÔһЩÃû³Æ¡¢µØÖ·Ê²Ã´µÄ½øÐÐÕªÒªÌáÈ¡¡¢² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ