ÏÂÔØoracleÌØ±ð°æ£¨Í¨Óð棩 - Oracle / »ù´¡ºÍ¹ÜÀí
http://www.oracle.com/technology/global/cn/software/products/database/xe/htdocs/102xewinsoft.html
ÊÇÔÚÕâ¸öÁ´½ÓÏÂÔØÂð£¬ÈçÏ£º
Oracle Êý¾Ý¿â 10g ÌØ±ð°æ£¨Í¨Óð棩
OracleXEUniv.exe£¨216,933,372 ×Ö½Ú£©
Õë¶ÔËùÓÐÓïÑÔ²¿ÊðµÄ¶à×Ö½Ú Unicode Êý¾Ý¿â£¬¸ÃÊý¾Ý¿âÖ÷Ò³µÄÓû§½çÃæ¿ÉÒÔʹÓÃÒÔÏÂÓïÑÔÏÔʾ£º°ÍÎ÷ÆÏÌÑÑÀÎÄ¡¢ÖÐÎÄ£¨¼òÌåºÍ·±Ì壩¡¢Ó¢ÎÄ¡¢·¨ÎÄ¡¢µÂÎÄ¡¢Òâ´óÀûÎÄ¡¢ÈÕÎÄ¡¢º«ÎĺÍÎ÷°àÑÀÎÄ¡£
¸Õ¸Õ½Ó´¥oracle£¬Ïë°²×°ÔÚwin7Ï£¬Õâ¸ö°æ±¾¿ÉÒÔÂð£¬Ð»Ð»£¡
Ö÷ÒªÓÃÁ˳õ¼¶Ñ§Ï°and²âÊÔ¡£¡£¡£
·Ç³£¸Ðл¡£ºÇºÇ¡£
´ËÁ´½Ó£ºhttp://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10203vista.html
32λµÄ10.2.0.3/£¬Ã²ËÆ»¹ÒªÏÂÔØ°²×°10.2.0.4²¹¶¡¡£OK¡£¡£
Ïà¹ØÎÊ´ð£º
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
Ð»Ð»ÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡
°²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓÆµ£¬¸ú×ÅÊÓÆµÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖá£
µã»÷½øÈ룺Database Configuration Assistant
1. ´´½¨Êý¾Ý¿â£»
......
oracleº¯ÊýÈçÏ£º
create or replace function P_WEB_GETCITYID
(
p_mobileNumber in VARCHAR2,
p_cityid out NUMBER
) Return NUMBER
IS
p_areacode varc ......
½ñÌìÓöµ½Ò»¸öºÜ¹îÒìµÄÎÊÌâ¡£ÎÒÔÚÒ»ÕűíÖÐÐÂÔöÁËÒ»¸ö×ֶΡ£È»ºóÓÃÈçϽű¾¸üÐÂÕâ¸ö×ֶεÄÖµ£º
SQL code:
update ibp_fund_information_tab set yield = 7.4520 where fund_code = '040003' and info_date = ......
ÏÖÔÚ ÎÒÓÐ Êý¾Ý¿â oracle_A £¬ÀïÃæÓÐÕűí Ϊ table_A, È»ºóÎÒÒª¶¨Ê±µÄ °Ñ ÁíÒ»¸öÊý¾Ý¿â oracle_B,ÀïÃæµÄÒ»Õűí table_BµÄÊý¾Ý£¬ÐÂÔö·ÅÈëtable_AÀȻºóÔÙÇå¿Õtable_B£¬ÇëÎÊÓ¦¸ÃÔõô×ö£¿
ÓÃд¸ö´æ´¢¹ý³Ì£¬È»ºóÓ ......