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·þÎñÆ÷×Ö·û¼¯:select * from nls_database_parameters where parameter = 'NLS_CHARACTERSET'
ʹÓÃPl/SQL ²éѯÊý¾ÝʱÂÒÂë,²åÈëÊý¾ÝʱÂÒÂë
Êý¾Ý¿â·þÎñÆ÷µÄ×Ö·û¼¯ºÍ¿Í»§¶ËµÄ×Ö·û¼¯²»Í¬ËùÔì³ÉµÄ,ÐÞ¸ÄÊý¾Ý¿â¿Í»§¶ËµÄ×Ö·û¼¯ºÍ·þÎñÆ÷µÄ×Ö·û¼¯Ò»ÖÂ
²Ù×÷·½·¨:
oracle 9i :Ð޸ı¾µØ×¢²á±íÖÐORACLE¿Í»§¶Ëµ ......
Oracle 9iÐÔÄܵ÷Õû
/* *
×÷Õß:Å·³¯¾´
QQ:35712069
ÊÖ»ú:13873195792
Çë×ªÔØÕß²»Òª¸ü¸ÄÔ°æÄÚÈÝ
*/
1¡¢ÉèÖúÏÊʵÄSGA
¡¡¡¡³£³£ÓÐÈ˱§Ô¹·þÎñÆ÷Ó²¼þºÜºÃ£¬µ«ÊÇOracle¾ÍÊǺÜÂý¡£ºÜ¿ÉÄÜÊÇÄÚ´æ·ÖÅä²»ºÏÀíÔì³ÉµÄ¡£
¡¡¡¡(1)¼ÙÉèÄÚ´æÓÐ512M£¬Õâͨ³£ÊÇСÐÍÓ¦Ó᣽¨ÒéOracleµÄSGA´óÔ¼240M£¬ÆäÖУº¹²Ïí³Ø£¨SHARED_POOL ......
½ñÌìÅöµ½Ò»¸öÎÊÌ⣬ͨ¹ýÒ»¸öSQLÓï¾ä²éѯʱ£¬³öÈçÏÂÎÊÌ⣺
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "WMSYS.WM_CONCAT_IMPL", line 30
ÎÊÌâ³öÏÖÔÚͨ¹ýWMSYS. ......
ʲôÊÇsavepoint?
Use the SAVEPOINT statement to identify a point in a transaction to which you can later roll back.
¸øÄã¸öÀý×Ó
SQL> create table test (id number(7));
±íÒÑ´´½¨¡£
SQL> insert into test values (3);
ÒÑ´´½¨ 1 ÐС£
SQL> savepoint a;
±£´æ ......