OracleÖÐÐòÁÐsequence Ó÷¨
1£© ½¨Á¢ÐòÁÐÃüÁî
CREATE SEQUENCE [user.]sequence_name
[increment by n]
[start with n]
[maxvalue n | nomaxvalue]
[minvalue n | nominvalue];
INCREMENT BY£º Ö¸¶¨ÐòÁкÅÖ®¼äµÄ¼ä¸ô£¬¸ÃÖµ¿ÉΪÕýµÄ»ò¸ºµÄÕûÊý£¬µ«²»¿ÉΪ0¡£ÐòÁÐΪÉýÐò¡£ºöÂÔ¸Ã×Ó¾äʱ£¬È±Ê¡ÖµÎª1¡£
START WITH£ºÖ¸¶¨Éú³ÉµÄµÚÒ»¸öÐòÁкš£ÔÚÉýÐòʱ£¬ÐòÁпɴӱÈ×îСֵ´óµÄÖµ¿ªÊ¼£¬È±Ê¡ÖµÎªÐòÁеÄ×îСֵ¡£¶ÔÓÚ½µÐò£¬ÐòÁпÉÓɱÈ×î´óֵСµÄÖµ¿ªÊ¼£¬È±Ê¡ÖµÎªÐòÁеÄ×î´óÖµ¡£
MAXVALUE£ºÖ¸¶¨ÐòÁпÉÉú³ÉµÄ×î´óÖµ¡£
NOMAXVALUE£ºÎªÉýÐòÖ¸¶¨×î´óֵΪ1027£¬Îª½µÐòÖ¸¶¨×î´óֵΪ-1¡£
MINVALUE£ºÖ¸¶¨ÐòÁеÄ×îСֵ¡£
NOMINVALUE£ºÎªÉýÐòÖ¸¶¨×îСֵΪ1¡£Îª½µÐòÖ¸¶¨×îСֵΪ-1026¡£
2£© ¸ü¸ÄÐòÁÐÃüÁî
ALTERSEQUENCE [user.]sequence_name
[INCREMENT BY n]
[MAXVALUE n| NOMAXVALUE ]
[MINVALUE n | NOMINVALUE]£»
ÐÞ¸ÄÐòÁпÉÒÔ£º
? ÐÞ¸ÄδÀ´ÐòÁÐÖµµÄÔöÁ¿¡£
? ÉèÖûò³·Ïû×îСֵ»ò×î´óÖµ¡£
? ¸Ä±ä»º³åÐòÁеÄÊýÄ¿¡£
? Ö¸¶¨ÐòÁкÅÊÇ·ñÊÇÓÐÐò¡£
3£© ɾ³ýÐòÁÐÃüÁî
DROP SEQUENCE [user.]sequence_name£»
´ÓÊý¾Ý¿âÖÐɾ³ýÒ»ÐòÁС£
´´½¨Ò»¸öÐòÁкŵÄÓï¾ä£º
CREATE SEQUENCE EXAM_NO_SEQ
START WITH 1484
MAXVALUE 9999999999
MINVALUE 1
CYCLE
CACHE 20
NOORDER;
PBÖÐÈ¡ÐòÁкŵÄÓ÷¨£º
string v_exam_no
//»ñÈ¡ÉêÇëÐòºÅ
SELECT exam_no_seq.nextval INTO :v_exam_no from dual
using ghis_database;
if ghis_database.SQLCODE<>0 then
messagebox("","È¡¼ì²éÐòºÅ³ö´í")
return
end if
================================================================================
ÆäËû°æ±¾
oracleÖÐûÓÐ×ÔÔöÀàÐ͵Ä×ֶεģ¬ËùÒÔͨ³£Çé¿öÏÂÐèÒª¶¨ÒåÒ»¸
Ïà¹ØÎĵµ£º
http://www.oracle.com/technology/global/cn/obe/2day_dba/index.html
¿Î³ÌÁбí
1
¹ÜÀíÊý¾Ý¿âµÄÒªËØÊÇʲô£¨Ã»Óб¾Õ¶ÔÓ¦µÄ¸½¼Ó×ÊÁÏ£©
2
°²×° Oracle ºÍ¹¹½¨Êý¾Ý¿â
3
Oracle Enterprise Manager Êý¾Ý¿â¿ØÖÆÈëÃÅ
4
ÅäÖÃÍøÂç»·¾³
5
¹ÜÀí Oracle Àý³Ì
6
¹ÜÀíÊý¾Ý¿â´æ´¢½á¹¹
7
¹ÜÀíÓû§ºÍ°²È«ÐÔ
8
¹ÜÀíģʽ¶ ......
½â¾öOracle EMÎÞ·¨Æô¶¯
ORACLE 11g, EM ÎÞ·¨Æô¶¯µÄÎÊÌ⣬¿ÉÄÜÊÇIP¸ü¸ÄÁ˵ÄÔÒò£¬ËùÒÔÎÒʹÓÃÁËEMCAÃüÁîÖØÐÂÅäÖÃÁËÒ»ÏÂORACLE EM£¬¾ßÌå¹ý³ÌÈçÏ£º
I:\Documents and Settings\geshaoqing>emca -config dbcontrol db -repos recreate
EMCA ¿ªÊ¼ÓÚ 2007-10-12 11:16:40
EM Configuration Assistant 10.2.0.1.0 Õýʽ ......
µÚÒ»´ÎÔÚLinuxÉϰ²×°OracleµÄʱºòÅöµ½Õâ¸öÎÊÌ⣬ºÇºÇ¡£Ö®Ç°ÔÚLinuxÉϰ²×°Oracleʱ£¬Ò»°ã¶¼Ê¹ÓÃRedHatϵÁеÄLinux£¬ÔÚ°²×°¹ý³ÌÖУ¬ÐèÒª×ö´óÁ¿µÄ°²×°Ç°Öù¤×÷£¬Èç°²×°RPM°ü£¬´´½¨×éºÍÓû§£¬ÐÞ¸ÄÄں˲ÎÊý£¬Ð޸Ļ·¾³±äÁ¿µÈ¡£Õâ´ÎʹÓõÄÊÇRedFlagµÄAsianux 3£¬¶øÇÒ×Ô´øOracleµÄ°²×°¸¨Öú¹¤¾ßOrana ......
1. ½âÊÍÀ䱸·ÝºÍÈȱ¸·ÝµÄ²»Í¬µãÒÔ¼°¸÷×ÔµÄÓŵã
½â´ð£ºÈȱ¸·ÝÕë¶Ô¹éµµÄ£Ê½µÄÊý¾Ý¿â£¬ÔÚÊý¾Ý¿âÈԾɴ¦ÓÚ¹¤×÷״̬ʱ½øÐб¸·Ý¡£¶øÀ䱸·ÝÖ¸ÔÚÊý¾Ý¿â¹Ø±Õºó£¬½øÐб¸·Ý£¬ÊÊÓÃÓÚËùÓÐģʽµÄ
Êý¾Ý¿â¡£Èȱ¸·ÝµÄÓŵãÔÚÓÚµ±±¸·Ýʱ£¬Êý¾Ý¿âÈԾɿÉÒÔ±»Ê¹Óò¢ÇÒ¿ÉÒÔ½«Êý¾Ý¿â»Ö¸´µ½ÈÎÒâÒ»¸öʱ¼äµã¡£À䱸·ÝµÄÓŵãÔÚÓÚËüµÄ±¸·ÝºÍ»Ö¸´
²Ù×÷Ïൠ......