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

OracleʹÓÃË÷ÒýµÄºÃ´¦

OracleÌṩÁË´óÁ¿Ë÷ÒýÑ¡Ïî¡£ÖªµÀÔÚ¸ø¶¨Ìõ¼þÏÂʹÓÃÄĸöÑ¡Ïî¶ÔÓÚÒ»¸öÓ¦ÓóÌÐòµÄÐÔÄÜÀ´Ëµ·Ç³£ÖØÒª¡£Ò»¸ö´íÎóµÄÑ¡Ôñ¿ÉÄÜ»áÒý·¢ËÀËø£¬²¢µ¼ÖÂÊý¾Ý¿âÐÔÄܼ±¾çϽµ»ò½ø³ÌÖÕÖ¹¡£¶øÈç¹û×ö³öÕýÈ·µÄÑ¡Ôñ£¬Ôò¿ÉÒÔºÏÀíʹÓÃ×ÊÔ´£¬Ê¹ÄÇЩÒѾ­ÔËÐÐÁ˼¸¸öСʱÉõÖÁ¼¸ÌìµÄ½ø³ÌÔÚ¼¸·ÖÖÓµÃÒÔÍê³É£¬ÕâÑù»áʹÄúÁ¢¿Ì³ÉΪһλӢÐÛ¡£ÕâÆªÎÄÕ¾ͽ«¼òµ¥µÄÌÖÂÛÿ¸öË÷ÒýÑ¡Ïî¡£Ö÷ÒªÓÐÒÔÏÂÄÚÈÝ£º
[1] »ù±¾µÄË÷Òý¸ÅÄî
²éѯDBA_INDEXESÊÓͼ¿ÉµÃµ½±íÖÐËùÓÐË÷ÒýµÄÁÐ±í£¬×¢ÒâÖ»ÄÜͨ¹ýUSER_INDEXESµÄ·½·¨À´¼ìË÷ģʽ(schema)µÄË÷Òý¡£·ÃÎÊUSER_IND_COLUMNSÊÓͼ¿ÉµÃµ½Ò»¸ö¸ø¶¨±íÖб»Ë÷ÒýµÄÌØ¶¨ÁС£
[2] ×éºÏË÷Òý
µ±Ä³¸öË÷Òý°üº¬Óжà¸öÒÑË÷ÒýµÄÁÐʱ£¬³ÆÕâ¸öË÷ÒýΪ×éºÏ£¨concatented£©Ë÷Òý¡£ÔÚ Oracle9iÒýÈëÌøÔ¾Ê½É¨ÃèµÄË÷Òý·ÃÎÊ·½·¨Ö®Ç°£¬²éѯֻÄÜÔÚÓÐÏÞÌõ¼þÏÂʹÓøÃË÷Òý¡£±ÈÈ磺±íempÓÐÒ»¸ö×éºÏË÷Òý¼ü£¬¸ÃË÷Òý°üº¬ÁËempno¡¢ enameºÍdeptno¡£ÔÚOracle9i֮ǰ³ý·ÇÔÚwhereÖ®¾äÖжԵÚÒ»ÁУ¨empno£©Ö¸¶¨Ò»¸öÖµ£¬·ñÔò¾Í²»ÄÜʹÓÃÕâ¸öË÷Òý¼ü½øÐÐÒ»´Î·¶Î§É¨Ãè¡£
ÌØ±ð×¢Ò⣺ÔÚOracle9i֮ǰ£¬Ö»ÓÐÔÚʹÓõ½Ë÷ÒýµÄǰµ¼Ë÷Òýʱ²Å¿ÉÒÔʹÓÃ×éºÏË÷Òý£¡
[3] ORACLE ROWID
ͨ¹ýÿ¸öÐеÄROWID£¬Ë÷ÒýOracleÌṩÁË·ÃÎʵ¥ÐÐÊý¾ÝµÄÄÜÁ¦¡£ROWIDÆäʵ¾ÍÊÇÖ±½ÓÖ¸Ïòµ¥¶ÀÐеÄÏß·ͼ¡£Èç¹ûÏë¼ì²éÖØ¸´Öµ»òÊÇÆäËû¶ÔROWID±¾ÉíµÄÒýÓ㬿ÉÒÔÔÚÈκαíÖÐʹÓúÍÖ¸¶¨rowidÁС£
[4] ÏÞÖÆË÷Òý
ÏÞÖÆË÷ÒýÊÇһЩûÓо­ÑéµÄ¿ª·¢ÈËÔ±¾­³£·¸µÄ´íÎóÖ®Ò»¡£ÔÚSQLÖÐÓкܶàÏÝÚå»áʹһЩË÷ÒýÎÞ·¨Ê¹Óá£ÏÂÃæÌÖÂÛһЩ³£¼ûµÄÎÊÌ⣺
    4.1 ʹÓò»µÈÓÚ²Ù×÷·û£¨<>¡¢!=£©
        ÏÂÃæµÄ²éѯ¼´Ê¹ÔÚcust_ratingÁÐÓÐÒ»¸öË÷Òý£¬²éѯÓï¾äÈÔȻִÐÐÒ»´ÎÈ«±íɨÃè¡£
         select cust_Id,cust_name
         from   customers
         where  cust_rating <> 'aa';
         °ÑÉÏÃæµÄÓï¾ä¸Ä³ÉÈçϵIJéѯÓï¾ä£¬ÕâÑù£¬ÔÚ²ÉÓûùÓÚ¹æÔòµÄ
         ÓÅ»¯Æ÷¶ø²»ÊÇ»ùÓÚ´ú¼ÛµÄÓÅ»¯Æ÷£¨¸üÖÇÄÜ£©Ê±£¬½«»áʹÓÃË÷Òý¡£
         select cust_Id,cust_name
         from&n


Ïà¹ØÎĵµ£º

oracle´´½¨±í¿Õ¼ä.´´½¨Óû§.´´½¨±í

ÔÚSQL*PlusÖУº£¨1£©ÈçºÎÌí¼Óɾ³ýÊý¾Ý¿â£¿£¨2£©Êý¾Ý¿â¾ÍÊDZíÂ𣿣¿£¨3£©ÈçºÎ´´½¨±í¿Õ¼ä£¿£¨4£©ÈçºÎ´´½¨Óû§£¿£¨5£©ÊDz»ÊÇÒ»¸ö±í¿Õ¼äÖ»ÄÜ´´½¨Ò»¸öÓû§£¿£¨6£©ÔõÑù´Ó¿Í»§¶Ë·ÃÎÊÊý¾Ý¿â·þÎñÆ÷µÄÅäÖã¿
¡¡¡¡
¡¡¡¡»Ø´ð£º
¡¡¡¡1¡¢ºÎÌí¼Óɾ³ýÊý¾Ý¿â£¿Ã»ÕâÖÖ¸ÅÄ²»¶®¡£
¡¡¡¡2¡¢Êý¾Ý¿â=ËùÓеÄoracleµÄÊý¾ÝÎļþ+¿ØÖÆÎļþ+ÈÕÖ¾Îļ ......

oracle supportÒ»´ÎΣ»ú´¦Àí£¨Ö®Ò»£©

ÌìÓв»²â·çÔÆ£¬
IBM µÄÖж˴ÅÅÌÕóÁÐÕâ´ÎÓÖÈÇ»öÁË¡£ÔÚ΢ÂëÉý¼¶µÄʱºò£¬
DS4800 ·¢Éú¹ÊÕÏ¡£IBM¹¤³Ìʦ°ÑÕóÁйÊÕϻָ´ºó£¬ÅÄÅÄÆ¨¹É×ßÈË£¬ÁôÏÂÁËÕóÁÐÉϲ»Ò»ÖµÄÊý¾Ý¡£
û°ì·¨£¬ÕóÁÐÉϵÄÊý¾ÝÓÖµÃÎÒÃÇÀ´Ïë°ì·¨ÇÀ¾ÈÁË¡£¡£¡£¡£
»¹ºÃÓÐoracle supportµÄÖ§³ÖÎÒÃÇ×îÖÕ»¯½âÁËÕâ´ÎΣ»ú¡£ÏÂÎÄÏêϸ½éÉÜÁËÕû¸ö»Ö¸´µÄ¹ý³Ì¡£
 
&nbs ......

oracleÖжÔÅÅÐòµÄ×ܽá

¡¡¡¡select * from perexl order by nlssort(danwei,'NLS_SORT=SCHINESE_PINYIN_M');
¡¡¡¡-- °´²¿Ê×ÅÅÐò
¡¡¡¡select * from perexl order by nlssort(danwei,'NLS_SORT=SCHINESE_STROKE_M');
¡¡¡¡-- °´±Ê»­ÅÅÐò
¡¡¡¡select * from perexl order by nlssort(danwei,'NLS_SORT=SCHINESE_RADICAL_M');
¡¡¡¡--ÅÅÐòºó»ñÈ¡µÚ ......

´«ÖDz¥¿ÍOracleÊÓÆµÑ§Ï°±Ê¼Ç

ÊÖ¶¯Æô¶¯Êý¾Ý¿â£º
    Æô¶¯¼àÌý³ÌÐò£ºlsnrctl start
    Æô¶¯Oracle·þÎñ£ºoradim -startup -sid orcl»òÕßnet start oracleserviceorcl 
    ÆäÖÐorclΪÊý¾Ý¿âµÄ·þÎñÃû»òÕßSID£¬oradim -startup -sid orclÕâ¸öÃüÁîÒÔǰ×Ô¼ºÃ»Óùý
ȨÏÞ¹ÜÀí£º
ϵͳȨÏÞ£º
create us ......

OracleÐÐתÁÐʵÀý

ѪҺÃ÷ϸ±íÈçÏ£º
create table "blood"."OC_CarryOrderD"  (
     ID                   nvarchar2(20)              &n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ