Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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¸ßˮλÏß

ʲôÊÇË®Ïß(High Water Mark)?
----------------------------
ËùÓеÄoracle¶Î(segments£¬ÔÚ´Ë£¬ÎªÁËÀí½â·½±ã£¬½¨Òé°Ñsegment×÷Ϊ±íµÄÒ»¸öͬÒå´Ê) ¶¼ÓÐÒ»¸öÔÚ¶ÎÄÚÈÝÄÉÊý¾ÝµÄÉÏÏÞ£¬ÎÒÃǰÑÕâ¸öÉÏÏÞ³ÆÎª"high water mark"»òHWM¡£Õâ¸öHWMÊÇÒ»¸ö±ê¼Ç£¬ÓÃÀ´ËµÃ÷ÒѾ­ÓжàÉÙûÓÐʹÓõÄÊý¾Ý¿é·ÖÅ䏸Õâ¸ösegment¡£HWMͨ³£Ôö³¤µÄ·ù¶ ......

ORACLE 10gÏÂÔØµØÖ·

ORACLE 10gÏÂÔØµØÖ·
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (32-bit)
http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10201/10201_client_win32.zip
http://download.oracle.co ......

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');
¡¡¡¡--ÅÅÐòºó»ñÈ¡µÚ ......

oracleÓësql server¶Ô±È·ÖÎö

±¾ÒëÎIJÉÓÃ֪ʶ¹²ÏíÊðÃû-·ÇÉÌÒµÐÔʹÓÃ-Ïàͬ·½Ê½¹²Ïí 3.0 UnportedÐí¿ÉЭÒé·¢²¼£¬×ªÔØÇë±£Áô´ËÐÅÏ¢
ÒëÕߣºÂí³ÝÜÈ | Á´½Ó£ºhttp://www.dbabeta.com/2010/oracle-sql-server-comparison-i.html
×÷ÕߣºSadequl Hussain | Ô­ÎÄ£ºhttp://www.sql-server-performance.com/articles/dba/oracle_sql_server_comparison_p1.aspx
Ò» ......

oracleÖеÄÈ«¾ÖÊý¾Ý¿âÃû³ÆºÍsidµÄÇø±ð

Êý¾Ý¿âÃû(DB_NAME)¡¢ÊµÀýÃû(Instance_name)¡¢ÒÔ¼°²Ù×÷ϵͳ»·¾³±äÁ¿(ORACLE_SID)
ÔÚORACLE7¡¢8Êý¾Ý¿âÖÐÖ»ÓÐÊý¾Ý¿âÃû(db_name)ºÍÊý¾Ý¿âʵÀýÃû(instance_name)¡£ÔÚORACLE8i¡¢9iÖгöÏÖÁËеIJÎÊý£¬¼´Êý¾Ý¿âÓòÃû(db_domain)¡¢·þÎñÃû(service_name)¡¢ÒÔ¼°²Ù×÷ϵͳ»·¾³±äÁ¿(ORACLE_SID)¡£ÕâЩ¶¼´æÔÚÓÚͬһ¸öÊý¾Ý¿âÖеıêʶ£¬ÓÃÓÚ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ