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

Oracle Sequence Ïà¹ØÖªÊ¶

Ò»£¬¼òµ¥½éÉÜ
    ÔÚoracleÖÐsequence¾ÍÊÇËùνµÄÐòÁкţ¬Ã¿´ÎÈ¡µÄʱºòËü»á×Ô¶¯Ôö¼Ó£¬Ò»°ãÓÃÔÚÐèÒª°´
ÐòÁкÅÅÅÐòµÄµØ·½¡£
1¡¢ create sequence
    ÄãÊ×ÏÈÒªÓÐcreate sequence»òÕßcreate any sequenceȨÏÞ£¬
    create sequence emp_sequence
        INCREMENT BY 1  -- ÿ´Î¼Ó¼¸¸ö
        START WITH 1       -- ´Ó1¿ªÊ¼¼ÆÊý
        NOMAXVALUE       -- ²»ÉèÖÃ×î´óÖµ
        NOCYCLE              -- Ò»Ö±ÀÛ¼Ó£¬²»Ñ­»·
        CACHE 10;             --Ô¤·ÖÅ仺´æ´óСΪ10
    Ò»µ©¶¨ÒåÁËemp_sequence£¬Äã¾Í¿ÉÒÔÓÃCURRVAL£¬NEXTVAL
    CURRVAL=·µ»ØsequenceµÄµ±Ç°Öµ
    NEXTVAL=Ôö¼ÓsequenceµÄÖµ£¬È»ºó·µ»ØsequenceÖµ
    ±ÈÈ磺
        emp_sequence.CURRVAL
        emp_sequence.NEXTVAL
    ¿ÉÒÔʹÓÃsequenceµÄµØ·½£º
        - ²»°üº¬×Ó²éѯ¡¢snapshot¡¢VIEWµÄ SELECT Óï¾ä
        - INSERTÓï¾äµÄ×Ó²éѯÖÐ
        - NSERTÓï¾äµÄVALUESÖÐ
        - UPDATE µÄ SETÖÐ
    ¿ÉÒÔ¿´ÈçÏÂÀý×Ó£º
    INSERT INTO emp VALUES
    (empseq.nextval, 'LEWIS', 'CLERK',7902, SYSDATE, 1200, NULL, 20);
    SELECT empseq.currval from DUAL;
    µ«ÊÇҪעÒâµÄÊÇ£º
    -  µÚÒ»´ÎNEXTVAL·µ»ØµÄÊdzõʼֵ£»ËæºóµÄNEXTVAL»á×Ô¶¯Ôö¼ÓÄ㶨ÒåµÄINCREMENT BYÖµ£¬
       È»ºó·µ»ØÔö¼ÓºóµÄÖµ¡£CURRVAL ×ÜÊÇ·µ»Øµ±Ç°sequenceµÄÖµ£¬µ«


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

Oracle±¸·ÝÓë»Ö¸´°¸Àý

Ò». Àí½âʲôÊÇÊý¾Ý¿â»Ö¸´
  µ±ÎÒÃÇʹÓÃÒ»¸öÊý¾Ý¿âʱ£¬×ÜÏ£ÍûÊý¾Ý¿âµÄÄÚÈÝÊǿɿ¿µÄ¡¢ÕýÈ·µÄ£¬µ«ÓÉÓÚ¼ÆËã»úϵͳµÄ¹ÊÕÏ£¨Ó²¼þ¹ÊÕÏ¡¢Èí¼þ¹ÊÕÏ¡¢ÍøÂç¹ÊÕÏ¡¢½ø³Ì¹ÊÕϺÍϵͳ¹ÊÕÏ£©Ó°ÏìÊý¾Ý¿âϵͳµÄ²Ù×÷£¬Ó°ÏìÊý¾Ý¿âÖÐÊý¾ÝµÄÕýÈ·ÐÔ£¬ÉõÖÁÆÆ»µÊý¾Ý¿â£¬Ê¹Êý¾Ý¿âÖÐÈ«²¿»ò²¿·ÖÊý¾Ý¶ªÊ§¡£Òò´Ëµ±·¢ÉúÉÏÊö¹ÊÕϺó£¬Ï£ÍûÄÜÖØ¹¹Õâ¸öÍêÕ ......

Oracle 92ºÍOracle10gÏÂÔØµØÖ·

Oracle 9iÆóÒµ°æ¹Ù·½ÏÂÔØ9.2.0.1.0
¼òµ¥ÃèÊö£º oracleµÄ¹Ù·½ÍøÕ¾£ºwww.oracle.com ÕâÀïÓÐoracleµÄ¸÷ÖÖ°æ±¾µÄÊý¾Ý¿â¡¢Ó¦Óù¤¾ßºÍȨÍþµÄ¹Ù·½Îĵµ¡£Oracle9iÊÇÒµ½çµÚÒ»¸öÍêÕû¡¢¼òµ¥µÄÓÃÓÚ»¥ÁªÍøµÄÐÂÒ»´úÖÇÄÜ»¯µÄ¡¢Ð­×÷¸÷ÖÖÓ¦ÓõÄÈí¼þ»ù´¡¼Ü¹¹¡£ÏµÍ³ÒªÇó£ºÊÊÓÃÓ²¼þ»·¾³ ÖÁÉÙÐèÒª512MÄڴ棻½»»»Çø£ºÒ»°ãÒªÇóÊÇÄÚ´æµÄÁ½±¶£¬ÖÁÉÙÒ ......

OracleǧÍòÌõ¼Ç¼²åÈëÓë²éѯС½á

×î½ü×öÁ˸öÏîÄ¿£¬ÊµÏÖ¶Ô´æÔÚǧÍòÌõ¼Ç¼µÄ¿â±í½øÐвåÈë¡¢²éѯ²Ù×÷¡£Ô­ÒÔΪ¶ÔÊý¾Ý¿âµÄ²åÈë¡¢²éѯÊǼþºÜÈÝÒ×µÄÊ£¬¿É²»Öªµ±Êý¾Ý´ïµ½°ÙÍòÉõÖÁǧÍòÌõ¼¶±ðµÄʱºò£¬ÕâÒ»ÇÐËÆºõ±äµÃÏ൱À§ÄÑ¡£¼¸¾­ÕÛÌÚ£¬×ÜËãÍê³ÉÁËÈÎÎñ¡£
1¡¢ ±ÜÃâʹÓÃHibernate¿ò¼Ü
HibernateÓÃÆðÀ´ËäÈ»·½±ã£¬µ«¶ÔÓÚº£Á¿Êý¾ÝµÄ²Ù×÷ÏÔµÃÁ¦²»´ÓÐÄ¡£
¹ØÓÚ²åÈ룺 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ