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

C#´¦Àíoracle lobµÄÀý×Ó

  protected void BindData1()
    {
        OracleConnection orcn = new OracleConnection("User ID=wesoftwcp; Password=wesoft; Data Source=oradb");
        orcn.Open();
        string MyData = "";
        StreamReader rs = new StreamReader(@"c:\1.txt");
        MyData = rs.ReadToEnd();
        rs.Close();
        //OracleConnection orcn = new OracleConnection("User ID=wesoftwcp; Password=wesoft; Data Source=oradb");
        //orcn.Open();
        OracleType lobtype = OracleType.Clob; //Èç¹ûÊÇblobÕâÀï¸Ä³ÉOracleType.blob
        string CreateTempBlob = "DECLARE A " + lobtype + "; " +
            "BEGIN " +
            "DBMS_LOB.CREATETEMPORARY(A, FALSE); " +
            ":LOC := A; " +
            "END;";
        OracleTransaction transaction = orcn.BeginTransaction();
        OracleParameter[] param = new OracleParameter[1];
        param[0] = new OracleParameter("LOC", OracleType.Clob);
        //OracleHelper.CacheParameter(CreateTempBlob,param);
        OracleCommand cmdTemp = new OracleCommand(CreateTempBlob, orcn);
        param[0].Direction = ParameterDirection.Output;
        //OracleHelper.ExecuteNonQuery(transaction


Ïà¹ØÎĵµ£º

oracle¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

ÔÚFedora 10Éϰ²×°Oracle£¨10.2.0£©[³­Ï®]

ÔÚFedora 10Éϰ²×°Oracle£¨10.2.0£©
ĬÈϵÄϵͳ²ÎÊýÏ£¬ÔÚFedora 10ÉÏÎÞ·¨°²×°Oracle£¬ÐèÒª½øÐÐÏÂÁÐÈô¸É´¦Àí£º
   1. Ñé֤ϵͳҪÇó
    ÒªÑé֤ϵͳÊÇ·ñÂú×ã Oracle 10g Êý¾Ý¿âµÄ×îµÍÒªÇó£¬ÒÔ root Óû§Éí·ÝµÇ¼²¢ÔËÐÐÒÔÏÂÃüÁî¡£
    Òª²é¿´¿ÉÓà RAM ºÍ½»»»¿Õ¼ä´óС£¬ÔËÐÐÒÔÏÂà ......

java²Ù×÷oracleÊý¾Ý¿âÖеÄblob×Ö¶Î

oracleÖеÄBLOB×Ö¶ÎÊÇ´æ´¢2½øÖƵÄÎļþ£¬±ÈÈçÎļþ£¬Í¼Æ¬µÈ¡£
1¡¢°Ñ±¾µØÎļþдÈëÊý¾Ý¿â
package com.data;
import java.io.File;
import java.io.FileInputStream;
import java.io.OutputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.R ......

DelphiÓëC#Ö®¸¸£º¼¼ÊõÀíÏë¼Ü¹¹¿ª·¢´«Ææ

    Anders Hejlsberg(°²µÂ˹-º£É­²©¸ñ) ×øÔÚ×Ô¼ºµÄ°ì¹«ÊÒ£¬Ë«ÑÛÖ±Ö±µÄ¶¢×Åǰ·½¡£ËûÒª×öÒ»¸ö¾ö¶¨£¬¾ö¶¨×Ô¼ºÎ´À´µÄÃüÔ˺ÍÀíÏë¡£ÕâÊÇ1996ÄêÒ»¸öÆÕͨµÄÏÂÎ磬¼¸¸öСʱǰ£¬Ëû¸ÕÓë±È¶û-¸Ç´Ä½áÊøÁËÒ»´ÎÓä¿ìµÄÎç²Í£¬Í¬ÎªÈí¼þ½çµÄ¾«Ó¢£¬ËûÃÇÏà̸Éõ»¶£¬¸Ç´Ä¸øËû¿ª³öÈý°ÙÍòÒÔÉϵÄÄêнºÍÊýÍò¹ÉµÄ΢Èí¹ÉƱ¡£ÕâÊÇÒ»¸öÓÕÈË ......

SuSE Linux10Éϰ²×°OracleÊý¾Ý¿â

ϵͳҪÇó£º
¡¡¡¡ÄÚ´æ£ºÍÆ¼ö1G
¡¡¡¡Swap·ÖÇø£ºÉèΪÄÚ´æµÄ2±¶
¡¡¡¡/tmp´ÅÅ̿ռ䣺400MBÒÔÉÏÈý
¡¡¡¡´ÅÅ̿ռ䣺Èí¼þ3.5G Êý¾Ý1.2G
¡¡¡¡ËùÐèÈí¼þ£º
¡¡¡¡SuSE Linux10 for x86
¡¡¡¡Oracle database 10gR2 for Linux32
¡¡¡¡Orarun-1.8-109.15.i586.rpmÈí¼þ°ü£¬¿ÉÒÔ´Óhttp://Ftp.novell.com/partners/Oracle/sels-9ÏÂÔØ
&n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ