Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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/4£¬
»òÕ߯äÓ÷¨ÓëÆä¿ªÊ¼Éè¼ÆµÄÒâͼ²»Ïàͬ¡£Î´ÓõÄË÷ÒýÀ˷ѿռ䣬¶øÇÒ»¹»á½µµÍ DML
µÄËÙ¶È£¬ÓÈÆäÊÇ UPDATE ºÍ INSERT Óï¾ä;¿ØÊý¾Ý¿âË÷ÒýµÄʹÓã¬ÊÍ·ÅÄÇЩδ±»Ê¹ÓÃ
µÄË÷Òý£¬´Ó¶ø½Úʡά»¤Ë÷ÒýµÄ¿ªÏú£¬ÓÅ»¯sqlÐÔÄÜ
ÔÚ Oracle9i ֮ǰ£¬¼à¿ØË÷ÒýʹÓõÄÎ ......

windowÏÂÃüÁîÐÐÆô¶¯oracle·þÎñ

windowÏÂÃüÁîÐÐÆô¶¯oracle·þÎñ
2008-11-12 22:30
Ò»¡¢¶ÀÁ¢Æô¶¯£º
Microsoft Windows 2000 [Version 5.00.2195]
(C) °æÈ¨ËùÓÐ 1985-2000 Microsoft Corp.
#########################################################
¼ì²é¼àÌýÆ÷״̬£º
#########################################################
E:">lsnrctl s ......

´«ÖDz¥¿Í 2010 1 18Ê®Æß¡¢ORACLE(1)_°²×°Óë¹ÜÀí


Ò»¡¢Êý¾Ý¿âµÄÏà¹Ø¸ÅÄî
Êý¾Ý¿â£¨DB£©ÊÇÒ»¸ö°´Êý¾Ý½á¹¹À´´æ´¢ºÍ¹ÜÀíÊý¾ÝµÄ¼ÆËã»úÈí¼þϵͳ¡£
1¡¢Êý¾Ý¿â¹ÜÀíϵͳÓëÊý¾Ý¿âÓ¦ÓÃϵͳ
(1)Êý¾Ý¿â¹ÜÀíϵͳ£¨Database Management System£©
Êý¾Ý¿â¹ÜÀíϵͳ£¨DBMS£©ÊÇרÃÅÓÃÓÚ¹ÜÀíÊý¾Ý¿âµÄ¼ÆËã»úϵͳÈí¼þ¡£Êý¾Ý¿â¹ÜÀíϵͳÄܹ»ÎªÊý¾Ý¿âÌṩÊý¾ÝµÄ¶¨Òå¡¢½¨Á¢¡¢Î¬»¤¡¢²éѯºÍͳ¼ÆµÈ²Ù ......

oracle¹éµµÄ£Ê½ÐÞ¸Ä

C:\Documents and Settings\Administrator>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on ÐÇÆÚ¶þ 10ÔÂ 13 15:26:31 2009
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Á¬½Óµ½:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partition ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ