¼×¹ÇÎÄÍÆ³ö¡°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
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ËäȻѧϰ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 ......
¡¡¡¡* 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 ......