oracle²»Í¬°æ±¾Ö®¼äµÄÇл»
¼òµ¥ÃèÊöÒ»ÏÂÔÚwindowsµÄͬһÓû§Ï£¬°²×°OracleµÄ9i¡¢10gºÍ11gµÄ·½·¨¡£
OracleÔÚwindowsƽ̨ϵݲװÊÇËùÓÐƽ̨ÖÐ×î¼òµ¥µÄ£¬»ù±¾Éϲ»ÐèÒª½øÐÐÈκζîÍâµÄ´¦Àí¾Í¿ÉÒԳɹ¦µÄ°²×°£¬¿ÉÒÔ˵ûÓÐʲô¼¼Êõº¬Á¿¡£
²»¹ýÔÚͬһ̨»úÆ÷µÄͬһ¸öÓû§ÉÏͬʱ°²×°Á½¸ö²»Í¬°æ±¾µÄÊý¾Ý¿â¾ÍÐèÒªÒ»¶¨µÄ¼¼ÇÉÁË¡£ÕâÀï¼òµ¥ÃèÊöÒ»ÏÂÔÚͬʱ°²×°OracleµÄ9i¡¢10gºÍ11gÐèҪעÒâµÄÎÊÌâ¡£
Ê×ÏÈ£¬°²×°°æ±¾ÐèÒª´ÓµÍµ½¸ß¡£Ò²¾ÍÊÇ˵ÏÈ°²×°9iµÄÊý¾Ý¿â£¬È»ºó°²×°10gµÄÊý¾Ý¿â£¬×îºó°²×°11gµÄÊý¾Ý¿â¡£
µÚ¶þ£¬ORACLE_BASE¿ÉÒÔÖ¸¶¨Í¬Ò»¸öĿ¼£¬ORACLE_HOMEÐèÒªÖ¸¶¨²»Í¬µÄĿ¼¡£²ÉÓÃOFA¿ÉÒÔºÜÇáËɵĽâ¾öÕâ¸öÎÊÌâ¡£
µÚÈý£¬ÔڵͰ汾µÄÊý¾Ý¿â°²×°Íê³Éºó£¬×îºÃͨ¹ýÈÎÎñ¹ÜÀíÇø¹Ø±ÕËùÓеÄOracleÏà¹ØµÄÈÎÎñ£¬È»ºóÔÚ°²×°¸ß°æ±¾µÄÊý¾Ý¿â¡£·ñÔò°²×°¹ý³ÌÖУ¬¿ÉÄÜ»áºÍÒѾ°²×°µÄ·þÎñ³öÏÖ³åÍ»£¬±ÈÈçLISNTER·þÎñ¡£
ÔÚÈý¸öÊý¾Ý¿â°²×°È«²¿Íê³Éºó£¬ÉèÖÃÈÎÎñ¹ÜÀíÆ÷ÖÐOracleÏà¹ØµÄÈÎÎñ£¬È·±£³ýÁËÊý¾Ý¿â·þÎñÍ⣬ÆäËûµÍ°æ±¾µÄ·þÎñ¶¼´¦ÓÚÊÖ¹¤×´Ì¬£¬Ö»½«¸ß°æ±¾µÄ·þÎñ´¦ÓÚ×Ô¶¯×´Ì¬¡£
ÓÉÓÚ°²×°µÄÏȺó˳Ðò£¬¸ß°æ±¾µÄORACLE_HOME/binĿ¼ÔÚPATH±äÁ¿µÄÇ°Ã棬Ҳ¾ÍÊÇ˵£¬Èç¹ûÖ´ÐÐsqlplus¡¢rman¡¢expµÈÃüÁîÐй¤¾ßĬÈ϶¼ÊÇÔËÐи߰汾µÄOracle¹¤¾ß¡£Õâ¶ÔÓÚ´ó¶àÊýÇé¿ö²»ÊÇÎÊÌâ¡£
µ±È·ÊµÐèҪʹÓõͰ汾µÄ¹¤¾ßʱ£¬±ÈÈçÐèÒªµÍ°æ±¾µÄexp¹¤¾ß½øÐе¼³ö²Ù×÷£¬Õâ¸öʱºò¿ÉÒÔÔÚÃüÁîÐз½Ê½ÏÂÉèÖÃORACLE_HOME£¬È»ºóÔÚµ÷ÓÃexp¼´¿É£º
E:>sqlplus /nolog
SQL*Plus: Release 11.1.0.6.0 - Production on ÐÇÆÚËÄ 10ÔÂ 25 16:16:13 2007
Copyright (c) 1982, 2007, Oracle. All rights reserved.c
SQL> exit
Èç¹ûÊÇ¿Í»§¶Ë,Çл»ÈçÏÂ:
e:>path d:\oracle10g32\product\10.2.0\client_1\bin
e:>sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on ÐÇÆÚËÄ 10ÔÂ 25 16:16:51 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved
SQL> exit
E:>SET ORACLE_HOME=e:\oracleoracle1020
E:>%ORACLE_HOME%bin sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on ÐÇÆÚËÄ 10ÔÂ 25 16:16:51 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved
SQL> exit
E:>SET ORACLE_HOME=e:\oracleoracle920
E:>SET PATH=e:oracleoracle920bin
E:>sqlplus /nolog
SQL*Plus: Release 9.2.0.4.0 - Produc
Ïà¹ØÎĵµ£º
ʹÓÃjava + oracle²åÈëclobÀàÐ͵ÄÊý¾Ý£¬ÐèÒªÓÃÒÔϵIJ½Ö裺
1¡¢½«Êý¾Ý²åÈëÊý¾Ý¿â£¬¶ÔÓÚclob×ֶΣ¬Ê¹ÆäΪ¿ÕclobÊý¾Ý¡£ÀýÈ磺insert into test values(1,empty_clob())";
2¡¢´ÓÊý¾Ý¿âÖÐÈ¡³ö²åÈëµÄclob×ֶΣ¬²¢½«Æ丳ֵ¸øoracle.sql.clobÀàÐ͵ıäÁ¿¡£ÀýÈç
String sqll="select content from test where id=1 for upda ......
×÷Õß: ÈýÊ®¶øÁ¢Ê±¼ä£º2009Äê11ÔÂ08ÈÕ 12:15:21Çë×ðÖØÔ´´×÷Æ·¡£×ªÔØÇë±£³ÖÎÄÕÂÍêÕûÐÔ,²¢ÒÔ³¬Á´½ÓÐÎʽעÃ÷Ôʼ×÷Õß¡°inthirties£¨ÈýÊ®¶øÁ¢£©¡±ºÍ³ö´¦¡±http://blog.csdn.net/inthirties/archive/2009/11/08/4786769.aspx¡±,ÉîÈëÌÖÂÛ¿ÉÒÔÁªÏµinthirties@gmail.com¡£ÔÚcsdnÉÏ¿´µ½Ò»¸öÍøÓÑÎʵÄÒ»¸öÎÊÌâ http://topic.csdn.net ......
41.SYSDATE
ÓÃÀ´µÃµ½ÏµÍ³µÄµ±Ç°ÈÕÆÚ
SQL> select to_char(sysdate,dd-mm-yyyy day) from dual;
TO_CHAR(SYSDATE,
-----------------
09-05-2004ÐÇÆÚÈÕ
trunc(date,fmt)°´ÕÕ¸ø³öµÄÒªÇó½«ÈÕÆڽضÏ,È ......
ÉèÁ¢·âËø»úÖÆÖ÷ÒªÊÇΪÁ˶Բ¢·¢²Ù×÷½øÐпØÖÆ£¬¶Ô¸ÉÈŽøÐзâËø£¬±£Ö¤Êý¾ÝµÄÒ»ÖÂÐÔºÍ׼ȷÐÔ¡£OracleÊý¾Ý¿â·âËø·½Ê½ÓÐÈýÖÖ£º¹²Ïí·âËø£¬¶ÀÕ¼·âËø£¬¹²Ïí¸üзâËø
¡¡¡¡ [b:8f4f63b9bb]·âËøÀàÐÍ[/b:8f4f63b9bb]
¡¡¡¡ Oracle¡¡RDBMSµÄ·âËøÀàÐÍ¿É·ÖΪÈçÏÂÈýÀࣺ
¡¡¡¡ £±¡¢ÄÚ²¿¼¶·âËø
¡¡¡¡ ÄÚ²¿¼¶·âËøÊÇÓÃÓÚ±£»¤ORACLEÄÚ²¿½á ......