Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÔÚ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ѧϰ±Ê¼Ç11

´Ø£º
Óй«¹²ÁеÄÁ½¸ö»ò¶à¸ö±íµÄ¼¯ºÏ
´Ø±íÖеÄÊý¾Ý´æ´¢ÔÚ¹«¹²Êý¾Ý¿éÖÐ
´Ø¼ü£º
Ψһ±êʶ·û
´´½¨´Ø£º
¼õÉÙI/O²Ù×÷£¬¼õÉÙ´ÅÅ̿ռ䣬µ«ÊDzåÈëÐÔÄܽµµÍ¡£
Á½ÕűíÖÐÓй²Í¬µÄÁУ¬±ÈÈçѧÉú±íÖÐÓа༶±àºÅ£¬°à¼¶±íÖÐÒ²Óа༶±àºÅ£¬¿ÉÒÔ½«°à¼¶±àºÅ´æ·ÅÔÚ´ØÖÐ
create cluster ´ØÃû(
×Ö¶ÎÃû ÀàÐÍ
)tablespace ±íÃüÃû¿Õ¼ä;
cr ......

±±´óÇàÄñoracleѧϰ±Ê¼Ç12


¹ØϵÐÍÊý¾Ý¿âÀíÂÛÖÐ×Ö¶ÎÖµ±ØÐëÊǵ¥Öµ£¬¶øoracleÖÐÔÊÐíÔÚÒ»¸ö×Ö¶ÎÖд洢һ¸ö±íµÄÄÚÈÝ¡£
È磺Ա¹¤±íÖеÄÍâ¼ü ²¿ÃűàºÅ£¬oracleÖÐÕâ¸ö×ֶοÉÒÔ´æ·Å²¿ÃŵļǼ¶ø²¢²»ÊÇÒ»¸öÍâ¼ü£¬ÕâÑù²éѯʱºòµÄЧÂÊ»áÌá¸ß¡£
¿É±äÊý×飺
´´½¨´øÓпɱäÊý×éµÄ±í
´´½¨¿É±äÊý×é»ùÀàÐÍ
create or replace type »ùÀàÐÍÃû as object(×Ö¶ÎÇåµ¥); ......

oracleÁ¬½ÓÔ¶³ÌÊý¾Ý¿â

D:\oracle\product\10.2.0\db_2\NETWORK\ADMIN
6¡¢ÐÞ¸Äoracle°²×°Â·¾¶ÏÂD:\oracle\product\10.2.0\db_2\NETWORK\ADMIN\tnsnames.oraµÄtnsnames.oraÎļþ£¬Ìí¼Ó
XXX =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.12.42 ......

Oracle±¨TNS 12518µÄ´íÎó

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ÉÏĬÈϵÄ×Ô¶¯· ......

killtest ·ÖÏí×îеÄoracle 1z0 047Ìâ¿â×ÊÁÏÏÂÔØ

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ