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

oracle·Ö×é rollup,Cube

CUBE ºÍ ROLLUP Ö®¼äµÄÇø±ðÔÚÓÚ£º
CUBE Éú³ÉµÄ½á¹û¼¯ÏÔʾÁËËùÑ¡ÁÐÖÐÖµµÄËùÓÐ×éºÏµÄ¾ÛºÏ¡£
ROLLUP Éú³ÉµÄ½á¹û¼¯ÏÔʾÁËËùÑ¡ÁÐÖÐÖµµÄijһ²ã´Î½á¹¹µÄ¾ÛºÏ¡£
     OracleµÄGROUP BYÓï¾ä³ýÁË×î»ù±¾µÄÓï·¨Í⣬»¹Ö§³ÖROLLUPºÍCUBEÓï¾ä¡£Èç¹ûÊÇROLLUP(A, B, C)µÄ»°£¬Ê×ÏÈ·Ö³ÉÁ½´ó²½£º£¨1£©¶ÔÓÚ·ûºÏÌõ¼þµÄÿ¸öA£¬ÏȶÔ(A¡¢B¡¢C)½øÐÐGROUP BY£¬È»ºó¶Ô(A¡¢B)½øÐÐGROUP BY£¬È»ºóÊÇ(A)½øÐÐGROUP BY£»£¨2£©¶ÔÈ«±í½øÐÐGROUP BY²Ù×÷¡£
     °´CB,GDM,CZJMͳ¼Æ
     SELECT CB,GDM,CZJM,COUNT(*)
     from LTJ_DDC
     GROUP BY ROLLUP(CB,GDM,CZJM)
   Èç¹ûÊÇGROUP BY CUBE(A, B, C)£¬(1)ÏȶÔÈ«±í½øÐÐͳ¼Æ£»£¨2£©ÔòÊ×ÏȶÔ(C)½øÐÐGROUP BY£»£¨3£©È»ºóÒÀ´ÎÊǶÔÓÚÿһ¸öB£¬ÏÈͳ¼ÆB,ÔÙͳ¼Æ£¨B,C£©£»£¨4£©¶Ôÿ¸öA£¬°´£¨A£©¡¢£¨A,C£©¡¢(A,B)¡¢£¨A,B,C£©½øÐмìË÷¡£ÊµÀýÈçÏ£º
       SELECT CB,GDM,CZJM,COUNT(*)
       from LTJ_DDC
       GROUP BY CUBE(CB,GDM,CZJM)


Ïà¹ØÎĵµ£º

APACHE PHP5 ORACLEÉèÖÃ

ÔÚwindows ÏÂÅäÖÃPHPʹÓÃORACLEÊý¾Ý¿âÒªµã
ÔÚwindowÏ£¬¾­³£ÓÃapache + PHP À´×öÓ¦ÓÃƽ̨£¬µ«ÊÇÈç¹ûʹÓÃoracle×öºǫ́Êý¾Ý¿â£¬µ«ÓÖûÓа²×°ÓÐoracle¿Í»§¶Ë£¬ÏÂÃæµÄÅäÖÿÉÒԲο¼
1¡¢ÔÚûÓа²×°oracleµÄ»úÆ÷ÉÏ£¬PHPÎÞ·¨¼ÓÔØphp_oci8.dllÄ£¿é£¬Ô­ÒòÊÇphp_oci8.dllÒÀÀµµÄÏà¹Ø×é¼þûÓÐÕÒµ½¡£
     ÄãÕýÈ·ÉèÖÃÁË ......

´´½¨ºÍɾ³ýOracleÊý¾Ý¿âÓû§¡¢±í¿Õ¼ä

1. ´´½¨ÆÕͨÓû§
  >create user username identified by username;
  >grant create tablespace, resource ,connect to username;
2. ´´½¨±í¿Õ¼äºÍÓû§
    2.1 ´´½¨ÁÙʱ±í¿Õ¼ä
  >create temporary tablespace DB_TEMP
   tempfile '/opt/oracle/oradata/mydb/t ......

Ò»¸ö¼òµ¥µÄhibernateÁ¬½ÓoracleÊý¾Ý¿âÀý×Ó£¡

Ò»¡¢ Hibernate½éÉÜ
    HibernateÊÇ»ùÓÚ¶ÔÏó/¹ØϵӳÉ䣨ORM£¬Object/Relational Mapping£©µÄÒ»¸ö½â¾ö·½°¸¡£ORM·½°¸µÄ˼ÏëÊǽ«¶ÔÏóÄ£ÐͱíʾµÄ¶ÔÏóÓ³Éäµ½¹ØϵÐÍÊý¾Ý¿âÖУ¬»òÕß·´Ö®¡£HibernateÄ¿Ç°ÊÇORM˼ÏëÔÚJavaÖÐ×î³É¹¦¡¢×îÇ¿´óµÄʵÏÖ¡£ËüÓÚ2001ÄêµÄÄêÄ©·¢²¼µÚÒ»¸ö°æ±¾£¬Á¢¼´ÒýÆðÁ˹㷺µÄ×¢Òâ¡£2003Äê6Ô£ ......

Oracle 1Z0 053 Exam

Exam Number/Code : 1Z0-053
Exam Name : Oracle Database 11g: Administration II
Questions and Answers : 167 Q&As
Update Time: 2010-05-15
1. You are not sure if Flashback Database is enabled. What database column and view can you query to
see if the flashback logs are being created in the ......

Ãâ°²×°Oracle¿Í»§¶ËÈí¼þ ʹÓÃpl/sqlÅäÖõǽ

ËäÈ»ÕâÊÇÎÒÕÒµ½×îÏêϸµÄÅäÖÃÃèÊö£¬µ«Êdz¢ÊÔ»¹ÊÇûÓгɹ¦¡£
 
1.ÏÂÔØOracle Client Package
.
´Ó
http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html
ÏÂÔØ
Instant
Client Package – Basic
°ü
(

±ê×¢
:All files
required to run OCI, OCCI, and JDBC-OC ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ