Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÖÐto_char()²ÎÊýÏê½â

 1 -  /  ,  . ; :
"text" ʱ¼ä·Ö¸ô·ûºÅ£¬³ýÁ˱ê×¼µÄ¼¸¸ö£¬»¹ÔÊÐíÓÃÎÄ×Ö×÷Ϊ·Ö¸î·ûºÅ¡£
ÀýÈç to_char(sysdate,'YYYY"Äê"mm"ÔÂ"dd"ÈÕ"')=2008Äê04ÔÂ24ÈÕ
 2 AD
A.D.  ¼´À­¶¡ÎÄAnno DominiµÄ¼òд£¬±íʾ¹«Ôª.»á¸ù¾ÝnlsµÄ²»Í¬×ª»»Îª¹«Ôª»òÕßadµÈ
ÎÞÌØÊâ×¢ÒâÊÂÏî
 3 AM
A.M.  ÉÏ ......

oracleͬÒå´Ê

----------------------------------------------------------------------------
Ïà¹Ø֪ʶ£ºOracle SYNONYM£¨Í¬Òå´Ê£©
----------------------------------------------------------------------------
ÊÇÒ»ÖÖÓ³Éä¹Øϵ£¬¿ÉÒÔÀí½âΪ±íµÄÒ»Ö̶ֹ¨±ðÃû
ͬÒå´ÊµÄºÃ´¦£º½¨Á¢Ò»¸öͬÒå´Ê¿ÉÒÔÅųýÒ»¸ö¶ÔÏóÃû×ÖµÄÏÞÖÆ
Èç¹ûÄãµÄ ......

oracle database link

Êý¾Ý¿âÖ®¼äµÄÁ´½Ó½¨Á¢ÔÚDATABASE LINKÉÏ¡£Òª´´½¨Ò»¸öDB LINK£¬±ØÐëÏÈ
ÔÚÿ¸öÊý¾Ý¿â·þÎñÆ÷ÉÏÉèÖÃÁ´½Ó×Ö·û´®¡£ 
1¡¢   Á´½Ó×Ö·û´®¼´·þÎñÃû£¬Ê×ÏÈÔÚ±¾µØÅäÖÃÒ»¸ö·þÎñÃû£¬µØÖ·Ö¸ÏòÔ¶³ÌµÄÊý¾Ý¿âµØÖ·£¬·þÎñÃûȡΪ½«À´ÄãҪʹÓõÄÊý¾Ý¿âÁ´Ãû£º
2¡¢´´½¨Êý¾Ý¿âÁ´½Ó£¬
½øÈëϵͳ¹ÜÀíÔ±SQL>²Ù×÷·ûÏ£¬ÔËÐÐÃüÁî£ ......

Oracle ÈçºÎ¶¨Òå×Ô¶¯ÔöÁ¿autocreamentµÄÖ÷¼üID?

MySQLµÄID·Ç³£·½±ã¶¨Ò壬ֻҪָ¶¨Æä×ֶεÄ×Ô¶¯ÔöÁ¿ÊôÐÔ¼´¿É¡£
µ«ÊÇOracle²»ÐУ¬ÐèÒª¶¨ÒåsequenceºÍtriggedr£¬µ±È»trigger¿ÉÒÔ²»¶¨Ò壬µ«ÊDz»·½±ã¡£
±í¶¨ÒåÈçÏ£º
CREATE TABLE GAME
(
  ID           
INTEGER      ......

ORACLE 10 ѧϰ±Ê¼ÇÃüÁî µÚÒ»¿Î¡£(¸¶Ê×ê¿)

ORACLE 10 ѧϰ±Ê¼ÇÃüÁîµÚÒ»¿Î¡£
1.
sqlplus /nolog
connect /as sysdba
alter user scott account unlock;
alter user scott identified by manager;
2.
grant  select on dept to nmerp;
revoke select on dept to nmerp;
select * from scott.dept
create table abc(a varchar2(10),b char(10));
alter& ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ