| ²é¿´: 896 | »Ø¸´: 2 | |||
zyj8119ľ³æ (ÖøÃûдÊÖ)
|
[½»Á÷]
¡¾×ªÌû¡¿OracleÊý¾Ý¿âÖÐÐòÁÐÓ÷¨½²½â ÒÑÓÐ2È˲ÎÓë
|
|
ÐòÁÐ(SEQUENCE)ÊÇÐòÁкÅÉú³ÉÆ÷£¬¿ÉÒÔΪ±íÖеÄÐÐ×Ô¶¯Éú³ÉÐòÁкţ¬²úÉúÒ»×éµÈ¼ä¸ôµÄÊýÖµ(ÀàÐÍΪÊý×Ö)¡£ÆäÖ÷ÒªµÄÓÃ;ÊÇÉú³É±íµÄÖ÷¼üÖµ£¬¿ÉÒÔÔÚ²åÈëÓï¾äÖÐÒýÓã¬Ò²¿ÉÒÔͨ¹ý²éѯ¼ì²éµ±Ç°Öµ£¬»òʹÐòÁÐÔöÖÁÏÂÒ»¸öÖµ¡£ ´´½¨ÐòÁÐÐèÒªCREATE SEQUENCEϵͳȨÏÞ¡£ÐòÁеĴ´½¨Óï·¨ÈçÏ£º Sql´úÂë CREATE SEQUENCE ÐòÁÐÃû [INCREMENT BY n] [START WITH n] [{MAXVALUE/ MINVALUE n|NOMAXVALUE}] [{CYCLE|NOCYCLE}] [{CACHE n|NOCACHE}]; INCREMENT BY ÓÃÓÚ¶¨ÒåÐòÁеIJ½³¤£¬Èç¹ûÊ¡ÂÔ£¬ÔòĬÈÏΪ1£¬Èç¹û³öÏÖ¸ºÖµ£¬Ôò´ú±íÐòÁеÄÖµÊǰ´Õմ˲½³¤µÝ¼õµÄ¡£ START WITH ¶¨ÒåÐòÁеijõʼֵ(¼´²úÉúµÄµÚÒ»¸öÖµ)£¬Ä¬ÈÏΪ1¡£ MAXVALUE ¶¨ÒåÐòÁÐÉú³ÉÆ÷ÄܲúÉúµÄ×î´óÖµ¡£Ñ¡ÏîNOMAXVALUEÊÇĬÈÏÑ¡Ï´ú±íûÓÐ×î´óÖµ¶¨Ò壬Õâʱ¶ÔÓÚµÝÔöÐòÁУ¬ÏµÍ³Äܹ»²úÉúµÄ×î´óÖµÊÇ10µÄ27´Î·½;¶ÔÓڵݼõÐòÁУ¬×î´óÖµÊÇ-1¡£ MINVALUE¶¨ÒåÐòÁÐÉú³ÉÆ÷ÄܲúÉúµÄ×îСֵ¡£Ñ¡ÏîNOMAXVALUEÊÇĬÈÏÑ¡Ï´ú±íûÓÐ×îСֵ¶¨Ò壬Õâʱ¶ÔÓڵݼõÐòÁУ¬ÏµÍ³Äܹ»²úÉúµÄ×îСֵÊÇ?10µÄ26´Î·½;¶ÔÓÚµÝÔöÐòÁУ¬×îСֵÊÇ1¡£ CYCLEºÍNOCYCLE ±íʾµ±ÐòÁÐÉú³ÉÆ÷µÄÖµ´ïµ½ÏÞÖÆÖµºóÊÇ·ñÑ»·¡£CYCLE´ú±íÑ»·£¬NOCYCLE´ú±í²»Ñ»·¡£Èç¹ûÑ»·£¬Ôòµ±µÝÔöÐòÁдﵽ×î´óֵʱ£¬Ñ»·µ½×îСֵ;¶ÔÓڵݼõÐòÁдﵽ×îСֵʱ£¬Ñ»·µ½×î´óÖµ¡£Èç¹û²»Ñ»·£¬´ïµ½ÏÞÖÆÖµºó£¬¼ÌÐø²úÉúÐÂÖµ¾Í»á·¢Éú´íÎó¡£ CACHE(»º³å)¶¨Òå´æ·ÅÐòÁеÄÄÚ´æ¿éµÄ´óС£¬Ä¬ÈÏΪ20¡£NOCACHE±íʾ²»¶ÔÐòÁнøÐÐÄڴ滺³å¡£¶ÔÐòÁнøÐÐÄڴ滺³å£¬¿ÉÒÔ¸ÄÉÆÐòÁеÄÐÔÄÜ¡£ ɾ³ýÐòÁеÄÓï·¨ÊÇ£º Sql´úÂë DROP SEQUENCE ÐòÁÐÃû; ÆäÖУº ɾ³ýÐòÁеÄÈËÓ¦¸ÃÊÇÐòÁеĴ´½¨Õß»òÓµÓÐDROP ANY SEQUENCEϵͳȨÏÞµÄÓû§¡£ÐòÁÐÒ»µ©É¾³ý¾Í²»Äܱ»ÒýÓÃÁË¡£ ÐòÁеÄijЩ²¿·ÖÒ²¿ÉÒÔÔÚʹÓÃÖнøÐÐÐ޸쬵«²»ÄÜÐÞ¸ÄSATRT WITHÑ¡Ïî¡£¶ÔÐòÁеÄÐÞ¸ÄÖ»Ó°ÏìËæºó²úÉúµÄÐòºÅ£¬ÒѾ²úÉúµÄÐòºÅ²»±ä¡£ÐÞ¸ÄÐòÁеÄÓï·¨ÈçÏ£º ´´½¨ºÍɾ³ýÐòÁÐ Àý1£º´´½¨ÐòÁУº CREATE SEQUENCE ABC INCREMENT BY 1 START WITH 10 MAXVALUE 9999999 NOCYCLE NOCACHE; Ö´Ðнá¹û ÐòÁÐÒÑ´´½¨¡£ ²½Öè2£ºÉ¾³ýÐòÁУº DROP SEQUENCE ABC; Ö´Ðнá¹û£º ÐòÁÐÒѶªÆú¡£ ˵Ã÷£ºÒÔÉÏ´´½¨µÄÐòÁÐÃûΪABC£¬ÊǵÝÔöÐòÁУ¬ÔöÁ¿Îª1£¬³õʼֵΪ10¡£¸ÃÐòÁв»Ñ»·£¬²»Ê¹ÓÃÄڴ档ûÓж¨Òå×îСֵ£¬Ä¬ÈÏ×îСֵΪ1£¬×î´óֵΪ9 999 999¡£ ÐòÁеÄʹÓà Èç¹ûÒѾ´´½¨ÁËÐòÁУ¬ÔõÑù²ÅÄÜÒýÓÃÐòÁÐÄØ?·½·¨ÊÇʹÓÃCURRVALºÍNEXTVALÀ´ÒýÓÃÐòÁеÄÖµ¡£ ÔÚ±àºÅµÄ¹ý³ÌÖУ¬²úÉú¼ä϶µÄÔÒò¶àÖÖ¶àÑù¡£Èç¹ûÒ»¸ö´æ´¢¹ý³Ì´ÓÒ»¸öÐòÁÐÖÐÌôѡij¸öÊý×Ö£¬¶¨Îª±¾µØ±äÁ¿£¬µ«ÊÇ´ÓÀ´²»ÓÃËü£¬Õâ¸öÊý×־ͶªÊ§ÁË¡£Ëü½«²»ÄÜÔÙ·µ»Øµ½ÔÐòÁÐÖУ¬½á¹û¾ÍÔì³ÉÊýÖµÐòÁÐÖдæÔÚÒ»¸ö¼ä϶¡£¹ØÏµÐÍÊý¾Ý¿âÄ£ÐÍÖв»±Øµ£ÐÄÕâÒ»µã¡£µ«ÊÇÓÐʱºòÈËÃÇÔÚÒâÕâÒ»µã£¬ÕâЩÈËÏëÖªµÀÊÇÄÄЩÊý×Ö¶ªÊ§ÁË¡£ µ÷ÓÃNEXTVAL½«Éú³ÉÐòÁÐÖеÄÏÂÒ»¸öÐòÁкţ¬µ÷ÓÃʱҪָ³öÐòÁÐÃû£¬¼´ÓÃÒÔÏ·½Ê½µ÷ÓÃ: ÐòÁÐÃû.NEXTVAL CURRVALÓÃÓÚ²úÉúÐòÁеĵ±Ç°Öµ£¬ÎÞÂÛµ÷ÓöàÉٴζ¼²»»á²úÉúÐòÁеÄÏÂÒ»¸öÖµ¡£Èç¹ûÐòÁл¹Ã»ÓÐͨ¹ýµ÷ÓÃNEXTVAL²úÉú¹ýÐòÁеÄÏÂÒ»¸öÖµ£¬ÏÈÒýÓÃCURRVALûÓÐÒâÒå¡£µ÷ÓÃCURRVALµÄ·½·¨Í¬ÉÏ£¬ÒªÖ¸³öÐòÁÐÃû£¬¼´ÓÃÒÔÏ·½Ê½µ÷ÓÃ: ÐòÁÐÃû.CURRVAL. ²úÉúÐòÁеÄÖµ¡£ ²½Öè1£º²úÉúÐòÁеĵÚÒ»¸öÖµ£º SELECT ABC.NEXTVAL FROM DUAL; Ö´Ðнá¹û£º Sql´úÂë NEXTVAL ------------------ 10 ²½Öè2£º²úÉúÐòÁеÄÏÂÒ»¸öÖµ£º SELECT ABC.NEXTVAL FROM DUAL; Ö´Ðнá¹û£º Sql´úÂë NEXTVAL ------------------- 11 ²úÉúÐòÁеĵ±Ç°Öµ£º SELECT ABC.CURRVAL FROM DUAL; Ö´Ðнá¹û£º Sql´úÂë CURRVAL -------------------- 11 ˵Ã÷£ºµÚÒ»´Îµ÷ÓÃNEXTVAL²úÉúÐòÁеijõʼֵ£¬¸ù¾Ý¶¨ÒåÖªµÀ³õʼֵΪ10¡£µÚ¶þ´Îµ÷ÓòúÉú11£¬ÒòΪÐòÁеIJ½³¤Îª1¡£µ÷ÓÃCURRVAL£¬ÏÔʾµ±Ç°Öµ11£¬²»²úÉúÐÂÖµ¡£OracleµÄ½âÎöº¯ÊýΪ¼ì²é¼ä϶ÌṩÁËÒ»ÖÖÒª¿ì½ÝµÃ¶àµÄ·½·¨¡£ËüÃÇʹÄãÔÚʹÓÃÍêÕûµÄ¡¢ÃæÏò¼¯ºÏµÄSQL´¦ÀíµÄͬʱ£¬ÈÔÈ»Äܹ»¿´µ½ÏÂÒ»¸öÐÐ(LEAD)»òÕßǰһÐÐ(LAG)µÄÊýÖµ¡£ ²é¿´ÐòÁРͬ¹ýÊý¾Ý×ÖµäUSER_OBJECTS¿ÉÒԲ鿴Óû§ÓµÓеÄÐòÁС£ ͨ¹ýÊý¾Ý×ÖµäUSER_SEQUENCES¿ÉÒԲ鿴ÐòÁеÄÉèÖᣠÀý£º²é¿´Óû§µÄÐòÁУº Sql´úÂë SELECT SEQUENCE_NAME,MIN_VALUE,MAX_VALUE,INCREMENT_BY,LAST_NUMBER FROM USER_SEQUENCES; Ö´Ðнá¹û£º SEQUENCE_NAME MIN_VALUE MAX_VALUE INCREMENT_BY LAST_NUMBER ˵Ã÷£ºµ±Ç°Óû§ÓµÓÐÁ½¸öÐòÁУºABCºÍBOOKID¡£ |
» ²ÂÄãϲ»¶
ÊÛSCIÒ»ÇøÎÄÕ£¬ÎÒ:8 O5 51O 54,¿ÆÄ¿ÆëÈ«,¿É+¼±
ÒѾÓÐ8È˻ظ´
ÌåÖÆÄÚ³¤±²ËµÌåÖÆÄÚ¾ø´ó²¿·ÖÒ»±²×ÓÔڵײ㣬ÈçͬÄãÃÇÒ»Ñù´ó²¿·ÖÆÕͨ½ÌʦæÇÒÊÕÈëµÍ
ÒѾÓÐ13È˻ظ´
ÊÛSCIÒ»ÇøÎÄÕ£¬ÎÒ:8 O5 51O 54,¿ÆÄ¿ÆëÈ«,¿É+¼±
ÒѾÓÐ8È˻ظ´
ÊÛSCIÒ»ÇøÎÄÕ£¬ÎÒ:8 O5 51O 54,¿ÆÄ¿ÆëÈ«,¿É+¼±
ÒѾÓÐ8È˻ظ´
ÊÛSCIÒ»ÇøÎÄÕ£¬ÎÒ:8 O5 51O 54,¿ÆÄ¿ÆëÈ«,¿É+¼±
ÒѾÓÐ11È˻ظ´
ΪʲôÖйú´óѧ¹¤¿Æ½ÌÊÚÃÇË®ÁËÄÇô¶àËùνµÄ¶¥»á¶¥¿¯£¬µ«»¹ÊÇ×ö²»³öÓîÊ÷»úÆ÷ÈË£¿
ÒѾÓÐ8È˻ظ´
ÊÛSCIÒ»ÇøÎÄÕ£¬ÎÒ:8 O5 51O 54,¿ÆÄ¿ÆëÈ«,¿É+¼±
ÒѾÓÐ5È˻ظ´
ÊÛSCIÒ»ÇøÎÄÕ£¬ÎÒ:8 O5 51O 54,¿ÆÄ¿ÆëÈ«,¿É+¼±
ÒѾÓÐ6È˻ظ´
ÊÛSCIÒ»ÇøÎÄÕ£¬ÎÒ:8 O5 51O 54,¿ÆÄ¿ÆëÈ«,¿É+¼±
ÒѾÓÐ9È˻ظ´
ÊÛSCIÒ»ÇøÎÄÕ£¬ÎÒ:8 O5 51O 54,¿ÆÄ¿ÆëÈ«,¿É+¼±
ÒѾÓÐ4È˻ظ´
» ±¾Ö÷ÌâÏà¹Ø¼ÛÖµÌùÍÆ¼ö£¬¶ÔÄúͬÑùÓаïÖú:
¡¾ÇóÖú/½»Á÷¡¿ÖؽðÐüÉÍRibosomal Database Project£¨RDP£©Õâ¸öÊý¾Ý¿âµÄÓ÷¨£¬½±50½ð±Ò
ÒѾÓÐ4È˻ظ´
¡¾ÇóÖú¡¿MCIµÄÓ÷¨¼°ÆäÔÙÉú
ÒѾÓÐ19È˻ظ´

HowToSignUp
Òø³æ (³õÈëÎÄ̳)
- Ó¦Öú: 0 (Ó×¶ùÔ°)
- ½ð±Ò: 385.6
- ºì»¨: 1
- Ìû×Ó: 24
- ÔÚÏß: 8.4Сʱ
- ³æºÅ: 1486129
- ×¢²á: 2011-11-10
- רҵ: ¼ÆËã»úÈí¼þ
2Â¥2012-12-09 18:02:41
jackenjun
Òø³æ (³õÈëÎÄ̳)
- Ó¦Öú: 0 (Ó×¶ùÔ°)
- ½ð±Ò: 261.5
- Ìû×Ó: 17
- ÔÚÏß: 3.9Сʱ
- ³æºÅ: 1297568
- ×¢²á: 2011-05-16
- ÐÔ±ð: GG
- רҵ: ¼ÆËã»úÈí¼þ

3Â¥2013-05-18 19:36:06













»Ø¸´´ËÂ¥
ºÃºÃѧϰ£¬ÌìÌìÏòÉÏ¡£