Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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µÄ權ÏÞ


Ïà¹ØÎĵµ£º

SQLServerºÍOracle³£Óú¯Êý¶Ô±È

SQLServerºÍOracleÊÇ´ó¼Ò¾­³£Óõ½µÄÊý¾Ý¿â£¬ÔÚ´Ë×ܽá³öÕâЩ³£Óú¯ÊýÒÔ¹©
´ó¼Ò²Î¿¼¡£
Êýѧº¯Êý
¡¡¡¡1.¾ø¶ÔÖµ
¡¡¡¡S:select abs(-1) value
¡¡¡¡O:select abs(-1) value from dual
¡¡¡¡2.È¡Õû(´ó)
¡¡¡¡S:select ceiling(-1.001) value
¡¡¡¡O:select ceil(-1.001) value from dual
¡¡¡¡3.È¡Õû£¨Ð¡£©
¡¡¡¡S:s ......

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

Óà javaµ÷ÓÃoracle´æ´¢¹ý³Ì×ܽá

1¡¢Ê²Ã´ÊÇ´æ´¢¹ý³Ì¡£´æ´¢¹ý³ÌÊÇÊý¾Ý¿â·þÎñÆ÷¶ËµÄÒ»¶Î³ÌÐò£¬ËüÓÐÁ½ÖÖÀàÐÍ¡£Ò»ÖÖÀàËÆÓÚSELECT²éѯ£¬ÓÃÓÚ¼ìË÷Êý¾Ý£¬¼ìË÷µ½µÄÊý¾ÝÄܹ»ÒÔÊý¾Ý¼¯µÄÐÎʽ·µ
»Ø¸ø¿Í»§¡£ÁíÒ»ÖÖÀàËÆÓÚINSERT»òDELETE²éѯ£¬Ëü²»·µ»ØÊý¾Ý£¬Ö»ÊÇÖ´ÐÐÒ»¸ö¶¯×÷¡£ÓеķþÎñÆ÷ÔÊÐíͬһ¸ö´æ´¢¹ý³Ì¼È¿ÉÒÔ·µ»ØÊý¾ÝÓÖ¿ÉÒÔÖ´Ðж¯×÷¡£
2¡¢Ê²Ã´Ê±ºòÐèÒªÓô洢¹ý³Ì
......

Oracle and IBM AIX 5.2 swapping and memory issues

Lately,
Jordan bank upgraded their ICBS banking software to Oracle 9i and
IDS9i. The Bank also moved from a decentralized to a centralized
system.
We were contracted to monitor and diagnose performance issues during the launching phase of the new system.
The IBM server was equipped with 32 GB o ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ