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

oracle ·¢Óʼþ´íÎó

ÏÂÃæ´æ´¢¹ý³ÌÖ´ÐкóÓдíÎó£¬
create or replace procedure test_mail(msg_subject in varchar2,
                            mes_context in varchar2,to_user in varchar2)
                       
is

        Mail_Conn Utl_Smtp.Connection;
        Msg      Varchar2(4000);
        Msg_Raw  Raw(32767);
     
        v_User Varchar2(20) :='user';
        v_Pass Varchar2(20) :='pass';
       
        v_Mailhost Varchar2(50) := 'stmp.126.com';
        v_Mailport Integer := 25;

     
        --Óʼþ·¢ËͲÎÊý
     
      v_Senduser Varchar2(50) := 'fff_911@126.com';
Begin

        Msg := 'Date:' || To_Char(Sysdate, 'dd mon yy hh24:mi:ss') || Utl_Tcp.Crlf;
        Msg := Msg || 'from: ' || v_Senduser || ' <' || v_Senduser || '>' || Utl_Tcp.Crlf;
        Msg := Msg || 'To: ' || to_user || 


Ïà¹ØÎÊ´ð£º

lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿


......

¹òÇó lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
¸½Í¼Æ¬ ......

ssh oracle Á¬½Ó


Ðֵܠ ͼ¹ÒÁË¡£

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value ......

¹ØÓÚoracle 10gµÄEMÆô¶¯ÎÊÌâ

oracle 10g°²×°Íê±ÏºóĬÈÏ»áÒÔÍøÒ³ÐÎʽÆô¶¯EM£¬µ«Îҹرպó¾ÍûÔÚ¿ªÊ¼²Ëµ¥ÀïÕÒµ½ÏàÓ¦µÄÍøÒ³Ä£Ê½Æô¶¯EMºÍJAVA³ÌÐòÆô¶¯µÄEMÑ¡ÏÇëÎÊÕâÊÇÔõô»ØÊ£¿
emÊǸö·þÎñ£¬

°²×°ºÃÒÔºóÓ¦¸ÃÔÚÄãµÄ·þÎñÁбíÀïÕÒµ½ÀàËÆOrac ......

oracle textÈ«ÎļìË÷(׿±)

oracle text×öË÷Òýͬ²½µÄʱºò,Ó°Ïì²éѯÂð?ÈçºÎÖ¤Ã÷ÄØ?
ͬʱË÷Òýͬʱ²éѯ,²¢·¢½øÐÐͬһÌõ¼Ç¼
×Ô¼º¶¥Ò»¸ö

²Î¿¼£ºhttp://blog.csdn.net/fengzhu1008/archive/2009/01/15/3784853.aspx

text×öË÷Òý¡£ºÜ»áÓ°ÏìË ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ