¼×¹ÇÎÄÍƳö¡°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
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
create user Óû§Ãû identified by ÃÜÂë default tablespace ȱʡ±í¿Õ¼ä¡¡Temporary tablespace ÁÙʱ±í¿Õ¼ä;
grant connect,resource,dba to ̞;
¡¡¡¡
revoke unlimited tablespace from ̞;
¡¡¡¡
alter user ̞ quota 0 on Users;
alter user Óû§Ãû¡¡quot ......
SQLÖеĵ¥¼Ç¼º¯Êý
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 ......
Ò».Ëø
Êý¾Ý¿âʹÓÃËø£¨lock£© À´±£Ö¤Èκθø¶¨Ê±¿Ì×î¶àÖ»ÓÐÒ»¸öÊÂÎñÔÚÐ޸ĸø¶¨µÄÒ»¶ÎÊý¾Ý¡£ÊµÖÊÉϽ²£¬
ÕýÊÇËø»úÖƲÅʹ²¢·¢¿ØÖƳÉΪ¿ÉÄÜ¡£ÀýÈ磬Èç¹ûûÓÐijÖÖËø¶¨Ä£ÐÍÀ´×èÖ¹¶ÔͬһÐеIJ¢·¢¸üУ¬Êý¾Ý¿â¾Í
²»¿ÉÄÜÌṩ¶àÓû§·ÃÎÊ¡£²»¹ý£¬Èç¹ûÀÄÓûòÕßʹÓò»µ±£¬Ëø·´µ¹»á×è°²¢·¢ÐÔ¡£Èç¹ûÄã»òÊý¾Ý¿â±¾Éí²»±Ø
ÒªµØ¶ÔÊý¾Ý ......