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

¼×¹ÇÎÄÍƳö¡°Oracle¼Ó¿ì¼Æ»®¡±

 ¶þÁãÁã¾ÅÄêʮԶþÊ®ÈÕ£¬´ò´ÓÈýÄêÇ°ÍƳöOracle¼Ó½ô¼Æ»®ÒÔÀ´£¬¼×¹ÇÎĹ«Ë¾ÒѾ­Ôö¼ÓÁËÆß,000¶à¼ÒÖÎÀíÈí¼þÖÐÐÍÆóÒµ¿Í»§£¬µ±Ç°ÖÐÐÍÆóÒµ¿Í»§×ÜÁ¿ÒѾ­³¬¹ý25,000¼Ò¡£
͸¹ýÍƳöÂíÏòÖÐÐÍÆóÒµ¿Í»§µÄOracle¼Ó¿ì¼Æ»®Ð¹¦ÄÜ£¬°üÀ¨ÐÂʽ¼Ó¿ì¼Æ»®½â¾ö·½°¸¡¢OracleÆóÒµ¼ÓËÙÆ÷¡¢²ÆÎñÑ¡¼þºÍµ÷¶È²½ÖèµÈ£¬¼×¹ÇÎÄÔÚ²»Í£¶ÒÏÖ˳Àû¡£
ÃæÁÙÖÐÐÍÆóÒµµÄOracle¼Ó½ô¼Æ»®£¬¼ÓÉÏÓµÓÐÌض¨ÐÐÒµºÍÇøÓòÖ§Åä¼¼ÊõµÄOracleÓ¦ÓÃÈí¼þºÍÒµÎñ¼ÓËÙÆ÷£¬¿Éͨ¹ý¸ß¶ÈÕë¶ÔÐԺ͸ßËÙÖ§ÅäÈí¼þ°ü½â¾öºÜ¶àÒµÎñÎÊÌâ¡£OracleÆóÒµ¼ÓËÙÆ÷ ÊǸö¿É¸ßËÙÊ©ÐеŤ¾ß£¬¾­¹ý¼×¹ÇÎÄΪºÏ×÷»ï°éÌṩģ°æºÍ¾ßÓÐÐÐÒµ¼°ÇøÓòÕë¶ÔÐÔµÄÕ¼ÏÈʵ¼ù´¦ÖÃÁ÷³Ì£¬À´¼«´óµØ¼õСִÐÐʱ¼ä¡¢¼õµÍ¸´ÔӶȡ¢Àϱ¾Å¯·çÏÕ¡£
³ýÍ⣬Oracle¼Ó½ô¼Æ»®»¹ÍƳöÁËÒ»¸öеÄÃŵÚÍøÕ¾--midsize.oracle.com¡£ËüÊÇÒ»¸ö×ÊԴƽ̨ҲÊÇÒ»¸öºÏ×÷ƽ̨£¬Ä¿µÄÊÇΪÁ˱ãÀûÖÐÐÍÆóÒµ¿Í»§ºÍºÏ×÷»ï°éÕÒÑ°ÓÐÇøÓòºÍÐÐÒµÕë¶ÔÐԵĽâ¾ö·½°¸¡£
й¦ÄÜ
¼×¹ÇÎĹ«Ë¾µ±Ç°ÍƳöµÄÐÂOracle¼Ó½ô½â¾ö·½°¸°üÀ¨Ã³Ò×ÖÇÄÜ¡¢Æó¹¦ÒµÐ§ÖÎÀíÒÔ¼°ÍйÜÐÍCRM¡£
Óë´Ëͬʱ£¬¼×¹ÇÎÄ»¹ÁªÊÖHPÍƳöÁËÕë¶Ô²úÒµÖÆÔìÒµµÄHPºÍOracle×Éѯ¼Ó¿ì½â¾ö·½°¸¡£
¼×¹ÇÎÄ»¹¶ÒÏÖÁ˶ÔÆóÒµ¼ÓËÙÆ÷¹¤¾ßÌ×¼þµÄÀ©³ä£¬°üÀ¨Õë¶Ô¸ß¼¶ÐèÇó¹æ»®µÄOracle Demantra¡¢Oracle Agile²úÆ·ÐÔÃüÖÜÆÚÖÎÀí½â¾ö·½°¸¡¢Oracle Siebel CRMºÍ Oracle ÔËÔØÖÎÀí¡£
ÏÖ½ñ£¬Õë¶ÔOracleµç×ÓÉÌÎñÌ×¼þµÄOracleÆóÒµ¼ÓËÙÆ÷£¬ÔÚ20¸ö¹ú¼Ò8¸öÐÐÒµÖÐÔË×÷Solaris Ê®²Ù×÷ϵͳµÄSun 64-bitϵͳÉÏÊ©Ó㬺ϼÆÓг¬¹ý280¸öOracleÆóÒµ¼ÓËÙÆ÷ÔÚ35¸ö¹ú¼ÒÔËÓá£
Ïֽ׶ÎOracle¼Ó¿ì¼Æ»®¿ÉÌṩ¶àÖÖµ÷¶ÈÈ¡Éᣬ°üÀ¨OracleÍйܡ¢µÚÈý·½ÍйÜÒÔ¼°ÄÚ²¿µ÷¶ÈÐÍÍйܣ¬ËùÓÐÕâЩµ÷¶È¶¼Ìṩ¶¨×ö»¯µÄ·þÎñ°üÀ´Âú×ãÿ¸ö¿Í»§µÄ¶ÀÌØÐèÇó¡£
ÔÚеÄOracle¼Ó¿ì¼Æ»®ÃŵÚ-- midsize.oracle.comÖУ¬°üÔÐÓÐÒ»¸öºÏ×÷»ï°éÊг¡£¨Partner Marketplace£©°æ¿é£¬ËüÄÜÏàÖú¿Í»§ºÜ¼òÂÔÕÒ³öOracleÓ¦ÓÃÈí¼þºÍOracle¼Ó½ô¼Æ»®½â¾ö·½°¸µÄ׼ȷ½áºÏ¡£
±¾ÎÄÀ´Ô´£º
ÎÒµÄÒì³£Íø
Java Exception
Dotnet Exception
Oracle Exception


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

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

ÀûÓÃoracle¿ìÕÕdblink½â¾öÊý¾Ý¿â±íͬ²½ÎÊÌâ


±¾ÊµÀýÒÑÍêȫͨ¹ý²âÊÔ,µ¥Ïò,ÓÖÏòͬ²½¶¼¿ÉʹÓÃ.
--Ãû´Ê˵Ã÷£ºÔ´——±»Í¬²½µÄÊý¾Ý¿â
            Ä¿µÄ——Ҫͬ²½µ½µÄÊý¾Ý¿â
Ç°6²½±ØÐëÖ´ÐÐ,µÚ6ÒÔºóÊÇһЩ¸¨ÖúÐÅÏ¢.
--1¡¢ÔÚÄ¿µÄÊý¾Ý¿âÉÏ£¬´´½¨dblink
drop public database link dblink_or ......

PostgreSQL/Oracle Table

ͨ³£ÎÒ們ÔÚ½¨Á¢ PostgreSQL/Oracle 資ÁÏ庫µÄ時ºò, Èç¹ûҪʹÓà MySQL/MS-SQL identity À×ͬµÄ¹¦ÄÜ, ¾ÍÊÇÒª採Óà Sequence 來½¨Á¢, ¶ø為ÁËÿһ個 Table ¶¼ÓÐ獨Á¢µÄÐò號產ÉúÆ÷, ÎÒ們會½¨Á¢個別µÄ sequence.
ÀýÈç (PostgreSQL samp ......

Oracle ×î³£Óù¦Äܺ¯Êý¾­µä»ã×Ü

¡¡¡¡* SQL Group Function
*
s (num can be a column or ex
pression)¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡
¡¡¡¡(null values are ign
*
ored, default between distin
ct and all is all)¡¡¡¡¡¡¡¡¡¡¡¡
¡¡¡¡********************
***************
****************************
****************
¡¡¡¡AVG([distinct or all ......

½â¾öÐ޸ļÆËã»úÃûOracleÎÞ·¨Æô¶¯µÄÎÊÌâ

°²×°Oracle Database(10.0.2)ºó£¬Èç¹ûÐ޸ĻúÆ÷Ãûºó£¬
»áµ¼Ö¿ØÖÆÃæ°åµÄ·þÎñÖÐÆô¶¯OracleTNSLisener·þÎñÁ¢¿Ì¾ÍÍ£Ö¹¡£
ʹÓÃÃüÁîÐй¤¾ß£¬ÌáʾÈçÏ£º
(»úÆ÷ÃûÔ­À´Îª£ºANSWER-1738E000£¬¸ÄΪ£ºANSWER)
 
½â¾ö·½·¨£º
1>¹Øµô¿ØÖÆÃæ°åÖÐÓйØÓÚ Oracle Database µÄ·þÎñ¡£
2>ÐÞ¸Ä C:\oracle\product\10.2.0\db_1\NE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ