Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ѧϰ±Ê¼Ç1¡«2

    ÕâѧÆÚ×¼±¸»¨ÉÙÐíʱ¼äÑо¿Ò»ÏÂoracle£¬Ì¨Ê½»úµÄUbuntu²»Îȶ¨ÀÏ»µ£¬·ÅÆúÁËlinuxÉÏʹÓÃoracleµÄÏë·¨£¬ÔÚ×Ô¼º±Ê¼Ç±¾ÉÏ×°ÁËÒ»¸öoracle 10g express°æ±¾£¬Ñ§Ï°Ò»Ï¡£
    ±¾À´»¹ÏëÓÃÔƶËÐéÄ⻯һÏÂoracle£¬ÊµÑéʧ°Ü£¬ÀÏÀÏʵʵÈÃoracleÇÖÈëÎÒµÄϵͳ¡£¡£¡£囧
    °²×°Íê ......

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


»¹ÊǽèÖúoracle sql developerÀ´²Ù×÷oracle£¬sql plus»¹ÊÇÂé·³Ò»µã¡£
¼òµ¥¿´ÁËһϣ¬Óï¾ä»ù±¾É϶¼ºÍÆäËûÊý¾Ý¿âµÄsql²î²»¶à£¬¼Ç¼һϲ»Í¬µÄµØ·½¡£
ÈÕÆÚÀàÐͱ༭
update student set stu_birthday = to_date('2010-03-06 13:14:20','yyyy-MM-dd HH24:mi:ss');
ÐèҪʹÓÃto_date()º¯Êý£¬SQLÖв»Çø·Ö´óСд£¬MMºÍmm± ......

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

sql plus ±£´æsqlÓï¾ä
save 'd:\sql.txt';½«oracle»º´æÇøÖеÄsqlÓï¾ä´æÈëÎļþ¡£
get 'd:\sql.txt';´ËʱsqlÓï¾ä±»¼ÓÔص½oracle»º´æÇø£¬Ê¹ÓÃrun;ÃüÁîÖ´ÐÐsqlÓï¾ä¡£
@'d:\sql.txt';¼ÓÔØsqlÓï¾ä²¢Ö±½ÓÖ´ÐС£
oracleÖеĺ¯Êý
 
1. ת»»º¯Êý
TO_CHAR(number[,format])
½«Ò»¸öÊýֵת»»³ÉÓëÖ®µÈ¼ÛµÄ×Ö·û´®.Èç¹û²»Ö¸ ......

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

Ëø
²éѯÆäËûÓû§µÄ±í <Óû§Ãû.±íÃû>
Ëø¶¨Ä£Ê½£º
Ðм¶Ëø
Ðб»ÅÅËûÐÔËø¶¨
ÔÚijÐеÄËø±»ÊÍ·Å֮ǰ£¬ÆäËûÓû§²»ÄÜÐ޸ĴËÐÐ
ʹÓÃcommit rollbackÃüÁîÊÍ·ÅËø
»ñÈ¡Ðм¶Ëø
ʹÓÃinsert¡¢updateÓï¾ä£¬×Ô¶¯ÉÏÐм¶Ëø
ʹÓÃselect...for update [of ÁÐÃû] Óï¾ä×Ô¶¯»ñÈ¡Ðм¶Ëø
ÔÚ±íµÄÒ»Ðлò¶àÐзÅÖÃÅÅËûËø£¬ÓÃÓÚ·ÀÖÎÆäË ......

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