Oracle´´½¨ÐòÁÐ sequence
OracleÖеÄÐòÁкŹËÃû˼Òå¾ÍÊÇ´´½¨Ò»¸öÐòÁкţ¬¿ÉÒÔÔÚ²åÈë»òÕ߸üеÄʱºòµ÷Óã¬Ï൱ÓÚÊÇÒ»¸öÉú³ÉÆ÷
´´½¨Óï·¨£º
create sequence myse
increment by 1 --Ôö³¤¶È
start with
1 --´ÓÄÄÀïÔö¼Ó£¬¾ÍÊÇ˵ÏÂÒ»¸ö»ñÈ¡µÄÖµ´ÓÕâ¸öÖµ¿ªÊ¼
nomaxvalue --²»ÉèÖÃ×î´óÖµ
¶ÔÓ¦µÄ£ºmaxvalue 30¡¢
order --Ö¸¶¨Ò»¶¨ÍùÏÂÔö¼Ó
nocycle
--²»Ñ»·£¬CYCLEºÍNOCYCLE ±íʾµ±ÐòÁÐÉú³ÉÆ÷µÄÖµ´ïµ½ÏÞÖÆÖµºóÊÇ·ñÑ»·
cache 10
--CACHE(»º³å)¶¨Òå´æ·ÅÐòÁеÄÄÚ´æ¿éµÄ´óС£¬Ä¬ÈÏΪ20¡£NOCACHE±íʾ²»¶ÔÐòÁнøÐÐÄڴ滺³å¡£¶ÔÐòÁнøÐÐÄڴ滺³å£¬¿ÉÒÔ¸ÄÉÆÐòÁеÄÐÔÄÜ
Ð޸ģº
ÐòÁеÄijЩ²¿·ÖÒ²¿ÉÒÔÔÚʹÓÃÖнøÐÐÐ޸ģ¬µ«²»ÄÜÐÞ¸ÄSATRT
WITHÑ¡Ïî¡£¶ÔÐòÁеÄÐÞ¸ÄÖ»Ó°ÏìËæºó²úÉúµÄÐòºÅ£¬ÒѾ²úÉúµÄÐòºÅ²»±ä¡£ÐÞ¸ÄÐòÁеÄÓï·¨ÈçÏ£º
ALTER SEQUENCE emp_sequence
INCREMENT BY 10
MAXVALUE 10000
CYCLE -- µ½10000ºó´ÓÍ·¿ªÊ¼
NOCACHE ;
Ðè×¢Ò⣺
µÚÒ»´ÎNEXTVAL·µ»ØµÄÊdzõʼֵ£»ËæºóµÄNEXTVAL»á×Ô¶¯Ôö¼ÓÄ㶨ÒåµÄINCREMENT
BYÖµ£¬È»ºó·µ»ØÔö¼ÓºóµÄÖµ¡£CURRVAL
×ÜÊÇ·µ»Øµ±Ç°SEQUENCEµÄÖµ£¬µ«ÊÇÔÚµÚÒ»´ÎNEXTVAL³õʼ»¯Ö®ºó²ÅÄÜʹÓÃCURRVAL£¬·ñÔò»á³ö´í¡£Ò»´ÎNEXTVAL»áÔö¼ÓÒ»´ÎSEQUENCEµÄÖµ£¬ËùÒÔÈç¹ûÄãÔÚͬһ¸öÓï¾äÀïÃæʹÓöà¸öNEXTVAL£¬ÆäÖµ¾ÍÊDz»Ò»ÑùµÄ¡£
ɾ³ý£º
DROP SEQUENCE order_seq;
< type="text/javascript">
< type="text/javascript">
Ïà¹ØÎĵµ£º
ÔÚ´óÐ͵ÄÆóÒµÓ¦ÓûòÆóÒµ¼¶µÄÊý¾Ý¿âÓ¦ÓÃÖУ¬Òª´¦ÀíµÄÊý¾ÝÁ¿Í¨³£¿ÉÒÔ´ïµ½¼¸Ê®µ½¼¸°ÙGB£¬ÓеÄÉõÖÁ¿ÉÒÔµ½TB¼¶¡£ËäÈ»´æ´¢½éÖʺÍÊý¾Ý´¦Àí¼¼ÊõµÄ·¢Õ¹Ò²ºÜ¿ì£¬µ«ÊÇÈÔÈ»²»ÄÜÂú×ãÓû§µÄÐèÇó£¬ÎªÁËʹÓû§µÄ´óÁ¿µÄÊý¾ÝÔÚ¶Áд²Ù×÷ºÍ²éѯÖÐËٶȸü¿ì£¬OracleÌṩÁ˶ԱíºÍË÷Òý½øÐзÖÇøµÄ¼¼Êõ£¬ÒÔ¸ÄÉÆ´óÐÍÓ¦ÓÃϵͳµÄÐÔÄÜ¡£
ʹÓ÷ÖÇøµÄÓŵ㣠......
ÔÚOracleÊÇÌṩÁËnext_dayÇóÖ¸¶¨ÈÕÆÚµÄÏÂÒ»¸öÈÕÆÚ.
Óï·¨ : next_day( date, weekday )
date is used to find the next weekday.
weekday is a day of the week (ie: SUNDAY, MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY)
¿ÉÓÃÓÚ:
Oracle 9i, Oracle 10g, Oracle 11g
For example:
next_day('01- ......
Ò» Oracle¹«Ë¾¼ò½é
OracleÊÇÒóÐæ³öÍÁµÄ¼×¹ÇÎÄ(oracle bone inscriptions)µÄÓ¢ÎÄ·ÒëµÄµÚÒ»¸öµ¥´Ê
Oracle¹«Ë¾ÊÇÈ«Çò×î´óµÄÐÅÏ¢¹ÜÀíÈí¼þ¼°·þÎñ¹©Ó¦ÉÌ£¬³ÉÁ¢ÓÚ1977Ä꣬×ܲ¿Î»ÓÚÃÀ¹ú¼ÓÖÝ Redwood shore
Oracle¹«Ë¾ÒòÆ临ÔӵĹØϵÊý¾Ý¿â²úÆ·¶øÎÅÃû¡£OracleµÄ¹ØϵÊý¾Ý¿âÊÇÊÀ½çµÚÒ»¸öÖ§³ÖSQLÓïÑÔµÄÊý¾Ý¿â
OracleÔÚ³¬¹ý ......
Oracle Connect ByÓ÷¨
oracleÖеÄselectÓï¾ä¿ÉÒÔÓÃSTART WITH...CONNECT BY PRIOR×Ó¾äʵÏֵݹé²éѯ£¬connect by Êǽṹ»¯²éѯÖÐÓõ½µÄ£¬Æä»ù±¾Óï·¨ÊÇ£º
select ... from <TableName>
where <Conditional-1>
start with <Conditional-2>
connect by <Conditional-3>
;
<Conditi ......