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

Oracle ROLLUPºÍCUBE Ó÷¨

ÔÚ×öÏîÄ¿¾­³£Óöµ½·Ö¿ÆÊÒ¡¢ÈËÔ±½øÐлã×ܵÄÎÊÌ⣬ÔÚORACLEÖжԴËÀàÎÊÌâµÄ´¦ÀíÏ൱·½±ã£¡ÏÂÃæÒÔÏîÄ¿ÖÐÓöµ½µÄʵÀý½øÐÐ˵Ã÷£º
²éѯÓï¾äÈçÏ£º
select f_sys_getsectnamebysectid(a.sectionid) as sectname,
        --a.sectionid,
       f_sys_employinfo_getnamebyno(a.buyerid) as name,
       sum(c.ratio) as llratio,
       sum(b.ratio) as lratio,
       sum(a.ratio) as ratio,
       sum(d.ratio) as nratio
  from (select sectionid, buyerid, ratio
          from T_PPRM_ASPPurRatio
         where year = '2008') a,
       (select buyerid, ratio from T_PPRM_ASPPurRatio where year = '2007') b,
       (select buyerid, ratio from T_PPRM_ASPPurRatio where year = '2006') c,
       (select buyerid, ratio from T_PPRM_ASPPurRatio where year = '2009') d
 where a.buyerid = b.buyerid(+)
   and b.buyerid = c.buyerid(+)
   and c.buyerid = d.buyerid(+)
 group by rollup(a.sectionid, a.buyerid)
ÏÂÃæ×ªÌû¸üÏêϸµÄ½éÉÜ£¬Ðè×ÐϸÌå»á
Oracle ROLLUPºÍCUBE Ó÷¨    
OracleµÄGROUP BYÓï¾ä³ýÁË×î»ù±¾µÄÓï·¨Í⣬»¹Ö§³ÖROLLUPºÍCUBEÓï¾ä¡£Èç¹ûÊÇROLLUP(A, B, C)µÄ»°£¬Ê×ÏÈ»á¶Ô(A¡¢B¡¢C)½øÐÐGROUP BY£¬È»ºó¶Ô(A¡¢B)½øÐÐGROUP BY£¬È»ºóÊÇ(A)½øÐÐGROUP BY£¬×îºó¶ÔÈ«±í½øÐÐGROUP BY²Ù×÷¡£Èç¹ûÊÇGROUP BY CUBE(A, B, C)£¬ÔòÊ×ÏÈ»á¶Ô(A¡¢B¡¢C)½øÐÐGROUP BY£¬È»ºóÒÀ´ÎÊÇ(A¡¢B)£¬(A¡¢C)£¬(A)£¬(B¡¢C)£¬(B)£¬(C)£¬×îºó¶ÔÈ«±í½øÐÐGROUP BY²Ù×÷¡£ grouping_id()¿ÉÒÔÃÀ»¯Ð§¹û£º
OracleµÄGROUP BYÓï¾ä³ýÁË×î»ù±¾µÄÓï·¨Í⣬»¹Ö§³ÖROLLUPºÍCUBEÓï¾ä¡£
³ý±¾ÎÄÄÚÈÝÍ⣬Ä㻹¿É²Î¿¼£º
·ÖÎöº¯Êý²Î¿¼Êֲ᣺ http://xsb.itpub.net/post/419/33028
·ÖÎöº¯ÊýʹÓÃÀý×Ó½éÉÜ£ºhttp://xsb.itpub.net/post/419/44634
SQL> create table t as select * from dba_indexes;
±


Ïà¹ØÎĵµ£º

oracleÌåϵ½á¹¹ÉîÈëѧϰBuffer Cache

oracleÌåϵ½á¹¹ÉîÈëѧϰBuffer Cache - Overview
oracle 2009-09-02 23:13:26 ÔĶÁ40 ÆÀÂÛ0 ×ֺţº´óÖÐС
ÌÎÌÎÉîÈëѧϰoracleÌåϵ½á¹¹
ÎÒ·¢¾õ£¬Ó¢ÎĵÄһЩ¼¼ÊõÎÄÕÂÔÚÃèÊöoracleÔ­Àí·Ç³£µÄÇ¡µ±µ½Î»£¬±í´ïµÄ·Ç³£µÄÃÀ£¬ºÇºÇ¡£Ó¢ÎIJ»ºÃ£¬Ï׳ó·­Ò벢ѧϰÁË£¬ÈÏÕæ¿´ÁË£¬ÏàÐÅÄãÊÜÒæ·Ëdz¡£
oracleÌåϵ½á¹¹Ö®£ºBuffer Cache - O ......

oracle Ïà關µÄsql語¾ä

Êý¾Ý×Öµädict×ÜÊÇÊôÓÚOracleÓû§sysµÄ¡£
¡¡¡¡1¡¢Óû§£º
¡¡¡¡¡¡select username from dba_users;
¡¡¡¡¸Ä¿ÚÁî
¡¡¡¡¡¡alter user spgroup identified by spgtest;
¡¡¡¡2¡¢±í¿Õ¼ä£º
¡¡¡¡¡¡select * from dba_data_files;
¡¡¡¡¡¡select * from dba_tablespaces;//±í¿Õ¼ä
¡¡¡¡¡¡select tablespace_name,sum(bytes), sum(b ......

oracleÖ´Ðмƻ®µÄһЩ¸ÅÄî

oracleÖ´Ðмƻ®µÄһЩ¸ÅÄî(»ù´¡µÄ¼ÇÒä) 
¿ªÊ¼Ñ§Ï°ORACLEÓï¾äÓÅ»¯,´ÓÖ´Ðмƻ®¿ªÊ¼,ÏÈÊìϤÕâЩÃû´ÊÒÔ¼°»ù±¾º¬Òå,¼ÇÒäÔÚÎÒÄÔ×ÓÀï,2010-04-10
Rowid£ºÏµÍ³¸øoracleÊý¾ÝµÄÿÐи½¼ÓµÄÒ»¸öαÁУ¬°üº¬Êý¾Ý±íÃû³Æ£¬Êý¾Ý¿âid£¬´æ´¢Êý¾Ý¿âidÒÔ¼°Ò»¸öÁ÷Ë®ºÅµÈÐÅÏ¢£¬rowidÔÚÐеÄÉúÃüÖÜÆÚÄÚΨһ¡£
Recursive sql£ºÎªÁËÖ´ÐÐÓû§Óï¾ ......

ʹÓÃOracleÊý¾Ý¿â¹ý³ÌÖг£¼û´íÎó

1¡¢ORA£­12541£ºTNS£ºÃ»ÓмàÌýÆ÷ ¡¡¡¡
     Ô­Òò£ºÃ»ÓÐÆô¶¯¼àÌýÆ÷»òÕß¼àÌýÆ÷Ë𻵡£Èç¹ûÊÇǰÕߣ¬Ê¹ÓÃÃüÁînet start OracleOraHome81TNSListener£¨Ãû×Ö¿ÉÄÜÓгöÈ룩¼´¿É£»Èç¹ûÊǺóÕߣ¬ÔòʹÓÓNet8 Configuration Assistant”¹¤¾ßÏòµ¼Ö®“¼àÌý³ÌÐòÅäÖÔÔö¼ÓÒ»¸ö¼àÌýÆ÷¼´¿É£¨»ù±¾²» ......

Oracle Tuning

¡¡     ¹ØÓÚOracleµÄÐÔÄܵ÷Õû£¬Ò»°ã°üÀ¨Á½¸ö·½Ã棬һÊÇÖ¸OracleÊý¾Ý¿â±¾ÉíµÄµ÷Õû£¬±ÈÈçSGA¡¢PGAµÄÓÅ»¯ÉèÖ㬶þÊÇÁ¬½ÓOracleµÄÓ¦ÓóÌÐòÒÔ¼°SQLÓï¾äµÄÓÅ»¯¡£×öºÃÕâÁ½¸ö·½ÃæµÄÓÅ»¯£¬¾Í¿ÉÒÔʹһÌ×ÍêÕûµÄOracleÓ¦ÓÃϵͳ´¦ÓÚÁ¼ºÃµÄÔËÐÐ״̬¡£
¡¡¡¡ ±¾ÎÄÖ÷ÒªÊǰÑһЩOracle TuningµÄÎÄÕÂ×÷ÁËÒ»¸ö¼òµ¥µÄ×ܽᣬ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ