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

´î½¨Oracle 10g Proc+VS2008¿ª·¢»·¾³

1¡¢ÏÂÔØ°²×°Microsoft Visual Studio 2008£º
     ÏÂÔØµØÖ·£ºhttp://www.microsoft.com/downloads/details.aspx?FamilyId=83C3A1EC-ED72-4A79-8961-25635DB0192B&displaylang=zh-cn£¬Õâ¸öÊÇ“Visual Studio 2008 רҵ°æ£¨90 ÌìÊÔÓð棩”¡£
     °²×°²½ÖèÂÔ¡£
2¡¢ÏÂÔØ°²×°Oracle Êý¾Ý¿â 10g µÚ 2 °æ£¬ÏÂÔØµØÖ·£ºhttp://download.oracle.com/otn/nt/oracle10g/10203/10203_vista_w2k8_x86_production_db.zip£»
     °²×°²½ÖèÂÔ¡£
3¡¢ ÅäÖÃVS2008£º¹¤¾ß->Ñ¡Ïî->ÏîÄ¿ºÍ½â¾ö·½°¸->VC++Ŀ¼£º
     ½«ÉÏÃæÐèÒªÒýÓõİü·¾¶Ìí¼Óµ½ÒÔÏÂÅäÖÃÏîÖУº
           1£©°üº¬Îļþ£ºD:\oracle\product\10.2.0\db_1\precomp\public
           2£©ÒýÓÃÎļþ£ºD:\oracle\product\10.2.0\db_1\precomp\lib
           3£©¿âÎļþ£ºD:\oracle\product\10.2.0\db_1\precomp\lib
4¡¢Íê±Ï£¡
ÑéÖ¤¿ª·¢»·¾³
1¡¢Ð½¨VS2008ÏîÄ¿£ºWin32¿ØÖÆÌ¨Ó¦ÓóÌÐò
2¡¢ÔÚÏîÄ¿ÊôÐÔÒ³ÀïÅäÖû·¾³±äÁ¿£º
     Ìí¼ÓÒÔÏÂÅäÖãº
           1£©Á´½ÓÆ÷->ÊäÈë->¸½¼ÓÒÀÀµÏorasql10.lib
4¡¢±àдPOCO´úÂ룬±àÒë³ÌÐò£»¿É²Î¿¼¡¶PROC++¿ò¼Ü¡·
5¡¢Íê±Ï


Ïà¹ØÎĵµ£º

Oracle ËÄÉáÎåÈ뺯Êý

ceil(number)   ´óÓÚ»òµÈÓÚµÄ×îСÕûÊý  
  floor(number)   СÓÚ»òµÈÓÚµÄ×î´óÕûÊý  
  trunc(number,m)   ÔÚÕûÊýnumberµÄmλÖýصôm¼°ÒÔºóµÄλÊý:  
  Èç:trunc(15.78,1)=15.7    
        trunc(15.78,-1)=15;  
  round ......

oracle constraints(3)

oracle constraints Ó¦ÓÃ
oracle constraints¿ÉÒÔÉèÖÃΪÁ¢¼´¼ì²é»òÕßµ±Ê±ÊÂÎñÌύʱ¼ì²é¡£
    ¿ÉÒÔÔÚ´´½¨Ô¼ÊøµÄʱºòÖ¸¶¨ÊÇdeferrable¡£È»ºóͨ¹ýset constraints xxx set deferred»òÕßimmediate,Ò²¿ÉÒÔÔÚseesion¼¶±ðÉ趨ËùÓÐÔ¼ÊøÎªdeferred»òÕßimmediate(alter seesion set constraints deferred/immediat ......

110¸öoracle³£Óú¯Êý×ܽá

1. ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii(A) A,ascii(a) a,ascii(0) zero,ascii( ) space from dual;
A A ZERO SPACE
--------- --------- --------- ---------
65 97 48 32
2. CHR
¸ø³öÕûÊý,·µ»Ø¶ÔÓ¦µÄ×Ö·û;
SQL> select chr(54740) zhao,chr(65) chr65 from dual;
ZH C
-- -
ÕÔ A
......

Oracle Workflows Access Protection Concepts

Oracle Workflows Access Protection Concepts
As a workflow developer, you can use access protection to allow or discourage “customers” of your workflows from modifying your “seed data” workflow definitions.
×÷Ϊ¹¤×÷Á÷¿ª·¢Õߣ¬Äã¿ÉÒÔÀûÓ÷ÃÎÊ¿ØÖƱ£»¤È¨ÏÞÀ´ÔÊÐí»ò×èÖ¹¹¤×÷Á÷µÄÊ¹Ó ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ