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
Ïà¹ØÎĵµ£º
¿Î³ÌÊ®Èý ʹÓÃ×éºÏÊý¾ÝÀàÐÍ* Óαê²Ù×ÝÊý¾Ý
¡¡¡¡
¡¡¡¡±¾¿ÎÖص㣺
¡¡¡¡1¡¢´´½¨Óû§×Ô¶¨ÒåµÄPLSQL¼Ç¼
¡¡¡¡2¡¢ÀûÓÃ%ROWTYPEÊôÐÔÀ´´´½¨¼Ç¼
¡¡¡¡3¡¢´´½¨PLSQL±í
¡¡¡¡4¡¢ÃèÊö¼Ç¼¡¢±í¡¢¼Ç¼µÄ±íÖ®¼äµÄÇø±ð
¡¡¡¡×¢Ò⣺ÒÔÏÂʵÀýÖбêµã¾ùΪӢÎÄ°ë½Ç
¡¡¡¡Ò»¡¢ºÏ³ÉÊý¾ÝÀàÐÍ
¡¡¡¡1¡¢ÀàÐÍ·ÖΪPLSQL¼Ç¼ºÍPLSQL±í
¡¡¡¡2¡ ......
×÷Õß Haidong Ji ·Òë GoodKid
ÎÒÃǵ±ÖеĴ󲿷ÖÈ˹¤×÷ÔÚÒ»¸öµ¥Ò»µÄ RDBMS ϵͳÖУ¬Èç MSSQL, Oracle, or IBM DB2¡£È»¶ø£¬ÎÒÃÇÈÕÒæ¸Ð¾õµ½£¬ÎÒÃÇÕý´¦ÓÚ²»Í¬µÄÊý¾Ý¿â»·¾³µ±Öв¢ÇÒÐèÒª½â¾öÊý¾ÝµÄ»¥ÓÃÐÔÎÊÌâ¡£
¾¡¹ÜÖ÷ÒªµÄ RDBMS ³§ÉÌÊÔͼȥ×ñѹØϵÊý¾Ý¿âÄ£ÐÍÔÀí£¬²¢ÇÒÓ÷dz£Ð¡µÄ²îÒìȥʵÏÖËüÃÇ¡£ÁíÍ⣬¼¸ºõÖ÷ÒªµÄ ......
41.SYSDATE
ÓÃÀ´µÃµ½ÏµÍ³µÄµ±Ç°ÈÕÆÚ
SQL> select to_char(sysdate,dd-mm-yyyy day) from dual;
TO_CHAR(SYSDATE,
-----------------
09-05-2004ÐÇÆÚÈÕ
trunc(date,fmt)°´ÕÕ¸ø³öµÄÒªÇó½«ÈÕÆڽضÏ,È ......
BlobÊÇÖ¸¶þ½øÖÆ´ó¶ÔÏóÒ²¾ÍÊÇÓ¢ÎÄBinary Large ObjectµÄËùд£¬¶øClobÊÇÖ¸´ó×Ö·û¶ÔÏóÒ²¾ÍÊÇÓ¢ÎÄCharacter Large ObjectµÄËùд¡£Óɴ˿ɼûÕâÁ¾¸öÀàÐͶ¼ÊÇÓÃÀ´´æ´¢´óÁ¿Êý¾Ý¶øÉè¼ÆµÄ£¬ÆäÖÐBLOBÊÇÓÃÀ´´æ´¢´óÁ¿¶þ½øÖÆÊý¾ÝµÄ£»CLOBÓÃÀ´´æ´¢´óÁ¿Îı¾Êý¾Ý¡£
ÄÇôÓÐÈ˿϶¨ÒªÎʼÈÈ»ÒѾÓÐVARCHARºÍVARBINARYÁ½ÖÐÀàÐÍ£¬ÎªÊ²Ã´»¹ÒªÔÙÊ ......
oracle±äÁ¿ÀàÐÍ
±êÁ¿ÀàÐÍ
varchar2(n) ÓÃÓÚ¶¨Òå¿É±ä³¤¶ÈµÄ×Ö·û´® nÓÃÓÚÖ¸¶¨×Ö·û´®µÄ×î´ó³¤¶È Æä×î´óֵΪ32767×Ö½Ú ±ØÐëÖ¸¶¨n
char(n) ÓÃÓÚ¶¨Òå¹Ì¶¨³¤¶ÈµÄ×Ö·û´® ÆäÖÐnÓÃÓÚÖ¸¶¨×Ö·û´®µÄ×î´ó³¤¶È£¬Æä×î´óֵΪ32767 Èç¹û²»Ö¸¶¨n ĬÈÏÊÇ1
number(p,s)¸ÃÊý¾ÝÀàÐÍÓÃÓÚ¶¨Òå¹Ì¶¨³¤¶ÈµÄÕûÊýºÍ¸¡µã ......