ÔÚOracleÖÐʹÓÃ×Ô¶¯µÝÔöÁÐ
ÔÚOracleÖÐʹÓÃ×Ô¶¯µÝÔöÁÐ
Oracle 沒ÓÐ類ËÆ MS-SQL ¿ÉÒÔÖ±½ÓÐÞ¸Ä欄λ屬ÐÔ£¬設¶¨³É×Ô動編號欄룬ËùÒÔÎÒ們±Ø須͸過 Sequence Îï¼þµÄ nextval ·½·¨£¬È¡µÃÆäÏÂÒ»個Öµ£¬È»áá將´ËÖµÐÂÔöÖÁ TABLE ÖУ¬製Ôì³öÓÐ×Ô動編號µÄЧ¹û¡£
½¨Á¢Sequence Îï¼þµÄ語·¨£º
CREATE SEQUENCE sequence_name
MINVALUE value
MAXVALUE value
START WITH value
INCREMENT BY value
CACHE value;
//½¨Á¢ Table
Create Table MarsTest(
ID_ NUMBER(10,0) NOT NULL,
Content VARCHAR2(250)
);
//½¨Á¢ Sequence
1.ʹÓÃ預設Öµ
Create Sequence Seq_MarsTest;
2.ʹÓÃ×Ô訂
Create Sequence Seq_MarsTest
MINVALUE 1
MAXVALUE 999999999999999999999999999
START WITH 1
INCREMENT BY 1
CACHE 20;
µ÷Óãº
//ÐÂÔö資ÁÏ
INSERT INTO MarsTest(ID_, Content)
VALUES (Seq_MarsTest.NEXTVAL, 'MarsTest');
從ÉÏÃæµÄÀý×Ó£¬ÎÒ們Ò²¿ÉÒÔ發現µ½£¬ÎÒ們ÊÇÔÚ INSERT 時£¬²Å將 Sequence 與 Table 產Éú關係£¬ËùÒÔ Sequence ²»Ö»ÊÇÌṩ給ÌØ¶¨ Table ʹÓã¬Ò²ÄÜ給ÆäËûÈÎÒ»個 Table ¹²Óá£
¸½£º
ÐÞ¸ÄÐòÁÐ
ALTER SEQUENCE dept_deptid_seq
INCREMENT BY 20
MAXVALUE 999999999999999999999999999
NOCACHE
NOCYCLE;
規則:
>±Ø須為ÐòÁеÄËùÓÐÕß»òÕß擁ÓÐALTERÌØ權
>ÐÞ¸Ä對ì¶ÒÔááµÄÐòÁÐ號ÉúЧ
>ÐòÁбØ須ÊDZ»刪³ýÈ»ááÖØÐÂ產Éú(ʹËùÓÐÏà關µÄ對ÏóʧЧ,並ÇÒʧȥÏà應µÄ關聯)
>ÐÞ¸Ä時還Òª滿×ãЩÆäËûµÄ驗證條¼þ,±ÈÈç說еÄMAXVALUE²»¿ÉÒÔ±È現ÔÚµÄÐòÁÐ號µÍ
刪³ýÐòÁÐ
DROP SEQUENCE dept_deptid_seq;
>±Ø須ÒªÊÇÐòÁеÄËùÓÐÕß»òÕßÓÐDROP ANY SEQUENCEµÄ權ÏÞ
Ïà¹ØÎĵµ£º
ORACLEÊý¾Ý¿â²åÈëÐÔÄܲâÊÔ
MKing
2010-3-8
²âÊÔ»·¾³»ù±¾ÐÅÏ¢£º
OS£ºWindows XP sp3
DB£ºOracle 9.2.0.1 δÆôÓù鵵
DBÖØ×öÈÕÖ¾Îļþ´óС£º100MB
Ó²ÅÌÐͺţºSAMSUNG HD161GJ£¨SATA-300,160G,7200rpm,8M cache£©
CPU£ºIntel Core2 E8400£¨3.0G£©
Äڴ棺2G
ͨ¹ýHD TuneµÃµ½µÄÓ²ÅÌ»ù±¾²âÊÔÐÅÏ ......
TNS-12518: TNS:listener could not hand off client connection
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 2: No such file or directory
½â¾ö·½·¨£º
ÒòΪÎÒʹÓõÄÊÇÐéÄâ»ú£¬ËùÒÔÔÚIPÉÏĬÈϵÄ×Ô¶¯· ......
Oracle µÄ¹ÜÀí¿ÉÒÔͨ¹ýOEM»òÕßÃüÁîÐнӿڡ£ Oracle ClusterwareµÄÃüÁ¿ÉÒÔ·ÖΪÒÔÏÂ4ÖÖ£º
½Úµã²ã£ºosnodes
ÍøÂç²ã£ºoifcfg
¼¯Èº²ã£ºcrsctl, ocrcheck,ocrdump,ocrconfig
Ó¦Óò㣺srvctl,onsctl,crs_stat
ÏÂÃæ·Ö±ðÀ´½éÉÜÕâЩÃüÁî¡£
Ò»£® ½Úµã²ã
Ö»ÓÐÒ»¸öÃüÁ¡¡osnodes£¬ Õâ ......
Âß¼ÉÏ£º
Single column µ¥ÐÐË÷Òý
Concatenated ¶àÐÐË÷Òý
Unique ΨһË÷Òý
NonUnique ·ÇΨһË÷Òý
Function-basedº¯ÊýË÷Òý
Domain ÓòË÷Òý
ÎïÀíÉÏ£º
Partitioned ·ÖÇøË÷Òý
NonPartitioned ·Ç·ÖÇøË÷Òý
B-tree£º
Normal Õý³£ÐÍBÊ÷
Rever Key ·´×ªÐÍBÊ÷
Bitmap λͼË÷Òý
Ë÷Òý½á¹¹£º
B-tree£º
ÊʺÏÓë´óÁ¿µÄÔö¡¢É ......
1z0-047 ×ÊÁϵÄ×îзÖÏí£¬ÏÂÃæÒ»Ð©ÌâÄ¿ÊÇ´Ó×îеÄÌâ¿âÖо«ÐÄÕûÀí³öÀ´µÄ£¬ÖÊÁ¿ºÜ¸ß£¬ÐèÒªµÄÅóÓÑ¿´¹ýÀ´µÄ°¡¡£
1. Which statements are true? (Choose all that apply.)
A. The data dictionary is created and maintained by the database administrator.
B. The data dictionary views can consist of joins of dictiona ......