ÈçºÎÐ¶ÔØOracle 10g
Èí¼þ»·¾³£º
1¡¢Windows XP + Oracle 10g
2¡¢Oracle°²×°Â·¾¶Îª£ºd:\Oracle
ʵÏÖ·½·¨£º
1¡¢¿ªÊ¼££¾ÉèÖ㣾¿ØÖÆÃæ°å££¾¹ÜÀí¹¤¾ß££¾·þÎñÍ£Ö¹ËùÓÐOracle·þÎñ£»
2¡¢¿ªÊ¼££¾³ÌÐò££¾Oracle – OraDb10g_home1£¾Oracle Installation Products££¾ Universal Installer жװËùÓÐOracle²úÆ·£¬µ«Universal Installer±¾Éí²»Äܱ»É¾³ý£»
3¡¢ÔËÐÐregedit£¬Ñ¡ÔñHKEY_LOCAL_MACHINE\SOFTWARE\ORACLE£¬°´del¼üɾ³ýÕâ¸öÈë¿Ú£»
4¡¢ÔËÐÐregedit£¬Ñ¡ÔñHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services£¬¹ö¶¯Õâ¸öÁÐ±í£¬É¾³ýËùÓÐOracleÈë¿Ú£»
5¡¢ÔËÐÐrefedit£¬Ñ¡ÔñHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application£¬É¾³ýËùÓÐOracleÈë¿Ú£»
6¡¢¿ªÊ¼££¾ÉèÖ㣾¿ØÖÆÃæ°å££¾ÏµÍ³££¾¸ß¼¶££¾»·¾³±äÁ¿,ɾ³ý»·¾³±äÁ¿CLASSPATHºÍPATHÖÐÓйØOracleµÄÉ趨£»
7¡¢´Ó×ÀÃæÉÏ¡¢STARTUP£¨Æô¶¯£©×é¡¢³ÌÐò²Ëµ¥ÖУ¬É¾³ýËùÓÐÓйØOracleµÄ×éºÍͼ±ê£»
8¡¢É¾³ýc:\Program Files\OracleĿ¼£»
9¡¢ÖØÐÂÆô¶¯¼ÆËã»ú£¬ÖØÆðºó²ÅÄÜÍêȫɾ³ýOracleËùÔÚĿ¼ £»
10¡¢É¾³ýÓëOracleÓйصÄÎļþ£¬Ñ¡ÔñOracleËùÔÚµÄȱʡĿ¼C:\Oracle£¬É¾³ýÕâ¸öÈë¿ÚĿ¼¼°ËùÓÐ×ÓĿ¼£¬²¢´ÓWindows XPĿ¼£¨Ò»°ãΪd:\WINDOWS£©ÏÂɾ³ýÒÔÏÂÎļþORACLE.INI¡¢oradim73.INI¡¢oradim80.INI¡¢oraodbc.iniµÈµÈ£»
11¡¢WIN.INIÎļþÖÐÈôÓÐ[ORACLE]µÄ±ê¼Ç¶Î£¬É¾³ý¸Ã¶Î£»
12¡¢ÈçÓбØÒª£¬É¾³ýËùÓÐOracleÏà¹ØµÄODBCµÄDSN£»
13¡¢µ½Ê¼þ²é¿´Æ÷ÖУ¬É¾³ýOracleÏà¹ØµÄÈÕÖ¾ ˵Ã÷£ºÈç¹ûÓиö±ðDLLÎļþÎÞ·¨É¾³ýµÄÇé¿ö£¬Ôò²»ÓÃÀí»á£¬ÖØÐÂÆô¶¯£¬¿ªÊ¼Ðµİ²×°£¬°²×°Ê±£¬Ñ¡ÔñÒ»¸öеÄĿ¼£¬Ôò£¬°²×°Íê±Ï²¢ÖØÐÂÆô¶¯ºó£¬ÔÀ´µÄĿ¼¼°Îļþ¾Í¿ÉÒÔɾ³ýµôÁË¡£
±¾ÎÄÀ´×ÔCSDN²©¿Í£¬×ªÔØÇë±êÃ÷³ö´¦£ºhttp://blog.csdn.net/zhangxu3739/archive/2008/02/20/2109527.aspx
Ïà¹ØÎĵµ£º
OracleϵÁУºÍ¼Æ¬µÄ´æ´¢
Ò»£ºÊ²Ã´ÊÇ´ó¶ÔÏ󣬴ó¶ÔÏó»ù±¾²Ù×÷£¿
²Î¼ûÎÒµÄBLOG£ºOracleϵÁУºLOB´ó¶ÔÏó´¦Àí
http://blog.csdn.net/qfs_v/archive/2008/05/21/2464599.aspx
¶þ£¬Í¼Æ¬µÄ´æ´¢»ò¶þ½øÖÆÎļþµÄ´æ´¢
1£¬ÏȲåÈëÆÕͨÊý¾Ý£¬Óöµ½´ó¶ÔÏóÁÐʹÓÃempty_blob()¹¹Ôì¿ÕµÄÖ¸Õë¡£
Àý× ......
Ò»¡¢ÏµÍ³µÄĬÈÏÓû§
Java´úÂë
sys;//ϵͳ¹ÜÀíÔ±£¬ÓµÓÐ×î¸ßȨÏÞ
system;//±¾µØ¹ÜÀíÔ±£¬´Î¸ßȨÏÞ
scott;//ÆÕͨÓû§£¬ÃÜÂëĬÈÏΪtiger,ĬÈÏδ½âËø
¶þ¡¢µÇ½
Java´úÂë
sqlplus conn / as sysdba;//µÇ½sysÕÊ»§ ......
FORALLÓï¾äµÄÒ»¸ö¹Ø¼üÐԸĽø£¬Ëü¿É´ó´ó¼ò»¯´úÂ룬²¢ÇÒ¶ÔÓÚÄÇЩҪÔÚPL/SQL³ÌÐòÖиüкܶàÐÐÊý¾ÝµÄ³ÌÐòÀ´Ëµ£¬Ëü¿ÉÏÔÖøÌá¸ßÆäÐÔÄÜ¡£
1:
ÓÃFORALLÀ´ÔöÇ¿DMLµÄ´¦ÀíÄÜÁ¦
OracleΪOracle8iÖеÄPL/SQLÒýÈëÁËÁ½¸öеÄÊý¾Ý²Ù×ÝÓïÑÔ£¨DML£©Óï¾ä£ºBULK COLLECTºÍFORALL¡£ÕâÁ½¸öÓï¾äÔÚPL/SQLÄÚ²¿½øÐÐÒ»ÖÖÊý×é´¦Àí
£»BULK COLLE ......
Ô´´ÓÚ2007Äê04ÔÂ12ÈÕ£¬2009Äê10ÔÂ15ÈÕÇ¨ÒÆÖÁ´Ë¡£
windows xp£¬Êý¾Ý¿âoracle 10.2.0¡£1
ûÓб¸·Ý£¬»ù±¾ÉÏÊÇĬÈϰ²×°£¬ºÃÏñ»¹²»Êǹ鵵ģʽ
Ö¢×´£ºsqlplusÖ»ÓÐsysdbaÓû§ÄܽøÈ¥£¬ÆäËûÓû§½øÈ¥Ò»¸Å±¨£ºora-01033£ºoracleÕýÔÚ³õʼ»¯»ò¹Ø±Õ
¶øÇÒsysdbaÓû§½øÈ¥Ö®ºóÄÜÖ´ÐÐselect sysdate from dual£¬µ«ÊÇÖ´ÐÐselect use ......