ÏÂÔØ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¡£¡£
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
oracleº¯ÊýÈçÏ£º
create or replace function P_WEB_GETCITYID
(
p_mobileNumber in VARCHAR2,
p_cityid out NUMBER
) Return NUMBER
IS
p_areacode varc ......
ͨ¹ýNAME×Ö¶ÎÌõ¼þ²éѯһ¸öÊý¾Ý±í£¬¼ÙÉèÎÒÓÐ100¸öÐÕÃû£¬ÓÐÒÔÏÂÁ½¸ö·½·¨£¬
·½·¨1£º
°Ñ100¸öName ×é³ÉÒ»¸öSQLÓï¾ä£¬±ÈÈç Select * from tmp_table where Name='ÕÅÈý' or Name ='ÀîËÄ' Or ...Or Name='µÚÒ»°Ù¸öÐÕÃû'
......
½ñÌìÓöµ½Ò»¸öºÜ¹îÒìµÄÎÊÌâ¡£ÎÒÔÚÒ»ÕűíÖÐÐÂÔöÁËÒ»¸ö×ֶΡ£È»ºóÓÃÈçϽű¾¸üÐÂÕâ¸ö×ֶεÄÖµ£º
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£¬ÇëÎÊÓ¦¸ÃÔõô×ö£¿
ÓÃд¸ö´æ´¢¹ý³Ì£¬È»ºóÓ ......