oracleÅú´¦ÀíÊý¾Ý
ÔÚORACLEÖÐTAB±íÖнṹ£º A INT , B nvarchar2(50) ÎÒÔÚD:\DATA.TXTÖÐÓдóÁ¿Êý¾Ý£¬¸ñʽÓëTAB±íÏàͬ£¬ÏÖÎÒÏ뽫TXTÎļþµ¼Èëµ½TAB±íÖУ¬ ʵÏÖÕâÖÖÅú´¦ÀíµÄ·½·¨£¬ÎÒÔÚSQL2000ÖÐÓ㺠BULK INSERT ʼþ¼Ç¼±í from 'D:\DATA.TXT¡® WITH ( DATAFILETYPE = 'char', FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' ) ¶øÔÚORACLEÖÐʹÓÃÕâÖÖ·½·¨È´ÒѲ»ÐÐÁË£¬ÇëÎÊORACLEÓÃʲô·½·¨À´´¦ÀíÅúÁ¿Êý¾ÝµÄ²åÈë¡£
°ÑÊý¾Ý·ÅÔÚexcel ÖÐ Ö±½ÓÓÃsqlserver ÆóÒµ¹ÜÀíÆ÷¾ÍÄÜÖ±½Óµ¼Èë ´ò¿ªÆóÒµ¹ÜÀíÆ÷ ÓÒ»÷¿â µ¼ÈëÊý¾Ý Ñ¡ÔñÄ¿±ê¿â ÔÙÑ¡Ôñµ¼ÈëexeclÓ¦ÓóÌÐò Ö¸¶¨Îļþ µ¼Èë OKÒýÓà °ÑÊý¾Ý·ÅÔÚexcel ÖÐ Ö±½ÓÓÃsqlserver ÆóÒµ¹ÜÀíÆ÷¾ÍÄÜÖ±½Óµ¼Èë ´ò¿ªÆóÒµ¹ÜÀíÆ÷ ÓÒ»÷¿â µ¼ÈëÊý¾Ý Ñ¡ÔñÄ¿±ê¿â ÔÙÑ¡Ôñµ¼ÈëexeclÓ¦ÓóÌÐò Ö¸¶¨Îļþ µ¼Èë OK ´ó¸ç£¬È˼ÒÎʵÄÊÇoracle£¬ÈÏÕæ¿´ÌûÒ²ÊÇÒ»ÖÖ¸ºÔðÈεÄ̬¶È 1.sqlplus username/password@sid 2.ÔÚÊý¾Ý¿âÖн¨Á¢ºÃÐèÒªµ¼ÈëµÄÊý¾Ý±í½á¹¹ 3.ÊÖ¶¯±£´æinput.ctlÎļþ load data infile 'test.txt' append into table system.lin--×·¼Ó¼Ç¼ filelds teminated by X'09' 4.sqlldr userid=
Ïà¹ØÎÊ´ð£º
¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮ ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update Caused ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿ Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É SQL> select name from v$database; NAME --------- ORCL
......
[color=#FF0000][/color]ÒÔÏÂÊÇÎÒµÄservlet´úÂë[color=#FF0000][/color]package JDBCExample1.demo1; import java.io.IOException; import java.io.PrintWriter; import javax.servlet.ServletException; import ......