oracle10G·ÖÇøµÄ´´½¨Óëά»¤Oracle·ÖÇø±íºÍ±¾µØË÷Òý
¡¡¡¡OracleµÄ·ÖÇø¼¼ÊõÔÚijЩÌõ¼þÏ¿ÉÒÔ¼«´óµÄÌá¸ß²éѯµÄÐÔÄÜ£¬ËùÒÔ±»¹ã·º²ÉÓᣴӲúÆ·ÉÏ˵£¬·ÖÇø¼¼ÊõÊÇOracleÆóÒµ°æÖжÀÁ¢ÊշѵÄÒ»¸ö×é¼þ¡£ÒÔÏÂÊǶÔÓÚ·ÖÇø¼°±¾µØË÷ÒýµÄÒ»¸öʾÀý¡£
¡¡¡¡OracleµÄ·ÖÇø¼¼ÊõÔÚijЩÌõ¼þÏ¿ÉÒÔ¼«´óµÄÌá¸ß²éѯµÄÐÔÄÜ£¬ËùÒÔ±»¹ã·º²ÉÓᣴӲúÆ·ÉÏ˵£¬·ÖÇø¼¼ÊõÊÇOracleÆóÒµ°æÖжÀÁ¢ÊշѵÄÒ»¸ö×é¼þ¡£ÒÔÏÂÊǶÔÓÚ·ÖÇø¼°±¾µØË÷ÒýµÄÒ»¸öʾÀý¡£
¡¡¡¡Ê×Ïȸù¾Ý×Öµä±í´´½¨Ò»¸ö²âÊÔ·ÖÇø±í£º
SQL> connect eygle/eygle
¡¡¡¡Connected.
¡¡¡¡SQL> CREATE TABLE dbobjs
¡¡¡¡2 (OBJECT_ID NUMBER NOT NULL,
¡¡¡¡3 OBJECT_NAME varchar2(128),
¡¡¡¡4 CREATED DATE NOT NULL
¡¡¡¡5 )
¡¡¡¡6 PARTITION BY RANGE (CREATED)
¡¡¡¡7 (PARTITION dbobjs_06 VALUES LESS THAN (TO_DATE('01/01/2007', 'DD/MM/YYYY')),
¡¡¡¡8 PARTITION dbobjs_07 VALUES LESS THAN (TO_DATE('01/01/2008', 'DD/MM/YYYY')));
¡¡¡¡Table created.
¡¡¡¡SQL> COL segment_name for a20
¡¡¡¡SQL> COL PARTITION_NAME for a20
¡¡¡¡SQL> SELECT segment_name, partition_name, tablespace_name
¡¡¡¡2 from dba_segments
¡¡¡¡3 WHERE segment_name = 'DBOBJS';
¡¡¡¡SEGMENT_NAME PARTITION_NAME TABLESPACE_NAME
¡¡¡¡-------------------- -------------------- ------------------------------
¡¡¡¡DBOBJS DBOBJS_06 EYGLE
¡¡¡¡DBOBJS DBOBJS_07 EYGLE
¡¡¡¡´´½¨Ò»¸öLocalË÷Òý£¬×¢ÒâÕâÀï¿ÉÒÔ½«²»Í¬·ÖÇøµÄË÷ÒýÖ¸¶¨´´½¨µ½²»Í¬µÄ±í¿Õ¼ä£º
SQL> CREATE INDEX dbobjs_idx ON dbobjs (created) LOCAL
¡¡¡¡2 (PARTITION dbobjs_06 TABLESPACE users,
¡¡¡¡3 PARTITION dbobjs_07 TABLESPACE users
¡¡¡¡4 );&nbs
Ïà¹ØÎĵµ£º
GROUPINGº¯Êý¿ÉÒÔ½ÓÊÜÒ»ÁУ¬·µ»Ø0»òÕß1¡£Èç¹ûÁÐֵΪ¿Õ£¬ÄÇôGROUPING()·µ»Ø1£»Èç¹ûÁÐÖµ·Ç¿Õ£¬ÄÇô·µ»Ø0¡£GROUPINGÖ»ÄÜÔÚʹÓÃROLLUP»òCUBEµÄ²éѯÖÐʹÓᣵ±ÐèÒªÔÚ·µ»Ø¿ÕÖµµÄµØ·½ÏÔʾij¸öֵʱ£¬GROUPING()¾Í·Ç³£ÓÐÓá£
¹ØÓÚROLLUPºÍCUBEº¯ÊýµÄʹÓã¬Çë²Î¼ûÎÒµÄÁíһƪÎÄÕ¡£
http://blog.csdn.net/wh62592855/archive/2009/1 ......
¿ÉÒÔʹÓÃGROUPING_IDº¯Êý½èÖúHAVING×Ó¾ä¶Ô¼Ç¼½øÐйýÂË£¬½«²»°üº¬Ð¡¼Æ»òÕß×ܼƵļǼ³ýÈ¥¡£GROUPING_ID()º¯Êý¿ÉÒÔ½ÓÊÜÒ»Áлò¶àÁУ¬·µ»ØGROUPINGλÏòÁ¿µÄÊ®½øÖÆÖµ¡£GROUPINGλÏòÁ¿µÄ¼ÆËã·½·¨Êǽ«°´ÕÕ˳Ðò¶ÔÿһÁе÷ÓÃGROUPINGº¯ÊýµÄ½á¹û×éºÏÆðÀ´¡£
¹ØÓÚGROUPINGº¯ÊýµÄʹÓ÷½·¨¿ÉÒԲμûÎÒÇ°ÃæдµÄһƪÎÄÕÂ
http://blog.csdn ......
ÏÂÎçÈ¥²Î¼ÓÒ»¸öOracleÓйغ£Á¿Êý¾Ý´æ´¢¼¼ÊõµÄÅàѵ½²×ùÁË¡£
µØÖ·ÔÚ¹ãÖÝÊÐÁÖºÍÎ÷·101ºÅÌìºÓÇø¼Æ¾´óÂ¥Î÷²àÈýÂ¥¡£
Åàѵ·¢Æð»ú¹¹Îª£º¹ãÖÝÖÐî£ÐÅÏ¢¼¼ÊõÓÐÏÞ¹«Ë¾¡£
ÏÂÃæ¾Í¼òÒª×ܽáÒ»ÏÂËùÌýµ½µÄһЩ¶«Î÷£¬Ò²ËãÊÇѧµ½µÄÕâЩ¼¼Êõ¡£²»¹ýÓеĶ«Î÷²»ÖªµÀ×ܽáµÄ¶Ô²»¶Ô£¬ÔÝÇÒàñàðÍÌÔæ°É¡£
OracleµÄ´æ´¢¼¼Êõ
´óÌåÉÏ· ......
OracleûÓÐ×Ô¶¯Ôö³¤µÄÊý¾ÝÀàÐÍ£¬ÎÒÃÇÐèÒª½¨Á¢Ò»¸ö×Ô¶¯Ôö³¤µÄÐòÁкţ¬²åÈë¼Ç¼ʱҪ°ÑÐòÁкŵÄÏÂÒ»¸öÖµ¸³ÓÚ´Ë×ֶΣ¡
create sequence type_id increment by 1 start with 1;
Õâ¾äÖУ¬type_idΪÐòÁкŵÄÃû³Æ£¬Ã¿´ÎÔö³¤Îª1£¬ÆðʼÐòºÅΪ1¡£
Èç¹ûҪɾ³ýÐòÁУ¬ÓÃdrop sequence ÐòÁÐÃû¾Í¿ÉÒÔÁË£¡£¡
ÐòÁпÉÒÔ±£Ö¤¶à¸öÓû§¶ÔÍ¬Ò»Õ ......