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

oracle ¹ØÓÚID×ÔÔöºÍÔÚÔ­ÓÐIDµÄ»ù´¡ÉÏ×ÔÔö

ÎÒÊǸöÐÂÊÖ,ËùÒÔÓÐЩ˵µÄ¿ÉÄܻ᲻ºÃ,Ï£ÍûÔĶÁÕâÎÄÕµÄÈ˼ûÁ°¡.
Ò»°ã¹ØÓÚID×ÔÔöµÄÍøÉ϶¼ÓÐÁ˺ܶàÁË,ºÇºÇ^ÄÇÎҾͼòµ¥µÄ˵һÏÂ: ÏÈ´´½¨±í£¬ÔÙ´´½¨ÐòÁÐ:
                  create sequence ÐòÁÐÃû
                   minvalue 1(ÉèÖÃ1Ϊ×îСֵ)
                     maxvalues 1.0E28(orcale ĬÈÏ×î´óֵΪ1.0E28)
                  start with 1  ( ³õʼֵΪ1)
                  increment by 1 (²½³¤Îª1 ,Ò²¾ÍÊÇÿ´ÎÔö¼Ó1)
                  noorder (Õâ¸öÊÇÉèÖÃΪ ²»ÅÅÐò)
                  nocycle (Õâ¸öÊÇÉèÖÃΪ ²»Ñ­»·)
                  nocache(Õâ¸öÊÇÉèÖÃΪ  ûÓлº³å)
   È»ºóÊÇ´´½¨Ò»¸ö´¥·¢Æ÷£º
             create trigger ´¥·¢Æ÷Ãû  before insert on ±íÃû for each row
             as
             begin
             select ÐòÁÐÃû.nextval into :new.id from dual;
             end;                     
   ÕâÑùÒ»¸öID×ÔÔö±í¾Í´´½¨ÁË.
  


Ïà¹ØÎĵµ£º

oracleµ÷ÓÃjavaÀà±éÀú´ÅÅÌÎļþ

ÀûÓÃoracle×Ô´øµÄutl_file°ü¿ÉÒÔ·ÃÎÊ´ÅÅÌÎļþ£¬µ«ÓиöÏÞÖÆ--ÎÞ·¨·ÃÎÊÎļþ¼Ð£¿Ê²Ã´Òâ˼ÄØ£¿¾ÍÊÇ˵oracleÖ»ÄÜ·ÃÎÊÖ¸¶¨µÄÎļþ£¬¶ø²»ÄÜ·ÃÎÊÎļþ¼ÐϵÄδ֪Îļþ¡£ËùÒÔ£¬Èç¹ûҪͨ¹ýoracleÈ¥±éÀúijָ¶¨Â·¾¶ÏµÄËùÓÐÎļþ£¬sorry, impossible! µ«ÊÇ£¬ÓÐÒ»ÖÖÌæ´ú·½°¸¿ÉÒÔÖúÄãÒ»±ÛÖ®Á¦£¡
ÖÚËùÖÜÖªjavaÖ®FileÀàÖ¸ÏòµÄ¿ÉÒÔÊÇĿ¼Ҳ¿ÉÒÔÊ ......

(ת)oracle 10g xe Îҵݲװʵ¼ù¼°¼òµ¥ÅäÖùý³Ì

Îҵݲװ¹ý³Ì
1¡¢±à¼­ /etc/apt/sources.list £º
    sudo cp /etc/apt/sources.list /etc/apt/sources.list.bak #±¸·Ý
    sudo gedit /etc/apt/sources.list
    ¼ÓÈëÏÂÃæÕâ¸öÔ´£º
        deb http://oss.oracle.com/debian unst ......

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

oracle±í·ÖÇø
oracleÔÊÐíÓû§¶Ô±í½øÐнøÒ»²½¹æ»®£¬¼´¶Ô±í½øÐнøÒ»²½²ð·Ö£¬½«±í·Ö³ÉÈô¸É¸öÂß¼­²¿·Ö£¬Ãð¸ö²»·Á³ÆÆäΪ±í·ÖÇø
·¶Î§·ÖÇø£º
¸ù¾Ý±íÖÐÁÐÖµµÄ·¶Î§½øÐзÖÇø
Óï·¨£ºPartition by range(×Ö¶ÎÃû)(
Partition ·ÖÇøÃû values less than (60), --60ÒÔÏÂ
Partition ·ÖÇøÃû values less than (75), --60¡«75
......

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


±í·ÖÇøά»¤£º
Ìí¼Ó·ÖÇø£º
Alter table student add partition ·ÖÇøÃû values less than(100);
ɾ³ý·ÖÇø£º
Alter table student drop partition ·ÖÇøÃû;
½Ø¶Ì·ÖÇø£º
Alter table student truncate partition ·ÖÇøÃû;
ºÏ²¢·ÖÇø£º
Alter table student merge partitions ·ÖÇøÃû,...,·ÖÇøÃû into partition зÖÇøÃû; ......

OracleÖм¸¸ö¹ØÓÚÈÕÆÚ·½ÃæµÄSQLʵÀý

¡í1:È¡µÃµ±Ç°ÈÕÆÚÊDZ¾Ôµĵڼ¸ÖÜ
SQL> select to_char(sysdate,'YYYYMMDD W HH24:MI:SS') from
dual;

TO_CHAR(SYSDATE,'YY
-------------------
20030327 4 18:16:09

SQL> select to_char(sysdate,'W') from dual;

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