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ÈçºÎ¼Ç¼Óû§µÄµÇ½ÐÅÏ¢
¿ÉÒÔ×öÒ»¸ö´¥·¢Æ÷
ÓÃÒÔϵķ½Ê½¿ÉÒÔ¼à¿ØµÇÈëµÇ³öµÄÓÃ戶:
´´½¨Ò»ÕżÇ¼µÇ¼TABLE£¬ÈçÏ£º
CREATE TABLE SYSTEM.LOGIN_LOG
(
SESSION_ID &nb ......
LinuxÏÂOracle×Ô¶¯±¸·Ý½Å±¾
http://freeglad.javaeye.com/blog/586444
½Å±¾Îļþ£º
backup.sh
rq=`date '+%Y%m%d%H%M'`
su - oracle -c "exp zjhk/zjhk_123 owner=zjhk file=/home/oracle/zjhk_$rq.dmp"
cronÊÇÒ»¸ölinuxÏµĶ¨Ê±Ö´Ðй¤¾ß£¬¿ÉÒÔÔÚÎÞÐèÈ˹¤¸ÉÔ¤µÄÇé¿öÏÂÔËÐÐ×÷Òµ¡£ÓÉÓÚCron ÊÇLinuxµÄÄÚÖ÷þÎñ£¬µ«Ëü²»×Ô¶ ......
ϵͳȨÏÞ£º »ØÊÕʱ²»»á²úÉú¼¶Áª»ØÊÕ
conn / as sysdba;
create user t1 identified by t1;
create user t2 identified by t2;
grant connect to t1,t2;
grant create table, create view to t1 with admin option;
conn t1/t1
grant create table to t2;
conn / as sysdba;
select * from dba_sys_privs where gra ......
µ±ÓÃsubmit½¨JOBʱ£¬JOBIDÓÉϵͳ×Ô´øSEQUENCE£ºsys.JOBSEQÉú³É¡£
Èç¹ûÒ»¶Îʱ¼äºóJOBID¹ý´ó£¬¿ÉÒÔDROP SEQUENCE sys.JOBSEQ;ÔÙÖØ½¨
create sequence JOBSEQ
minvalue 1
maxvalue 999999999999
start with 1
increment by 1
cache 20;
À´ÖØÐ¿ªÊ¼JOBID¡£
¿ÉÒÔÓÃÏÂÃæÓï¾ä¸üÐÂÒѾ½¨Á¢µÄJOBID£º
UPDATE sys.Job$
SE ......