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

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


Ïà¹ØÎĵµ£º

Oracle ѧϰ£ºPL/SQLÑ­Ðò½¥½øÈ«Ãæѧϰ½Ì³Ì

 ¿Î³ÌÊ®Èý ʹÓÃ×éºÏÊý¾ÝÀàÐÍ* Óαê²Ù×ÝÊý¾Ý
¡¡¡¡
¡¡¡¡±¾¿ÎÖص㣺
¡¡¡¡1¡¢´´½¨Óû§×Ô¶¨ÒåµÄPLSQL¼Ç¼
¡¡¡¡2¡¢ÀûÓÃ%ROWTYPEÊôÐÔÀ´´´½¨¼Ç¼
¡¡¡¡3¡¢´´½¨PLSQL±í
¡¡¡¡4¡¢ÃèÊö¼Ç¼¡¢±í¡¢¼Ç¼µÄ±íÖ®¼äµÄÇø±ð
¡¡¡¡×¢Ò⣺ÒÔÏÂʵÀýÖбêµã¾ùΪӢÎÄ°ë½Ç
¡¡¡¡Ò»¡¢ºÏ³ÉÊý¾ÝÀàÐÍ
¡¡¡¡1¡¢ÀàÐÍ·ÖΪPLSQL¼Ç¼ºÍPLSQL±í
¡¡¡¡2¡ ......

OracleÓëSQL ServerÊý¾Ý»¥Ò×ÐÔ£¨1£©

×÷Õß Haidong Ji ·­Òë GoodKid
ÎÒÃǵ±ÖеĴ󲿷ÖÈ˹¤×÷ÔÚÒ»¸öµ¥Ò»µÄ RDBMS ϵͳÖУ¬Èç MSSQL, Oracle, or IBM DB2¡£È»¶ø£¬ÎÒÃÇÈÕÒæ¸Ð¾õµ½£¬ÎÒÃÇÕý´¦ÓÚ²»Í¬µÄÊý¾Ý¿â»·¾³µ±Öв¢ÇÒÐèÒª½â¾öÊý¾ÝµÄ»¥ÓÃÐÔÎÊÌâ¡£
¾¡¹ÜÖ÷ÒªµÄ RDBMS ³§ÉÌÊÔͼȥ×ñÑ­¹ØϵÊý¾Ý¿âÄ£ÐÍÔ­Àí£¬²¢ÇÒÓ÷dz£Ð¡µÄ²îÒìȥʵÏÖËüÃÇ¡£ÁíÍ⣬¼¸ºõÖ÷ÒªµÄ ......

110¸öoracle³£Óú¯Êý×ܽá(3)

 41.SYSDATE
    ÓÃÀ´µÃµ½ÏµÍ³µÄµ±Ç°ÈÕÆÚ
    SQL> select to_char(sysdate,dd-mm-yyyy day) from dual;
    TO_CHAR(SYSDATE,
  -----------------
    09-05-2004ÐÇÆÚÈÕ
    trunc(date,fmt)°´ÕÕ¸ø³öµÄÒªÇó½«ÈÕÆڽضÏ,È ......

ѧϰOracleÖÐBlobºÍClobÒ»µãµãÐĵÃ

BlobÊÇÖ¸¶þ½øÖÆ´ó¶ÔÏóÒ²¾ÍÊÇÓ¢ÎÄBinary Large ObjectµÄËùд£¬¶øClobÊÇÖ¸´ó×Ö·û¶ÔÏóÒ²¾ÍÊÇÓ¢ÎÄCharacter Large ObjectµÄËùд¡£Óɴ˿ɼûÕâÁ¾¸öÀàÐͶ¼ÊÇÓÃÀ´´æ´¢´óÁ¿Êý¾Ý¶øÉè¼ÆµÄ£¬ÆäÖÐBLOBÊÇÓÃÀ´´æ´¢´óÁ¿¶þ½øÖÆÊý¾ÝµÄ£»CLOBÓÃÀ´´æ´¢´óÁ¿Îı¾Êý¾Ý¡£
ÄÇôÓÐÈ˿϶¨ÒªÎʼÈÈ»ÒѾ­ÓÐVARCHARºÍVARBINARYÁ½ÖÐÀàÐÍ£¬ÎªÊ²Ã´»¹ÒªÔÙÊ ......

oracle±äÁ¿ÀàÐÍ

 oracle±äÁ¿ÀàÐÍ
±êÁ¿ÀàÐÍ
varchar2(n)  ÓÃÓÚ¶¨Òå¿É±ä³¤¶ÈµÄ×Ö·û´®  nÓÃÓÚÖ¸¶¨×Ö·û´®µÄ×î´ó³¤¶È Æä×î´óֵΪ32767×Ö½Ú ±ØÐëÖ¸¶¨n
char(n)  ÓÃÓÚ¶¨Òå¹Ì¶¨³¤¶ÈµÄ×Ö·û´® ÆäÖÐnÓÃÓÚÖ¸¶¨×Ö·û´®µÄ×î´ó³¤¶È£¬Æä×î´óֵΪ32767  Èç¹û²»Ö¸¶¨n ĬÈÏÊÇ1
number(p,s)¸ÃÊý¾ÝÀàÐÍÓÃÓÚ¶¨Òå¹Ì¶¨³¤¶ÈµÄÕûÊýºÍ¸¡µã ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ