Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ×Ö·û¼¯

²é¿´oracle·þÎñÆ÷×Ö·û¼¯:select * from nls_database_parameters where parameter = 'NLS_CHARACTERSET'
ʹÓÃPl/SQL ²éѯÊý¾ÝʱÂÒÂë,²åÈëÊý¾ÝʱÂÒÂë
Êý¾Ý¿â·þÎñÆ÷µÄ×Ö·û¼¯ºÍ¿Í»§¶ËµÄ×Ö·û¼¯²»Í¬ËùÔì³ÉµÄ,ÐÞ¸ÄÊý¾Ý¿â¿Í»§¶ËµÄ×Ö·û¼¯ºÍ·þÎñÆ÷µÄ×Ö·û¼¯Ò»ÖÂ
²Ù×÷·½·¨:
   oracle 9i :Ð޸ı¾µØ×¢²á±íÖÐORACLE¿Í»§¶Ëµ ......

Oracle×Ö·û´®³¤¶ÈµÄÎÊÌâ

    ½ñÌìÅöµ½Ò»¸öÎÊÌ⣬ͨ¹ýÒ»¸öSQLÓï¾ä²éѯʱ£¬³öÈçÏÂÎÊÌ⣺
       ORA-06502: PL/SQL: numeric or value error: character string buffer too small
       ORA-06512: at "WMSYS.WM_CONCAT_IMPL", line 30
 ÎÊÌâ³öÏÖÔÚͨ¹ýWMSYS. ......

OracleÖвéѯ±íµÄ´óСºÍ±í¿Õ¼äµÄ´óС

±¾ÎÄÀ´×ÔCSDN²©¿Í£¬×ªÔØÇë±êÃ÷³ö´¦£ºhttp://blog.csdn.net/cosio/archive/2009/03/11/3978747.aspx
ÓÐÁ½ÖÖº¬ÒåµÄ±í´óС¡£Ò»ÖÖÊÇ·ÖÅä¸øÒ»¸ö±íµÄÎïÀí¿Õ¼äÊýÁ¿£¬¶ø²»¹Ü¿Õ¼äÊÇ·ñ±»Ê¹Ó᣿ÉÒÔÕâÑù²éѯ»ñµÃ×Ö½ÚÊý£º
select segment_name, bytes
from user_segments
where segment_type = 'TABLE';
»òÕß
   Sel ......

Oracle DBA ±ÊÊÔÌâ

author£ºskate
time£º2010-05-26
Oracle DBA ±ÊÊÔÌâ
£¨´ðÌâʱ¼ä60·ÖÖÓ£©
ÍøÉÏ¿´¼ûһƪDBAµÄÃæÊÔÌ⣬¾õµÃͦʵÓõ쬶ø²»ÏñÓеÄÃæÊÔŪµÃºÜÐ飬ºÜÀíÏ뻯¡£
Unix/Linux퉀1¡¢ÈçºÎ²é¿´Ö÷»úcpu£¬ÄÚ´æ¡¢IPºÍ´ÅÅ̿ռä?
2¡¢Äã³£ÓõĽø³Ì¹ÜÀí¡¢Ö÷»úÐÔÄܲ쿴ÃüÁîÓÐÄÄЩ£¿
3¡¢½¨Á¢×édbaºÍ¸Ã×éÏÂÓû§oracle£¬Ä¬ÈÏshellΪbash¡£ ......

Oracle¹éµµ¹ÜÀí

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