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


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

¡¾oracle֪ʶÊÕ¼¯¡¿ÏµÍ³ÊÓͼºÍÓû§È¨ÏÞ

ORACLEÖÐÊý¾Ý×ÖµäÊÓͼ·ÖΪ3´óÀà,     ÓÃÇ°×ºÇø±ð£¬·Ö±ðΪ£ºUSER£¬ALL ºÍ DBA£¬Ðí¶àÊý¾Ý×ÖµäÊÓͼ°üº¬ÏàËÆµÄÐÅÏ¢¡£
USER_*:ÓйØÓû§ËùÓµÓеĶÔÏóÐÅÏ¢£¬¼´Óû§×Ô¼º´´½¨µÄ¶ÔÏóÐÅÏ¢
ALL_*£ºÓйØÓû§¿ÉÒÔ·ÃÎʵĶÔÏóµÄÐÅÏ¢£¬¼´Óû§×Ô¼º´´½¨µÄ¶ÔÏóµÄÐÅÏ¢¼ÓÉÏÆäËûÓû§´´½¨µÄ¶ÔÏ󵫸ÃÓû§ÓÐȨ·ÃÎʵÄÐÅÏ¢
DBA_* ......

ORACLE±êÇ©ÊÕ²Ø

@@servername:·µ»ØÔËÐÐSQL ServerÊý¾Ý¿â±¾µØ·þÎñÆ÷µÄÃû³Æ¡£
@@remserver:·µ»ØµÇ¼¼Ç¼ÖмÇÔØµÄÔ¶³ÌSQL Server·þÎñÆ÷µÄÃû³Æ¡£
@@connections:·µ»Ø×ÔÉÏ´ÎÆô¶¯SQL ServerÒÔÀ´Á¬½Ó»òÊÔͼÁ¬½ÓµÄ´ÎÊý£¬ÓÃÆä¿ÉÈùÜÀíÈËÔ±·½±ãµØÁ˽â½ñÌìËùÓÐÊÔͼÁ¬½Ó·þÎñÆ÷µÄ´ÎÊý¡£
@@cursor_rows:·µ»Ø×îºóÁ¬½ÓÉϲ¢´ò¿ªµÄÓαêÖе±Ç°´æÔڵĺϸñ ......

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
......

LinuxϵÄOracle 10g°²×°¼°ÅäÖÃ

Ò».×ÊÔ´ÐèÒª£º
ÖÁÉÙ1024 MBÎïÀíÄÚ´æ
1024£­2048 Ðè1.5±¶µÄ½»»¥¿Õ¼ä
2048£­8192 Ðè1±¶µÄ½»»¥¿Õ¼ä
8192£­ Ðè0.75±¶µÄ½»»¥¿Õ¼ä
ÖÁÉÙ400 MB /tmp ÁÙʱĿ¼¿Õ¼ä
oracleÈí¼þÐèÒª1.5 GB µ½ 3.5 GB ´ÅÅ̿ռä
ĬÈÏÊý¾Ý¿âÐèÒª1.2 GB
¶þ.²é¿´ÏµÍ³×ÊÔ´Ïà¹ØÓï ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ