Oracle Êý¾Ý¿âµÄ°²×°
×°ÁËÒ»Ò¹µÄÈí¼þ£¬ÏÈÊÇMySQL£¬myEclipse,Oracle ,²»¶ÏµÄ³ö´í£¬OracleServise²»ÄÜÆô¶¯£¬ºÜÊÇ·³ÈË£¬Ð¶ÔØÁËOracelÁ½´Î£¬ÓÖ֨װ£¬´íÎóµÃµ½Ò»Ð©½â¾ö£¬×¢²á±í³öÏÖÁ˺öàµÄÎÊÌ⣬ÒÔǰÔÚÐ¶ÔØÈí¼þµÄʱºò£¬¶¼Ã»ÓÐÓÃרÓõŤ¾ß£¬×¢²á±íÒ»ÍÅÂÒ£¬ÕæÊÇÏ൱µÄºó»Ú£¬ÏÖÔÚ¿´À´ÒªÏë¸Ä¹ýÀ´È·ÊµÊǺÜÄѵÄÀ²£¡ÒÔºóÕâ·½ÃæÒª¶à¼ÓµÄ×¢Òâ¿©¡£
ÏÖÔÚÖÕÓڴ󹦸æ³É£¬ºÃÏë¿Þ£¡ ÕâÊÇÎÒµÚÒ»´ÎÕâÑùÏàÐÅ×Ô¼º£¬Ð»Ð»ÍøÓѵÄһЩ°ï£¬http://blog.csdn.net/xiaoyao6650/archive/2009/03/15/3989484.aspx£¬½ñÌìÓÖ×°ÁËVS2008£¬ÀÏÊÇÌø³öWEB×é¼þ°²×°Ê§°Ü£¬ÆøËÀÁË£¬
ÏÖÔÚÖÕÓÚ¸ãºÃÁË£¬ÔÀ´ÊÇoffice_zh-cnµÄÎÊÌ⣬ÖÕÓڵõ½Á˽â¾ö¡£
ÖÐÎç·¸Á˸ö´íÎó£¬ÌýÐÅÍøÓѵķ½·¨£¬ÐÞ¸ÄÁËÓû§µÄÕË»§£¬×îºó½øÈëF8²ÅµÃ½â¾ö£¬¿´À´µÃ×Ô¼º¶à¶¯¶¯ÄÔ×Óȥ˼¿¼°¡£¡
¾ÀúÁËÕâЩÊÂÇ飬¸ü¼Ó¼á¶¨ÁË×Ô¼ºÒª×ߵķ£¬Chang,ÎÒÃÇÒ»ÆðŬÁ¦°É£¡ÏàÐÅ£¬ÎÒÏàÐÅÎÒÐеģ¬ÄãÒ²Ò»¶¨»áµÄ£¬²»ÊǵÄô£¬MyLove !
Ïà¹ØÎĵµ£º
Àí½âoracleÖÐÁ¬½ÓºÍ»á»° 1. ¸ÅÄͬ£º¸ÅÄͬ£º
Á¬½ÓÊÇÖ¸ÎïÀíµÄÍøÂçÁ¬½Ó¡£
ÔÚÒѽ¨Á¢µÄÁ¬½ÓÉÏ£¬½¨Á¢¿Í»§¶ËÓëoracleµÄ»á»°£¬ÒÔºó¿Í»§¶ËÓëoracleµÄ½»»¥¶¼ÔÚÒ»¸ö»á»°»·¾³ÖнøÐС£
2. ¹ØÏµÊǶà¶Ô¶à£º
Ò»¸öÁ¬½ÓÉÏ¿ÉÒÔ½¨Á¢0¸ö£¬1¸ö£¬2¸ö£¬¶à¸ö»á»°¡£
OracleÔÊÐí´æÔÚÕâÑùµÄ»á»°£¬¾ÍÊÇʧȥÁËÎïÀíÁ¬½ÓµÄ»á»°¡£
3. ¸ÅÄîÓ¦Ó㺸 ......
Oracle group by¼°ÆäÈô¸ÉÏà¹Øº¯ÊýµÄһЩ˵Ã÷
http://blog.csdn.net/roland_wg/archive/2009/07/03/4319323.aspx
OracleµÄgroup by³ýÁË»ù±¾Ó÷¨ÒÔÍ⣬»¹ÓÐ3ÖÖÀ©Õ¹Ó÷¨£¬·Ö±ðÊÇrollup¡¢cube¡¢grouping sets¡£
¼ÙÉèÓÐÒ»¸ö±ítest£¬ÓÐA¡¢B¡¢C¡¢D¡¢E5ÁС£
1£© Èç¹ûʹÓÃgroup by rollup(A,B,C)£¬Ê×ÏÈ»á¶Ô(A¡¢B¡¢C)½øÐÐGROUP BY ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ ......